summaryrefslogtreecommitdiff
path: root/mysql-test/t/distinct.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-07-09 00:55:07 +0300
committermonty@mashka.mysql.fi <>2003-07-09 00:55:07 +0300
commitd495656ac58a2fca1cc5b1ffd3e36985cbcb0baa (patch)
tree2d918b1ab9c85dbf33a1677a53e76b3447a7733c /mysql-test/t/distinct.test
parentd9e7072210704cbfdc619407158a3a7ac65ec506 (diff)
downloadmariadb-git-d495656ac58a2fca1cc5b1ffd3e36985cbcb0baa.tar.gz
Cleanups
Diffstat (limited to 'mysql-test/t/distinct.test')
-rw-r--r--mysql-test/t/distinct.test7
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;
-
-