diff options
| author | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-04-24 14:20:28 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-04-24 14:20:28 +0500 |
| commit | b9b1da75dd94d5e2c9b1affd68cd7929a8ff9f85 (patch) | |
| tree | 722024b494656e3d07277af0a22c2beab4590739 /mysql-test/t | |
| parent | 50e158402bf51521dce5fb69be9100cc8ccfebd7 (diff) | |
| parent | 4e387d6c0f46f53e6acfa0102d13ab81f1ce01a6 (diff) | |
| download | mariadb-git-b9b1da75dd94d5e2c9b1affd68cd7929a8ff9f85.tar.gz | |
Merge mysql.com:/home/ram/work/mysql-4.1-maint
into mysql.com:/home/ram/work/b27515/b27515.4.1
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/row.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/row.test b/mysql-test/t/row.test index d8d9a244134..6c66d45b942 100644 --- a/mysql-test/t/row.test +++ b/mysql-test/t/row.test @@ -83,4 +83,29 @@ drop table t1; SELECT ROW(2,10) <=> ROW(3,4); SELECT ROW(NULL,10) <=> ROW(3,NULL); +# +# Bug #27484: nested row expressions in IN predicate +# + +--error 1241 +SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,1)); +--error 1241 +SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,1),ROW(1,ROW(2,3))); +--error 1241 +SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,ROW(2,2,2))); +--error 1241 +SELECT ROW(1,ROW(2,3,4)) IN (ROW(1,ROW(2,3,4)),ROW(1,ROW(2,2))); + +--error 1241 +SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),(SELECT 1,1)); +--error 1241 +SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),(SELECT 1,1),ROW(1,ROW(2,4))); +--error 1241 +SELECT ROW(1,ROW(2,3)) IN ((SELECT 1,1),ROW(1,ROW(2,3))); + +--error 1241 +SELECT ROW(2,1) IN (ROW(21,2),ROW(ROW(1,1,3),0)); +--error 1241 +SELECT ROW(2,1) IN (ROW(ROW(1,1,3),0),ROW(21,2)); + # End of 4.1 tests |