~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/distinct.result

  • Committer: Monty Taylor
  • Date: 2008-07-30 22:14:34 UTC
  • mfrom: (239 drizzle)
  • mto: (202.3.5 gettextize)
  • mto: This revision was merged to the branch mainline in revision 243.
  • Revision ID: monty@inaugust.com-20080730221434-aqmamn79nvzgbvks
MergedĀ fromĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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');