diff options
author | unknown <gkodinov@mysql.com> | 2006-06-27 17:59:49 +0300 |
---|---|---|
committer | unknown <gkodinov@mysql.com> | 2006-06-27 17:59:49 +0300 |
commit | 6a4ec2e99dbc59317d2e3178cf48cbcb4af53a40 (patch) | |
tree | 84b7402efbe762fa258628ea34f82d36f147a126 /mysql-test/t/distinct.test | |
parent | d0412ab8e01e8410bc6b78bd33cdb844dc580a40 (diff) | |
parent | 4b36c1d8ffa33a9684342f7bae969b0e163c469f (diff) | |
download | mariadb-git-6a4ec2e99dbc59317d2e3178cf48cbcb4af53a40.tar.gz |
Merge mysql.com:/home/kgeorge/mysql/4.1/B16458
into mysql.com:/home/kgeorge/mysql/5.0/B16458
sql/sql_select.cc:
Auto merged
mysql-test/r/distinct.result:
merge 4.1->5.0
mysql-test/t/distinct.test:
merge 4.1->5.0
Diffstat (limited to 'mysql-test/t/distinct.test')
-rw-r--r-- | mysql-test/t/distinct.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/distinct.test b/mysql-test/t/distinct.test index 09f07c2852f..61250a7105e 100644 --- a/mysql-test/t/distinct.test +++ b/mysql-test/t/distinct.test @@ -349,6 +349,34 @@ SELECT DISTINCT 2, a, b FROM t2; SELECT DISTINCT a, 2, b FROM t2; DROP TABLE t1,t2; +# +# Bug#16458: Simple SELECT FOR UPDATE causes "Result Set not updatable" +# error. +# +CREATE TABLE t1(a INT PRIMARY KEY, b INT); +INSERT INTO t1 VALUES (1,1), (2,1), (3,1); +EXPLAIN SELECT DISTINCT a FROM t1; +EXPLAIN SELECT DISTINCT a,b FROM t1; +EXPLAIN SELECT DISTINCT t1_1.a, t1_1.b FROM t1 t1_1, t1 t1_2; +EXPLAIN SELECT DISTINCT t1_1.a, t1_1.b FROM t1 t1_1, t1 t1_2 + WHERE t1_1.a = t1_2.a; +EXPLAIN SELECT a FROM t1 GROUP BY a; +EXPLAIN SELECT a,b FROM t1 GROUP BY a,b; +EXPLAIN SELECT DISTINCT a,b FROM t1 GROUP BY a,b; + +CREATE TABLE t2(a INT, b INT, c INT, d INT, PRIMARY KEY (a,b)); +INSERT INTO t2 VALUES (1,1,1,50), (1,2,3,40), (2,1,3,4); +EXPLAIN SELECT DISTINCT a FROM t2; +EXPLAIN SELECT DISTINCT a,a FROM t2; +EXPLAIN SELECT DISTINCT b,a FROM t2; +EXPLAIN SELECT DISTINCT a,c FROM t2; +EXPLAIN SELECT DISTINCT c,a,b FROM t2; + +EXPLAIN SELECT DISTINCT a,b,d FROM t2 GROUP BY c,b,d; +CREATE UNIQUE INDEX c_b_unq ON t2 (c,b); +EXPLAIN SELECT DISTINCT a,b,d FROM t2 GROUP BY c,b,d; + +DROP TABLE t1,t2; # Bug 9784 DISTINCT IFNULL truncates data # |