diff options
| author | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
| commit | c0f40d14cc36f56f5b4dba288583acd345429e4e (patch) | |
| tree | c27e400395741740f2e230395445236b38db27c1 /mysql-test/r/case.result | |
| parent | 361067e9150f7fa57d5b2ac722ed55df9c14cc53 (diff) | |
| download | mariadb-git-c0f40d14cc36f56f5b4dba288583acd345429e4e.tar.gz | |
Added support for hex strings to mysqlimport
A lot of new tests to mysqltest
Fixed bug with BDB tables and autocommit
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result new file mode 100644 index 00000000000..66538c2fbee --- /dev/null +++ b/mysql-test/r/case.result @@ -0,0 +1,34 @@ +CASE "b" when "a" then 1 when "b" then 2 END +2 +CASE "c" when "a" then 1 when "b" then 2 END +NULL +CASE "c" when "a" then 1 when "b" then 2 ELSE 3 END +3 +CASE BINARY "b" when "a" then 1 when "B" then 2 WHEN "b" then "ok" END +ok +CASE "b" when "a" then 1 when binary "B" then 2 WHEN "b" then "ok" END +ok +CASE concat("a","b") when concat("ab","") then "a" when "b" then "b" end +a +CASE when 1=0 then "true" else "false" END +false +CASE 1 when 1 then "one" WHEN 2 then "two" ELSE "more" END +one +CASE 2.0 when 1 then "one" WHEN 2.0 then "two" ELSE "more" END +two +(CASE "two" when "one" then "1" WHEN "two" then "2" END) | 0 +2 +(CASE "two" when "one" then 1.00 WHEN "two" then 2.00 END) +0.0 +2.00 +case 1/0 when "a" then "true" else "false" END +false +case 1/0 when "a" then "true" END +NULL +(case 1/0 when "a" then "true" END) | 0 +NULL +(case 1/0 when "a" then "true" END) + 0.0 +NULL +case when 1>0 then "TRUE" else "FALSE" END +TRUE +case when 1<0 then "TRUE" else "FALSE" END +FALSE |