Hi I have no data in a table,
yet when I run a hash query over the results, I get a hash value:
When I perform the same test in PostgreSQL and Oracle then no hash value is returned, which is as expected. Note, when a table does have row data then the hash value matches to Oracle and PostgreSQL, but not so with empty tables. Could somebody suggest why ? Thanks |
It has to do with the LIST aggregate you are using as argument for the HASH function. SELECT LIST(null) by definition returns an empty string, and that prevents HASH from returning null. (The hash value in your sample is that of an empty string.) |