summaryrefslogtreecommitdiff
path: root/mysql-test/r/derived.result
diff options
context:
space:
mode:
authorgluh@gluh.mysql.r18.ru <>2003-09-04 17:12:20 +0500
committergluh@gluh.mysql.r18.ru <>2003-09-04 17:12:20 +0500
commit548d7dc948607e8ac228463f42c161aa50288086 (patch)
tree8ea687bd43f9b796927a8422267d6355895d3955 /mysql-test/r/derived.result
parentb34c3934d947f24776ee8b019cc7f65903864709 (diff)
downloadmariadb-git-548d7dc948607e8ac228463f42c161aa50288086.tar.gz
Fix for bug 1176
Diffstat (limited to 'mysql-test/r/derived.result')
-rw-r--r--mysql-test/r/derived.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result
index f9e52174469..944253bd527 100644
--- a/mysql-test/r/derived.result
+++ b/mysql-test/r/derived.result
@@ -196,3 +196,11 @@ drop table t1,t2;
SELECT a.x FROM (SELECT 1 AS x) AS a HAVING a.x = 1;
x
1
+create table a1 select 1 as a;
+select 2 as a from (select * from a1) b;
+ERROR 3D000: No Database Selected
+use test;
+select 2 as a from (select * from a1) b;
+a
+2
+drop table a1;