diff options
| author | unknown <monty@mysql.com> | 2004-03-26 14:44:52 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-03-26 14:44:52 +0200 |
| commit | cc11f6f351e8056dabf47cf47f8a29aa3b6261a2 (patch) | |
| tree | 5a81f759a80325c592c9d532356639e7dd272728 /mysql-test/r | |
| parent | 922818a79809d789976e64a8b4faabd305863a7c (diff) | |
| download | mariadb-git-cc11f6f351e8056dabf47cf47f8a29aa3b6261a2.tar.gz | |
Allow keys with 0 segements in MyISAM
This fixed a bug in SELECT DISTINCT when all selected parts where constants. (Bug #3203)
myisam/mi_create.c:
Allow keys with 0 segements.
mysql-test/r/myisam.result:
Test for problem with SELECT DISTINCT
mysql-test/t/myisam.test:
Test for problem with SELECT DISTINCT
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/myisam.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index cc541388a5c..1fd64377f12 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -431,3 +431,25 @@ a concat(b,'.') 1 a. 3 a . drop table t1; +create table t1 (a int not null); +create table t2 (a int not null, primary key (a)); +insert into t1 values (1); +insert into t2 values (1),(2); +select sql_big_result distinct t1.a from t1,t2 order by t2.a; +a +1 +select distinct t1.a from t1,t2 order by t2.a; +a +1 +select sql_big_result distinct t1.a from t1,t2; +a +1 +explain select sql_big_result distinct t1.a from t1,t2 order by t2.a; +table type possible_keys key key_len ref rows Extra +t1 system NULL NULL NULL NULL 1 Using temporary +t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct +explain select distinct t1.a from t1,t2 order by t2.a; +table type possible_keys key key_len ref rows Extra +t1 system NULL NULL NULL NULL 1 Using temporary +t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct +drop table t1,t2; |