diff options
| author | unknown <bar@bar.udmsearch.izhnet.ru> | 2002-07-29 17:34:20 +0500 |
|---|---|---|
| committer | unknown <bar@bar.udmsearch.izhnet.ru> | 2002-07-29 17:34:20 +0500 |
| commit | 8059cfabe04f97bc7acbf2b88de9306f1c5651cd (patch) | |
| tree | 378ff47db5c38cbbe00dd8807ac2eb8cddad3e36 /mysql-test/t | |
| parent | 2ed3a33855c1cc652c9d0ed3bf8de1636d5c61ce (diff) | |
| download | mariadb-git-8059cfabe04f97bc7acbf2b88de9306f1c5651cd.tar.gz | |
Rows order has been made more explicit
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/ctype_many.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/ctype_many.test b/mysql-test/t/ctype_many.test index 7db8f49919b..572784b8d34 100644 --- a/mysql-test/t/ctype_many.test +++ b/mysql-test/t/ctype_many.test @@ -147,12 +147,12 @@ SELECT lower(utf8_f) FROM t1 ORDER BY 1 DESC; SELECT t11.comment,t12.comment FROM t1 t11,t1 t12 WHERE CONVERT(t11.koi8_ru_f USING utf8)=t12.utf8_f -ORDER BY t11.koi8_ru_f; +ORDER BY t11.koi8_ru_f,t11.comment,t12.comment; SELECT t11.comment,t12.comment FROM t1 t11,t1 t12 WHERE t11.koi8_ru_f=CONVERT(t12.utf8_f USING koi8_ru) -ORDER BY t12.utf8_f; +ORDER BY t12.utf8_f,t11.comment,t12.comment; ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2 NOT NULL; |