summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2002-12-11 09:18:43 +0200
committerunknown <monty@mashka.mysql.fi>2002-12-11 09:18:43 +0200
commit4a81706558ca558abd22fbcaee2a41ecba66c2d7 (patch)
tree6269df71542c5b73ad0eb4740601b29234482f8f /mysql-test
parent540b243aceb1a868e4262056971242a69568a4e3 (diff)
parentf918dfc8b2e449fc55c6f8466bc1a923f47e5a44 (diff)
downloadmariadb-git-4a81706558ca558abd22fbcaee2a41ecba66c2d7.tar.gz
Merge work:/home/bk/mysql-4.1 into mashka.mysql.fi:/home/my/mysql-4.1
sql/field.cc: Auto merged sql/item.cc: Auto merged sql/item.h: Auto merged sql/procedure.h: Auto merged sql/sql_parse.cc: Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/case.result4
-rw-r--r--mysql-test/r/cast.result4
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result
index ec37c9a5763..18241a8fcc1 100644
--- a/mysql-test/r/case.result
+++ b/mysql-test/r/case.result
@@ -10,10 +10,10 @@ CASE "c" when "a" then 1 when "b" then 2 ELSE 3 END
3
select CASE BINARY "b" when "a" then 1 when "B" then 2 WHEN "b" then "ok" END;
CASE BINARY "b" when "a" then 1 when "B" then 2 WHEN "b" then "ok" END
-ok
+0
select CASE "b" when "a" then 1 when binary "B" then 2 WHEN "b" then "ok" END;
CASE "b" when "a" then 1 when binary "B" then 2 WHEN "b" then "ok" END
-ok
+0
select CASE concat("a","b") when concat("ab","") then "a" when "b" then "b" end;
CASE concat("a","b") when concat("ab","") then "a" when "b" then "b" end
a
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result
index 572b32c171c..2309de2354b 100644
--- a/mysql-test/r/cast.result
+++ b/mysql-test/r/cast.result
@@ -24,10 +24,10 @@ cast("A" as binary) = "a" cast(BINARY "a" as CHAR) = "A"
0 1
select cast("2001-1-1" as DATE), cast("2001-1-1" as DATETIME);
cast("2001-1-1" as DATE) cast("2001-1-1" as DATETIME)
-2001-1-1 2001-1-1
+2001-01-01 2001-01-01 00:00:00
select cast("1:2:3" as TIME);
cast("1:2:3" as TIME)
-1:2:3
+1:02:03
select cast("2001-1-1" as date) = "2001-01-01";
cast("2001-1-1" as date) = "2001-01-01"
0