/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/r/ |
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp_mrr.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/r/ |
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_in_mrr_cost.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 660 c_year YEAR NOT NULL, 663 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 824 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 826 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 828 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 829 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 831 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 834 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 838 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 839 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp.result | 661 c_year YEAR NOT NULL, 664 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 825 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 827 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 829 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 830 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 832 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 835 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 839 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 840 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | func_in_all.result | 673 c_year YEAR NOT NULL, 676 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 837 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 839 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 841 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 842 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 844 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 847 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 851 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 852 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp.result | 673 c_year YEAR NOT NULL, 676 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 837 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 839 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 841 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 842 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 844 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition 847 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 851 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 852 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_icp_mrr.result | 673 c_year YEAR NOT NULL, 676 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 837 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 839 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 841 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 842 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 844 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using index condition; Using MRR 847 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 851 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 852 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_mrr.result | 673 c_year YEAR NOT NULL, 676 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 837 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 839 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where; Using MRR 841 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 842 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 844 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where; Using MRR 847 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 851 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 852 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_mrr_cost.result | 673 c_year YEAR NOT NULL, 676 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 837 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 839 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 841 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 842 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 844 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 847 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 851 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 852 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|
H A D | func_in_none.result | 672 c_year YEAR NOT NULL, 675 INDEX(c_datetime), INDEX(c_timestamp), INDEX(c_time), INDEX(c_year), 836 EXPLAIN SELECT * FROM t1 WHERE c_year IN (1, 2, 3); 838 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 840 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 841 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, 1, 2, 3); 843 1 SIMPLE t1 NULL range c_year c_year 1 NULL 3 100.00 Using where 846 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL); 850 …e` AS `c_time`,`test`.`t1`.`c_year` AS `c_year`,`test`.`t1`.`c_char` AS `c_char` from `test`.`t1` … 851 EXPLAIN SELECT * FROM t1 WHERE c_year IN (NULL, NULL); [all …]
|