User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36
At table-checksum may be helpful to test whether two tables are equal, just as it is done with files.
- Microsoft SQL Server:
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM TableA
CHECKSUM TABLE tbl_name [, tbl_name] ... [ QUICK | EXTENDED ]
I'm mentioning checksum here, but actually any method to quickly compare two tables would be just fine.
I guess MonetDB could would exploit its column storage, and quickly compare the checksum of each corresponding pair of columns of two tables with the same schema and count.
Of course one could do
sql>\| md5sum -
But it would only be ok for interactive use and probably not very efficient.