diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-07-05 16:29:11 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-07-05 16:29:11 +0300 |
| commit | ee9237e0d8860fc2b4e67263a2335508ce2e0054 (patch) | |
| tree | 8f2cfc8b467a45c7cef96e785a7080fb862cb788 /mysql-test/r/distinct.result | |
| parent | 5fb59b2dd6f1c1d4fc8a01f7a473a2a611c2e649 (diff) | |
| download | mariadb-git-ee9237e0d8860fc2b4e67263a2335508ce2e0054.tar.gz | |
missing test case for DISTINCT .. LEFT ..
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index 53a20eeea0b..1dbccb65748 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -419,3 +419,12 @@ SELECT DISTINCT t1.a, t2.b FROM t1, t2 WHERE t1.a=1 ORDER BY t2.c; a b 1 4 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; +name +a +e +drop table t1; |