From c0f40d14cc36f56f5b4dba288583acd345429e4e Mon Sep 17 00:00:00 2001
From: "monty@donna.mysql.com" <>
Date: Thu, 28 Dec 2000 03:56:38 +0200
Subject: Added support for hex strings to mysqlimport A lot of new tests to
 mysqltest Fixed bug with BDB tables and autocommit

---
 mysql-test/t/case.test | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 mysql-test/t/case.test

(limited to 'mysql-test/t/case.test')

diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
new file mode 100644
index 00000000000..9e594675c19
--- /dev/null
+++ b/mysql-test/t/case.test
@@ -0,0 +1,21 @@
+#
+# Testing of CASE
+#
+
+select CASE "b" when "a" then 1 when "b" then 2 END;
+select CASE "c" when "a" then 1 when "b" then 2 END;
+select CASE "c" when "a" then 1 when "b" then 2 ELSE 3 END;
+select CASE BINARY "b" when "a" then 1 when "B" then 2 WHEN "b" then "ok" END;
+select CASE "b" when "a" then 1 when binary "B" then 2 WHEN "b" then "ok" END;
+select CASE concat("a","b") when concat("ab","") then "a" when "b" then "b" end;
+select CASE when 1=0 then "true" else "false" END;
+select CASE 1 when 1 then "one" WHEN 2 then "two" ELSE "more" END;
+select CASE 2.0 when 1 then "one" WHEN 2.0 then "two" ELSE "more" END;
+select (CASE "two" when "one" then "1" WHEN "two" then "2" END) | 0;
+select (CASE "two" when "one" then 1.00 WHEN "two" then 2.00 END) +0.0;
+select case 1/0 when "a" then "true" else "false" END;
+select case 1/0 when "a" then "true" END;
+select (case 1/0 when "a" then "true" END) | 0;
+select (case 1/0 when "a" then "true" END) + 0.0;
+select case when 1>0 then "TRUE" else "FALSE" END;
+select case when 1<0 then "TRUE" else "FALSE" END;
-- 
cgit v1.2.1