diff options
| author | bell@sanja.is.com.ua <> | 2003-05-22 09:52:22 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-05-22 09:52:22 +0300 |
| commit | 6360bea28dcb5ebba12e21173aa0f84e07341bf7 (patch) | |
| tree | 3dfea9a33ae593d529e5f367c4ac7ff05f7ea1f1 /mysql-test | |
| parent | 8d52377a5c7ac1880fba575056a8fa87feff00d8 (diff) | |
| parent | 2ad56b7a6dd27c82cfbd9f913af25bb8aca872c7 (diff) | |
| download | mariadb-git-6360bea28dcb5ebba12e21173aa0f84e07341bf7.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-top-4.1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 1a4701d8d0e..7c4d812a588 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -46,7 +46,7 @@ SELECT 1 FROM (SELECT 1 as a) as b HAVING (SELECT a)=1; 1 1 SELECT (SELECT 1), a; -Unknown column 'a' in 'field list' +Unknown column 'a' in 'checking transformed subquery' SELECT 1 as a FROM (SELECT 1) as b HAVING (SELECT a)=1; a 1 @@ -672,7 +672,6 @@ id EXPLAIN SELECT * FROM t2 WHERE id IN (SELECT 1+(select 1)); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ref id id 5 const 1 Using where; Using index -3 SUBQUERY NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1247 Select 3 was reduced during optimisation Note 1247 Select 2 was reduced during optimisation @@ -1018,7 +1017,7 @@ CREATE TABLE t1 SELECT (SELECT 1 as a UNION SELECT 1+1 limit 1,1) as a; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` bigint(1) NOT NULL default '0' + `a` bigint(17) NOT NULL default '0' ) TYPE=MyISAM CHARSET=latin1 drop table t1; create table t1 (a int); |