summaryrefslogtreecommitdiff
path: root/mysql-test/t/case.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-08-19 00:08:08 +0300
committermonty@mashka.mysql.fi <>2003-08-19 00:08:08 +0300
commit4f7512160bfd467e5d53c3e133e1842fac2737ce (patch)
treedf4f8c8cf4d399e322333c5516d5c19507b1fda8 /mysql-test/t/case.test
parent2263e3e51faba531a0a7055dbf706a6a8719ad70 (diff)
downloadmariadb-git-4f7512160bfd467e5d53c3e133e1842fac2737ce.tar.gz
After merge fixes
Use server character set if --default-character-set is not used Added convert_string() for more efficient alloc+character-set convert of strings
Diffstat (limited to 'mysql-test/t/case.test')
-rw-r--r--mysql-test/t/case.test8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
index 8aa17061174..4d4ceb062e4 100644
--- a/mysql-test/t/case.test
+++ b/mysql-test/t/case.test
@@ -60,14 +60,14 @@ CREATE TABLE t1 SELECT
SHOW CREATE TABLE t1;
DROP TABLE t1;
---error 1265
+--error 1266
SELECT CASE
WHEN 1
THEN _latin1'a' COLLATE latin1_danish_ci
ELSE _latin1'a' COLLATE latin1_swedish_ci
END;
---error 1268
+--error 1269
SELECT CASE _latin1'a' COLLATE latin1_general_ci
WHEN _latin1'a' COLLATE latin1_danish_ci THEN 1
WHEN _latin1'a' COLLATE latin1_swedish_ci THEN 2
@@ -90,9 +90,9 @@ CASE _latin1'a' WHEN _latin1'A' COLLATE latin1_bin THEN '1' ELSE 2 END
#
# Check COALESCE argument types aggregation
---error 1265
+--error 1266
CREATE TABLE t1 SELECT COALESCE(_latin1'a',_latin2'a');
---error 1265
+--error 1266
CREATE TABLE t1 SELECT COALESCE('a' COLLATE latin1_swedish_ci,'b' COLLATE latin1_bin);
CREATE TABLE t1 SELECT
COALESCE(1), COALESCE(1.0),COALESCE('a'),