diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-05 16:29:11 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-05 16:29:11 +0300 |
| commit | 421a462990e42eca893d902aeb590acdb64b4a51 (patch) | |
| tree | 8f2cfc8b467a45c7cef96e785a7080fb862cb788 /mysql-test/t/distinct.test | |
| parent | 57043e331c7f096cf32567aee0ae4c74d415add7 (diff) | |
| download | mariadb-git-421a462990e42eca893d902aeb590acdb64b4a51.tar.gz | |
missing test case for DISTINCT .. LEFT ..
Diffstat (limited to 'mysql-test/t/distinct.test')
| -rw-r--r-- | mysql-test/t/distinct.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/distinct.test b/mysql-test/t/distinct.test index ecce2409571..1cc692bd886 100644 --- a/mysql-test/t/distinct.test +++ b/mysql-test/t/distinct.test @@ -273,4 +273,11 @@ CREATE TABLE t2 (a int primary key, b int, c int); INSERT t2 VALUES (3,4,5); SELECT DISTINCT t1.a, t2.b FROM t1, t2 WHERE t1.a=1 ORDER BY t2.c; DROP TABLE IF EXISTS t1,t2; +CREATE table t1 ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=3 ; +INSERT INTO t1 VALUES (1, 'aaaaa'); +INSERT INTO t1 VALUES (3, 'aaaaa'); +INSERT INTO t1 VALUES (2, 'eeeeeee'); +select distinct left(name,1) as name from t1; +drop table t1; + |