diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-01-30 14:35:07 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-01-30 14:35:07 +0200 |
| commit | a0ddb72d52de3576fb0441e37e169f7cedd1fc1e (patch) | |
| tree | 5b530ee7187eee79fb4cff2beb75c3246b0a89cd /mysql-test | |
| parent | 251320477c1beee475bf50fbeed7431ddfe9fab8 (diff) | |
| download | mariadb-git-a0ddb72d52de3576fb0441e37e169f7cedd1fc1e.tar.gz | |
cyclic reference test removed, becouse testing of Item::fixed field apply more strict limitation
mysql-test/r/subselect.result:
test of cyclic reference false alarm
mysql-test/t/subselect.test:
test of cyclic reference false alarm
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 656703c1999..882a8e054c0 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -122,6 +122,9 @@ SELECT (SELECT 1.5,'c','a') = ROW(1.5,2,'a'); 0 SELECT (SELECT * FROM (SELECT 'test' a,'test' b) a); Cardinality error (more/less than 1 columns) +SELECT 1 as a,(SELECT a+a) b,(SELECT b); +a b (SELECT b) +1 2 2 create table t1 (a int); create table t2 (a int, b int); create table t3 (a int); diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 9a4c5590cc1..6a6133bc924 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -54,6 +54,8 @@ SELECT (SELECT 1.5,'c','a') = ROW(1.5,2,'a'); -- error 1239 SELECT (SELECT * FROM (SELECT 'test' a,'test' b) a); +SELECT 1 as a,(SELECT a+a) b,(SELECT b); + create table t1 (a int); create table t2 (a int, b int); create table t3 (a int); |