diff options
| author | unknown <timour@mysql.com> | 2005-03-10 11:50:55 +0200 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2005-03-10 11:50:55 +0200 |
| commit | dd843ee4b5276453a7c55062a80ef699b391ee35 (patch) | |
| tree | 99a7275b03c5fd41123593d19b3c520a355f397b /mysql-test/t | |
| parent | 16103a014fb5a26bac85736845209353642966f5 (diff) | |
| parent | 146df30f791246b93225b68ffaf6e93af4148f39 (diff) | |
| download | mariadb-git-dd843ee4b5276453a7c55062a80ef699b391ee35.tar.gz | |
Merge mysql.com:/home/timka/mysql/src/4.1-bug-7425
into mysql.com:/home/timka/mysql/src/4.1-dbg
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/select.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 53f569c773e..f7144f436df 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -1964,3 +1964,14 @@ SELECT * FROM t1 WHERE city LIKE '%london%' AND city='London'; DROP TABLE t1; +# +# Bug#7425 inconsistent sort order on unsigned columns result of substraction +# + +create table t1 (a int(11) unsigned, b int(11) unsigned); +insert into t1 values (1,0), (1,1), (1,2); +select a-b from t1 order by 1; +select a-b , (a-b < 0) from t1 order by 1; +select a-b as d, (a-b >= 0), b from t1 group by b having d >= 0; +select cast((a - b) as unsigned) from t1 order by 1; +drop table t1; |