diff options
| author | monty@mashka.mysql.fi <> | 2003-02-06 16:55:59 +0200 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-02-06 16:55:59 +0200 |
| commit | cf9668fd37cd5ee096033887251cfc653359b3e4 (patch) | |
| tree | af5a612629ae80e6237cf2b6ffc48017d60acef3 /mysql-test/t/order_by.test | |
| parent | 5ce0cd16b8b9fa05c781ac6ff4687133ed145d84 (diff) | |
| download | mariadb-git-cf9668fd37cd5ee096033887251cfc653359b3e4.tar.gz | |
Added START TRANSACTION syntax
Added ALL as parameter option for all group functions.
Make join handling uniform. This allows us to use ',', JOIN and INNER JOIN the same way.
Sort NULL last if DESC is used (ANSI SQL 99 requirement)
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 0ee6f901aae..8291a475d5e 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -227,7 +227,8 @@ explain select * from t1 where a = 2 and (b is null or b > 0) order by a desc,b desc; explain select * from t1 where a = 2 and b > 0 order by a desc,b desc; explain select * from t1 where a = 2 and b < 2 order by a desc,b desc; - +explain select * from t1 where a = 1 order by b desc; +select * from t1 where a = 1 order by b desc; # # Test things when we don't have NULL keys # |