diff options
| author | serg@serg.mysql.com <> | 2003-01-26 20:01:45 +0100 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2003-01-26 20:01:45 +0100 |
| commit | 2fd8380c0c059efdcbcfaf2d846d61784301b537 (patch) | |
| tree | df50eb7cf98c0be08e8b273f68ff68a337e0a9b8 /mysql-test/r/row.result | |
| parent | bea75a4211e23a3efea32c1d8e64fd628f770b32 (diff) | |
| download | mariadb-git-2fd8380c0c059efdcbcfaf2d846d61784301b537.tar.gz | |
making the keyword ROW for row items optional
Diffstat (limited to 'mysql-test/r/row.result')
| -rw-r--r-- | mysql-test/r/row.result | 19 |
1 files changed, 15 insertions, 4 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index f3522e05380..d86ae6c7961 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -1,6 +1,6 @@ drop table if exists t1; -select row(1,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)); -row(1,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)) +select (1,2,3) IN ((3,2,3), (1,2,3), (1,3,3)); +(1,2,3) IN ((3,2,3), (1,2,3), (1,3,3)) 1 select row(10,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)); row(10,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)) @@ -32,14 +32,23 @@ NULL select row('b',1.5,3) IN (row('b',NULL,4), row('a',1.5,3), row(1,3,3)); row('b',1.5,3) IN (row('b',NULL,4), row('a',1.5,3), row(1,3,3)) 0 -select row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,row(3,4))); -row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,row(3,4))) +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)); Cardinality error (more/less than 2 columns) 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 +SELECT (1,2,3)=(0,NULL,3); +(1,2,3)=(0,NULL,3) +0 +SELECT (1,2,3)=(1,NULL,3); +(1,2,3)=(1,NULL,3) +NULL +SELECT (1,2,3)=(1,NULL,0); +(1,2,3)=(1,NULL,0) +NULL SELECT ROW(1,2,3)=ROW(1,2,3); ROW(1,2,3)=ROW(1,2,3) 1 @@ -132,4 +141,6 @@ select 1 from t1 where ROW(1,1); Cardinality error (more/less than 1 columns) select count(*) from t1 order by ROW(1,1); Cardinality error (more/less than 1 columns) +select count(*) from t1 having (1,1) order by i; +Cardinality error (more/less than 1 columns) drop table t1; |