← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/sql-bench/crash-me

  • Committer: Mark Atwood
  • Date: 2011-06-29 22:17:36 UTC
  • mto: This revision was merged to the branch mainline in revision 2353.
  • Revision ID: me@mark.atwood.name-20110629221736-6kti9g8ooo9iwrrc
https://launchpad.net/bugs/420029
change tests/sql-bench/crash-me to match changes to TO_DAYS() and display of timestamps

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/sql-bench/crash-me
977
977
   ["NOW","now","now()",0,2],           # Any value is acceptable
978
978
   ["CURDATE","curdate","curdate()",0,2],
979
979
   ["CURTIME","curtime","curtime()",0,2],
 
980
   # Drizzle is different than MySQL in displaying timestamps
 
981
   # ["TIMESTAMPADD","timestampadd",
 
982
   #  "timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')",
 
983
   #  "1997-01-01 00:00:01",1],
980
984
   ["TIMESTAMPADD","timestampadd",
981
985
    "timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')",
982
 
    "1997-01-01 00:00:01",1],
 
986
     "1997-01-01 00:00:01.000000",1],
983
987
   ["TIMESTAMPDIFF","timestampdiff",
984
988
    "timestampdiff(SQL_TSI_SECOND,'1997-01-01 00:00:01',".
985
989
     " '1997-01-01 00:00:02')","1",0],
1568
1572
           "CHAR(a,EUR)",'16.08.1963',0],
1569
1573
          ["MAKEDATE",'makedate',"MAKEDATE(1963,228)"
1570
1574
           ,'make_date_r(1963,08,16)',0],
 
1575
          # Drizzle is different than MySQL in handling TO_DAYS
 
1576
          # Drizzle calculates the Julian Day Number
 
1577
          # ["TO_DAYS","to_days",
 
1578
          #   "to_days(make_date(1996,01,01))",729024,0],
1571
1579
          ["TO_DAYS","to_days",
1572
 
           "to_days(make_date(1996,01,01))",729024,0],
 
1580
            "to_days(make_date(1996,01,01))",2450084,0],
1573
1581
          ["ADD_MONTHS","add_months",
1574
1582
           "add_months(make_date(1997,01,01),1)","make_date_r(1997,02,01)",0], 
1575
1583
              # oracle the date plus n months