diff options
author | unknown <paul@ice.snake.net> | 2004-06-15 15:41:22 -0500 |
---|---|---|
committer | unknown <paul@ice.snake.net> | 2004-06-15 15:41:22 -0500 |
commit | 1926d4ee3429f18ba7acd3e3b7436596fceb7f4b (patch) | |
tree | 2e1434689803b2fc266f9ab9b7054ff94464e13a /mysql-test/r/derived.result | |
parent | 29c22ddac81721e6e0da537149aa1922db86f1ce (diff) | |
parent | b1cecee05509b6f8637eb13b5ad9dbf9e46aaab2 (diff) | |
download | mariadb-git-1926d4ee3429f18ba7acd3e3b7436596fceb7f4b.tar.gz |
Merge paul@bk-internal.mysql.com:/home/bk/mysql-4.1
into ice.snake.net:/Volumes/ice2/MySQL/bk/mysql-4.1
Diffstat (limited to 'mysql-test/r/derived.result')
-rw-r--r-- | mysql-test/r/derived.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index dd4c32403b5..7442a156816 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -27,7 +27,7 @@ a y SELECT a FROM (SELECT 1 FROM (SELECT 1) a HAVING a=1) b; ERROR 42S22: Unknown column 'a' in 'having clause' SELECT a,b as a FROM (SELECT '1' as a,'2' as b) b HAVING a=1; -ERROR 23000: Column: 'a' in having clause is ambiguous +ERROR 23000: Column 'a' in having clause is ambiguous SELECT a,2 as a FROM (SELECT '1' as a) b HAVING a=2; a a 1 2 @@ -204,7 +204,7 @@ x 1 create table t1 select 1 as a; select 2 as a from (select * from t1) b; -ERROR 3D000: No Database Selected +ERROR 3D000: No database selected use test; select 2 as a from (select * from t1) b; a |