DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (`col19` datetime DEFAULT NULL,`col49` tinyblob) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `test` VALUES ('1940-07-16 01:20:40',0x4765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F734765737461706F);
INSERT INTO `test` VALUES ('2005-09-05 21:28:00',0x6D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B696E676D616B);
INSERT INTO `test` VALUES ('1956-04-01 18:01:42',0x7661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E74737661756E7473766175);
INSERT INTO `test` VALUES ('2075-07-20 06:23:40',0x4C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C65616E64726F27734C6561);
INSERT INTO `test` VALUES ('2017-04-13 06:03:28',NULL);
INSERT INTO `test` VALUES ('1950-01-01 03:23:03',0x686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F6D6573746561642773686F);

explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union all select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union all select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;

explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a order by a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
explain select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a group by a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union all select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union all select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;
explain extended select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a union select decode(col19,col49) as a from test,(select decode(col19,col49) as b from test) a ;