2780
2780
select * from t1 IGNORE INDEX(dob, weeks_worked_last_year, hours_worked_per_week) where hours_worked_per_week = 40 and weeks_worked_last_year = 52 and dob < '1949-11-21';
2785
--echo # MDEV-6322: The PARTITION engine can return wrong query results
2788
CustomerID varchar(5) DEFAULT NULL,
2789
CompanyName varchar(40) DEFAULT NULL,
2790
ContactName varchar(30) DEFAULT NULL,
2791
ContactTitle varchar(30) DEFAULT NULL,
2792
Address varchar(60) DEFAULT NULL,
2793
City varchar(15) DEFAULT NULL,
2794
Region varchar(15) DEFAULT NULL,
2795
PostalCode varchar(10) DEFAULT NULL,
2796
Country varchar(15) NOT NULL,
2797
Phone varchar(24) DEFAULT NULL,
2798
Fax varchar(24) DEFAULT NULL
2799
) ENGINE=MyISAM DEFAULT CHARSET=latin1
2800
PARTITION BY LIST COLUMNS(Country)
2801
(PARTITION p1 VALUES IN ('Germany','Austria','Switzerland','Poland'),
2802
PARTITION p2 VALUES IN ('USA','Canada','Mexico'),
2803
PARTITION p3 VALUES IN ('Spain','Portugal','Italy'),
2804
PARTITION p4 VALUES IN ('UK','Ireland'),
2805
PARTITION p5 VALUES IN ('France','Belgium'),
2806
PARTITION p6 VALUES IN ('Sweden','Finland','Denmark','Norway'),
2807
PARTITION p7 VALUES IN ('Venezuela','Argentina','Brazil')
2810
INSERT INTO t1 (CustomerID, City, Country) VALUES
2811
('ANATR','México D.F','Mexico'),
2812
('ANTON','México D.F','Mexico'),
2813
('BOTTM','Tsawassen','Canada'),
2814
('CENTC','México D.F','Mexico'),
2815
('GREAL','Eugene','USA'),
2816
('HUNGC','Elgin','USA'),
2817
('LAUGB','Vancouver','Canada'),
2818
('LAZYK','Walla Walla','USA'),
2819
('LETSS','San Francisco','USA'),
2820
('LONEP','Portland','USA');
2822
SELECT * FROM t1 WHERE Country = 'USA';