Hi! On 28.01.2011 07:23, Igor Babaev wrote:
At file:///home/igor/maria/maria-5.3-bug707827/
------------------------------------------------------------ revno: 2896 revision-id: igor@askmonty.org-20110128052302-09617460yxj1kck7 parent: igor@askmonty.org-20110127044523-9kvx1t3x3166hjyr committer: Igor Babaev<igor@askmonty.org> branch nick: maria-5.3-bug707827 timestamp: Thu 2011-01-27 21:23:02 -0800 message: Fixed LP bug #707827. This bug could manifest itself when hash join over a varchar column with NULL values in some rows was used. It happened because the function key_buf_cmp erroneously returned FALSE when one of the joined key fields was null while the second was not. Also fixed two other bugs in the functions key_hashnr and key_buf_cmp that could possibly lead to wrong results for some queries that used hash join over several columns with nulls. Also reverted the latest addition of the test case for bug #45092. It had been already backported earlier. It looks good to be pushed. Thank you for fixing it!