diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-26 15:06:05 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-26 15:06:05 +0200 |
| commit | 2ec108107db299b3984a06746388798acbd95b0b (patch) | |
| tree | f9a11c1a04e8ec893c0d1b6512219306a0f965d8 /mysql-test/t/derived.test | |
| parent | c9ba7c5f21582136747219c0f95be9a1f7b819ee (diff) | |
| download | mariadb-git-2ec108107db299b3984a06746388798acbd95b0b.tar.gz | |
Derived tables !
mysql-test/r/union.result:
small bug fixes in unions
BitKeeper/etc/ignore:
Added Docs/manual.texi.orig Docs/manual.texi.rej to the ignore list
mysql-test/t/union.test:
test for a bug fix in union's
sql/sql_union.cc:
bug fix for unions
Diffstat (limited to 'mysql-test/t/derived.test')
| -rw-r--r-- | mysql-test/t/derived.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test new file mode 100644 index 00000000000..4a3e8e86d4a --- /dev/null +++ b/mysql-test/t/derived.test @@ -0,0 +1,7 @@ +drop table if exists t1,t2; +CREATE TABLE t1 (a int not null, b char (10) not null); +insert into t1 values(1,'a'),(2,'b'),(3,'c'),(3,'c'); +CREATE TABLE t2 (a int not null, b char (10) not null); +insert into t2 values (3,'c'),(4,'d'),(5,'f'),(6,'e'); +select t1.a,t3.y from t1,(select a as y from t2 where b='c') as t3 where t1.a = t3.y; +drop table if exists t1.t2;
\ No newline at end of file |