diff options
| author | bell@sanja.is.com.ua <> | 2003-01-21 13:55:26 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-01-21 13:55:26 +0200 |
| commit | 372e2130e401b694c90b5d95a5ceaa5668f8569a (patch) | |
| tree | 9e72427611ac5057a8bf3051e0bd43678e33a8a2 /mysql-test | |
| parent | fc945987730e608ddd499f39c8232f5aa00a9633 (diff) | |
| download | mariadb-git-372e2130e401b694c90b5d95a5ceaa5668f8569a.tar.gz | |
fixed test of cardinality
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 3 |
2 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 04bf0575db3..2bbbd71f4cd 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -120,6 +120,8 @@ SELECT (SELECT 1.5,2,'a') = ROW(1.5,'c','a'); SELECT (SELECT 1.5,'c','a') = ROW(1.5,2,'a'); (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) 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 1dcbd9a282d..b506baa9fdd 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -51,6 +51,9 @@ SELECT (SELECT 'b',2,'a') = ROW(1.5,2,'a'); SELECT (SELECT 1.5,2,'a') = ROW(1.5,'c','a'); SELECT (SELECT 1.5,'c','a') = ROW(1.5,2,'a'); +-- error 1239 +SELECT (SELECT * FROM (SELECT 'test' a,'test' b) a); + create table t1 (a int); create table t2 (a int, b int); create table t3 (a int); |