diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-08-18 12:07:14 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-08-18 12:07:14 +0300 |
| commit | 341f82212642e3be70f9237bb9604ab725e6033f (patch) | |
| tree | 2f305675075aa9a83c6f6d14de574b91d7e63d49 /mysql-test/t/row.test | |
| parent | 4d2bf4befcf6a91978c60b9a402301e864ed999e (diff) | |
| download | mariadb-git-341f82212642e3be70f9237bb9604ab725e6033f.tar.gz | |
stop on NULL comparison only if it is allowed (BUG#12509)
mysql-test/r/row.result:
Correct NULL handling in row comporison
mysql-test/t/row.test:
Correct NULL handling in row comporison (BUG#12509)
sql/item_cmpfunc.cc:
stop on NULL comparison only if it is allowed
sql/item_cmpfunc.h:
support optimisation in case of processing WHERE/HAVING, where NULL and FALSE are equal
Diffstat (limited to 'mysql-test/t/row.test')
| -rw-r--r-- | mysql-test/t/row.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/row.test b/mysql-test/t/row.test index 4becef1c2b7..6301cc0f584 100644 --- a/mysql-test/t/row.test +++ b/mysql-test/t/row.test @@ -86,3 +86,9 @@ SELECT ROW(2,10) <=> ROW(3,4); SELECT ROW(NULL,10) <=> ROW(3,NULL); # End of 4.1 tests + +# +# Correct NULL handling in row comporison (BUG#12509) +# +SELECT ROW(1,1,1) = ROW(1,1,1) as `1`, ROW(1,1,1) = ROW(1,2,1) as `0`, ROW(1,NULL,1) = ROW(2,2,1) as `0`, ROW(1,NULL,1) = ROW(1,2,2) as `0`, ROW(1,NULL,1) = ROW(1,2,1) as `null` ; +select row(NULL,1)=(2,0); |