← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/case.test

  • Committer: Andrew Hutchings
  • Date: 2010-09-08 19:03:09 UTC
  • mfrom: (1750 staging)
  • mto: (1750.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1751.
  • Revision ID: andrew@linuxjedi.co.uk-20100908190309-mya1nu7xvo1fpvk8
Merge trunk into branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/case.test
66
66
SHOW CREATE TABLE t1;
67
67
DROP TABLE t1;
68
68
 
69
 
--error 1267
 
69
--error ER_CANT_AGGREGATE_2COLLATIONS
70
70
SELECT CASE 
71
71
  WHEN 1 
72
72
  THEN 'a' COLLATE utf8_bin 
73
73
  ELSE 'a' COLLATE utf8_swedish_ci
74
74
  END;
75
75
 
76
 
--error 1270
 
76
--error ER_CANT_AGGREGATE_3COLLATIONS
77
77
SELECT CASE 'a' COLLATE utf8_bin
78
78
  WHEN 'a' COLLATE utf8_danish_ci  THEN 1
79
79
  WHEN 'a' COLLATE utf8_swedish_ci THEN 2
96
96
#
97
97
# Check COALESCE argument types aggregation
98
98
 
99
 
--error 1267
 
99
--error ER_CANT_AGGREGATE_2COLLATIONS
100
100
CREATE TABLE t1 SELECT COALESCE('a' COLLATE utf8_swedish_ci,'b' COLLATE utf8_bin);
101
101
CREATE TABLE t1 SELECT 
102
102
 COALESCE(1), COALESCE(1.0),COALESCE('a'),