← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/func_sapdb.result

  • Committer: Monty Taylor
  • Date: 2008-07-05 22:08:52 UTC
  • mto: This revision was merged to the branch mainline in revision 77.
  • Revision ID: monty@inaugust.com-20080705220852-cqd9t6tfkhvlcf73
Removed HAVE_LONG_LONG, as this is now assumed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/func_sapdb.result
59
59
select datediff("1997-11-30 23:59:59.000001","1997-12-31");
60
60
datediff("1997-11-30 23:59:59.000001","1997-12-31")
61
61
-31
 
62
SET @@SQL_MODE="ALLOW_INVALID_DATES";
 
63
select datediff("1997-11-31 23:59:59.000001","1997-12-31");
 
64
datediff("1997-11-31 23:59:59.000001","1997-12-31")
 
65
-30
 
66
SET @@SQL_MODE="";
62
67
select datediff("1997-11-31 23:59:59.000001","1997-12-31");
63
68
datediff("1997-11-31 23:59:59.000001","1997-12-31")
64
69
NULL
189
194
time("1997-12-31 23:59:59.000001") as f9;
190
195
describe t1;
191
196
Field   Type    Null    Key     Default Extra
192
 
f1      date    YES             NULL    
 
197
f1      date    NO              0000-00-00      
193
198
f2      datetime        YES             NULL    
194
199
f3      time    YES             NULL    
195
200
f4      time    YES             NULL