diff options
author | bell@sanja.is.com.ua <> | 2002-12-26 17:48:19 +0200 |
---|---|---|
committer | bell@sanja.is.com.ua <> | 2002-12-26 17:48:19 +0200 |
commit | d85a01db2cd557cecc06cebe45502f54de233dac (patch) | |
tree | 786e6a63ce3687dca8b7a17fde81920919ba39d7 /mysql-test/r/derived.result | |
parent | 88e15cdbe84db036133d8502118a369942a2e9ca (diff) | |
download | mariadb-git-d85a01db2cd557cecc06cebe45502f54de233dac.tar.gz |
added FROM DUAL for derived tables
Diffstat (limited to 'mysql-test/r/derived.result')
-rw-r--r-- | mysql-test/r/derived.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 06d2e663221..6a3aa328175 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -1,3 +1,6 @@ +select * from (select 2 from DUAL) b; +2 +2 SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b; Unknown column 'a' in 'field list' SELECT 1 as a FROM (SELECT a UNION SELECT 1) b; |