diff options
| author | unknown <serg@serg.mylan> | 2004-05-15 11:20:42 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-05-15 11:20:42 +0200 |
| commit | 58063b0eb4b1a37b11616f9ae42e7526bc95ed22 (patch) | |
| tree | 02cedb93b3060a7ef0b294c53395d6497cfc26b1 /mysql-test/t/order_by.test | |
| parent | 7eb4c96fb150441bc062faa0b37e3f373d0ca040 (diff) | |
| download | mariadb-git-58063b0eb4b1a37b11616f9ae42e7526bc95ed22.tar.gz | |
bad old merge fixed
mysql-test/r/order_by.result:
buggy results bug#3681
mysql-test/t/order_by.test:
test for bug#3681
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 9ae9c1b5e12..465920deaed 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -80,6 +80,16 @@ select distinct i from t1 order by mod(i,2),i; drop table t1; # +# bug#3681 +# + +create table t1 ( pk int primary key, name varchar(255) not null, number varchar(255) not null); +insert into t1 values (1, 'Gamma', '123'), (2, 'Gamma Ext', '123a'), (3, 'Alpha', '001'), (4, 'Beta', '200c'); +select distinct t1.name as 'Building Name',t1.number as 'Building Number' from t1 order by t1.name asc; +drop table t1; + + +# # Order by on first index part # |