diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-12-26 17:48:19 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-12-26 17:48:19 +0200 |
| commit | 5265a1656ea58d9534ebadfbd45c662080f89bb0 (patch) | |
| tree | 786e6a63ce3687dca8b7a17fde81920919ba39d7 /mysql-test/r | |
| parent | 717656bb1c677610bfc02f65a7552263297fb2b1 (diff) | |
| download | mariadb-git-5265a1656ea58d9534ebadfbd45c662080f89bb0.tar.gz | |
added FROM DUAL for derived tables
Diffstat (limited to 'mysql-test/r')
| -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; |