← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/second.test

  • Committer: Monty Taylor
  • Date: 2009-02-05 18:47:43 UTC
  • mfrom: (779.8.3 devel)
  • mto: This revision was merged to the branch mainline in revision 840.
  • Revision ID: mordred@inaugust.com-20090205184743-sn55g5b30qvdcy4h
Merged from me again.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/second.test
81
81
# A good datetime, interpreted int->string, should output 15
82
82
SELECT SECOND(20081130033015);
83
83
 
 
84
# A good datetime with subsecond component, interpreted int->string, should output 15
 
85
SELECT SECOND(20081130033015.01);
 
86
 
84
87
# A good time (according to MySQL, not Jay Pipes...), should output 15
85
88
SELECT SECOND(231115);
86
89
 
107
110
, blob_fld BLOB NOT NULL
108
111
);
109
112
 
110
 
# Should all output 19
 
113
# Should all output 19 except first two, which should output 0
111
114
INSERT INTO t1 VALUES (
112
115
20071130
113
116
, "2007-11-30"