diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-01-24 15:56:57 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-01-24 15:56:57 +0200 |
| commit | 9182786918011c6d77beee27c5deec2569f4b6c7 (patch) | |
| tree | 473c8368045ad26e77e622a13539edaebced6e96 /mysql-test/r/subselect.result | |
| parent | d514a06a86d689065590b0115799f06fa109a70b (diff) | |
| download | mariadb-git-9182786918011c6d77beee27c5deec2569f4b6c7.tar.gz | |
check that row elements have the same dimention that SELECT list elements in comporison between rows and subqueries added (BUG#8022)
mysql-test/r/subselect.result:
Comparison subquery and row with nested rows
mysql-test/t/subselect.test:
Comparison subquery and row with nested rows
sql/item_subselect.cc:
check that row elements have the same dimention that SELECT list elements
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index a7186c6953b..4a4cbcc38cd 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2174,3 +2174,11 @@ select row(1,2) != ALL (select * from t1); row(1,2) != ALL (select * from t1) 1 drop table t1; +create table t1 (a integer, b integer); +select row(1,(2,2)) in (select * from t1 ); +ERROR 21000: Operand should contain 2 column(s) +select row(1,(2,2)) = (select * from t1 ); +ERROR 21000: Operand should contain 2 column(s) +select (select * from t1) = row(1,(2,2)); +ERROR 21000: Operand should contain 1 column(s) +drop table t1; |