diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-07-09 00:55:07 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-07-09 00:55:07 +0300 |
| commit | 3c268e59eceb23bb2b62985b5f1166c6ac14fe2f (patch) | |
| tree | 2d918b1ab9c85dbf33a1677a53e76b3447a7733c /mysql-test/t/distinct.test | |
| parent | 5e817c53138f990eae300aca25e95f2c0862146e (diff) | |
| download | mariadb-git-3c268e59eceb23bb2b62985b5f1166c6ac14fe2f.tar.gz | |
Cleanups
mysql-test/t/distinct.test:
Cleanup
sql/log.cc:
Cleanup
sql/slave.cc:
Cleanup
sql/sql_delete.cc:
Cleanup
sql/sql_parse.cc:
Simple optimization
Diffstat (limited to 'mysql-test/t/distinct.test')
| -rw-r--r-- | mysql-test/t/distinct.test | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/t/distinct.test b/mysql-test/t/distinct.test index 1cc692bd886..79770a17baa 100644 --- a/mysql-test/t/distinct.test +++ b/mysql-test/t/distinct.test @@ -273,11 +273,14 @@ 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; + +# +# Test of LEFT() with distinct +# + 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; - - |