1
--- r/type_datetime.result 2012-01-09 16:13:21.000000000 +0100
2
+++ r/type_datetime.reject 2012-02-10 16:23:40.000000000 +0100
4
delete from t1 where t > 0;
6
Table Op Msg_type Msg_text
7
+test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
8
test.t1 optimize status OK
10
Table Op Msg_type Msg_text
12
t1 CREATE TABLE `t1` (
13
`da` date DEFAULT '1962-03-03',
14
`dt` datetime DEFAULT '1962-03-03 00:00:00'
15
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
16
+) ENGINE=PBXT DEFAULT CHARSET=latin1
17
insert into t1 values ();
18
insert into t1 values ('2007-03-23 13:49:38','2007-03-23 13:49:38');
22
where id in (select id from t1 as x1 where (t1.cur_date is null));
23
id select_type table type possible_keys key key_len ref rows filtered Extra
24
-1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
25
+1 PRIMARY t1 ALL NULL NULL NULL NULL 1 100.00 Using where
26
+1 PRIMARY x1 ALL NULL NULL NULL NULL 1 100.00 Using where; FirstMatch(t1)
28
Note 1276 Field or reference 'test.t1.cur_date' of SELECT #2 was resolved in SELECT #1
29
-Note 1003 select 1 AS `id`,'2007-04-25 18:30:22' AS `cur_date` from (dual) where (('2007-04-25 18:30:22' = 0))
30
+Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`cur_date` AS `cur_date` from `test`.`t1` semi join (`test`.`t1` `x1`) where ((`test`.`x1`.`id` = `test`.`t1`.`id`) and (`test`.`t1`.`cur_date` = 0))
32
where id in (select id from t1 as x1 where (t1.cur_date is null));
36
where id in (select id from t2 as x1 where (t2.cur_date is null));
37
id select_type table type possible_keys key key_len ref rows filtered Extra
38
-1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
39
+1 PRIMARY t2 ALL NULL NULL NULL NULL 1 100.00 Using where
40
+1 PRIMARY x1 ALL NULL NULL NULL NULL 1 100.00 Using where; FirstMatch(t2)
42
Note 1276 Field or reference 'test.t2.cur_date' of SELECT #2 was resolved in SELECT #1
43
-Note 1003 select 1 AS `id`,'2007-04-25' AS `cur_date` from (dual) where (('2007-04-25' = 0))
44
+Note 1003 select `test`.`t2`.`id` AS `id`,`test`.`t2`.`cur_date` AS `cur_date` from `test`.`t2` semi join (`test`.`t2` `x1`) where ((`test`.`x1`.`id` = `test`.`t2`.`id`) and (`test`.`t2`.`cur_date` = 0))
46
where id in (select id from t2 as x1 where (t2.cur_date is null));
49
t1 CREATE TABLE `t1` (
50
`da` date DEFAULT '1962-03-03',
51
`dt` datetime DEFAULT '1962-03-03 00:00:00'
52
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
53
+) ENGINE=PBXT DEFAULT CHARSET=latin1
54
insert into t1 values ();
55
insert into t1 values ('2007-03-23 13:49:38','2007-03-23 13:49:38');