diff options
Diffstat (limited to 'mysql-test/r/row.result')
| -rw-r--r-- | mysql-test/r/row.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index 94186f254c4..ab60f714d82 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -36,7 +36,7 @@ select (1,2,(3,4)) IN ((3,2,(3,4)), (1,2,(3,4))); (1,2,(3,4)) IN ((3,2,(3,4)), (1,2,(3,4))) 1 select row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,4)); -ERROR 21000: Cardinality error (more/less than 2 columns) +ERROR 21000: Operand should contain 2 column(s) select row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,row(3,NULL))); row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,row(3,NULL))) NULL @@ -86,7 +86,7 @@ SELECT ROW('test',2,3.33)=ROW('test',2,3.33); ROW('test',2,3.33)=ROW('test',2,3.33) 1 SELECT ROW('test',2,3.33)=ROW('test',2,3.33,4); -ERROR 21000: Cardinality error (more/less than 3 columns) +ERROR 21000: Operand should contain 3 column(s) SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,33)); ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,33)) 1 @@ -97,7 +97,7 @@ SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,NULL)); ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,NULL)) NULL SELECT ROW('test',2,ROW(3,33))=ROW('test',2,4); -ERROR 21000: Cardinality error (more/less than 2 columns) +ERROR 21000: Operand should contain 2 column(s) create table t1 ( a int, b int, c int); insert into t1 values (1,2,3), (2,3,1), (3,2,1), (1,2,NULL); select * from t1 where ROW(1,2,3)=ROW(a,b,c); @@ -135,14 +135,14 @@ ROW(1,2,3) IN(row(a,b,c), row(1,2,3)) 1 drop table t1; select ROW(1,1); -ERROR 21000: Cardinality error (more/less than 1 columns) +ERROR 21000: Operand should contain 1 column(s) create table t1 (i int); select 1 from t1 where ROW(1,1); -ERROR 21000: Cardinality error (more/less than 1 columns) +ERROR 21000: Operand should contain 1 column(s) select count(*) from t1 order by ROW(1,1); -ERROR 21000: Cardinality error (more/less than 1 columns) +ERROR 21000: Operand should contain 1 column(s) select count(*) from t1 having (1,1) order by i; -ERROR 21000: Cardinality error (more/less than 1 columns) +ERROR 21000: Operand should contain 1 column(s) drop table t1; create table t1 (a int, b int); insert into t1 values (1, 4); |