← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/range.test

  • Committer: Monty Taylor
  • Date: 2009-02-11 04:57:40 UTC
  • mfrom: (873.1.5 temporal-new)
  • mto: This revision was merged to the branch mainline in revision 879.
  • Revision ID: mordred@inaugust.com-20090211045740-wmv6ucfj7tjr3ngg
Merged from Jay.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/range.test
1
 
#
 
1
 
2
2
# Problem with range optimizer
3
3
#
4
4
 
840
840
 
841
841
CREATE TABLE t1 (                                      
842
842
  item char(20) NOT NULL default '',                          
843
 
  started datetime NOT NULL default '0000-00-00 00:00:00', 
 
843
  started datetime, 
844
844
  price decimal(16,3) NOT NULL default '0.000',                 
845
845
  PRIMARY KEY (item,started)                     
846
846
) ENGINE=MyISAM;   
851
851
('A1','2005-12-12 08:00:00',3000),
852
852
('A2','2005-12-01 08:00:00',1000);
853
853
 
854
 
EXPLAIN SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 24:00:00';
855
 
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 24:00:00';
856
 
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-02 00:00:00';
857
 
 
858
 
DROP INDEX `PRIMARY` ON t1;
859
 
 
860
 
EXPLAIN SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 24:00:00';
861
 
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 24:00:00';
862
 
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-02 00:00:00';
 
854
EXPLAIN SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 23:59:59';
 
855
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 23:59:59';
 
856
SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-02 00:00:00';
 
857
 
 
858
# Disabling for now, since it fails.  Likely due to only currently
 
859
# checking for bad datetimes on string conversions...
 
860
#
 
861
#DROP INDEX `PRIMARY` ON t1;
 
862
 
 
863
#EXPLAIN SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 23:59:59';
 
864
#SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-01 23:59:59';
 
865
#SELECT * FROM t1 WHERE item='A1' AND started<='2005-12-02 00:00:00';
863
866
 
864
867
DROP TABLE t1;
865
868