← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/distinct.result

  • Committer: Brian Aker
  • Date: 2008-07-30 02:09:36 UTC
  • Revision ID: brian@tangent.org-20080730020936-8639dxun0mmtr72v
Syntax remove of char() (now maps to varchar).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/distinct.result
614
614
a
615
615
A
616
616
0
617
 
Warnings:
618
 
Warning 1292    Truncated incorrect DOUBLE value: 'A'
619
617
SELECT DISTINCT a FROM t1 WHERE a=0;
620
618
a
621
619
A
622
620
0
623
 
Warnings:
624
 
Warning 1292    Truncated incorrect DOUBLE value: 'A'
625
621
DROP TABLE t1;
626
622
CREATE TABLE t1 (a DATE);
627
623
INSERT INTO t1 VALUES ('1972-07-29'), ('1972-02-06');