← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/cast.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-12-17 04:48:59 UTC
  • mto: This revision was merged to the branch mainline in revision 1246.
  • Revision ID: osullivan.padraig@gmail.com-20091217044859-qorpkp4911zypfv3
Added some dtrace probes for tracing the optimizer.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/cast.result
72
72
cast('a  ' AS char(2)) as c4,
73
73
cast('a'   AS char(2)) as c5;
74
74
ERROR 22007: Truncated incorrect CHAR(2) value: 'abc'
 
75
select
 
76
cast('��'  AS char)    as c1,
 
77
cast('� '  AS char)    as c2,
 
78
cast('���' AS char(2)) as c3,
 
79
cast('�  ' AS char(2)) as c4,
 
80
cast('�'   AS char(2)) as c5;
 
81
c1      c2      c3      c4      c5
 
82
��      �       ��      �       �
 
83
Warnings:
 
84
Warning 1292    Truncated incorrect CHAR(2) value: '���'
 
85
Warning 1292    Truncated incorrect CHAR(2) value: '�  '
75
86
select cast("2001-1-1" as date) = "2001-01-01";
76
87
cast("2001-1-1" as date) = "2001-01-01"
77
88
1