| Server IP : 172.67.216.182 / Your IP : 172.70.208.80 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/r/ |
Upload File : |
set global innodb_stats_method = default; select @@innodb_stats_method; @@innodb_stats_method nulls_equal select count(*) from bug30243_3 where org_id is not NULL; count(*) 20 select count(*) from bug30243_3 where org_id is NULL; count(*) 16384 select count(*) from bug30243_2 where org_id is not NULL; count(*) 224 select count(*) from bug30243_2 where org_id is NULL; count(*) 65536 select @@innodb_stats_method; @@innodb_stats_method nulls_equal analyze table bug30243_1; Table Op Msg_type Msg_text test.bug30243_1 analyze status OK analyze table bug30243_2; Table Op Msg_type Msg_text test.bug30243_2 analyze status OK analyze table bug30243_3; Table Op Msg_type Msg_text test.bug30243_3 analyze status OK set global innodb_stats_method = "NULL"; ERROR 42000: Variable 'innodb_stats_method' can't be set to the value of 'NULL' set global innodb_stats_method = "nulls_ignored"; select @@innodb_stats_method; @@innodb_stats_method nulls_ignored analyze table bug30243_1; Table Op Msg_type Msg_text test.bug30243_1 analyze status OK analyze table bug30243_2; Table Op Msg_type Msg_text test.bug30243_2 analyze status OK analyze table bug30243_3; Table Op Msg_type Msg_text test.bug30243_3 analyze status OK explain SELECT COUNT(*), 0 FROM bug30243_1 orgs LEFT JOIN bug30243_3 sa_opportunities ON orgs.org_id=sa_opportunities.org_id LEFT JOIN bug30243_2 contacts ON orgs.org_id=contacts.org_id ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE orgs NULL index NULL org_id 4 NULL ROWS 100.00 Using index 1 SIMPLE sa_opportunities NULL ref org_id org_id 5 test.orgs.org_id ROWS 100.00 Using index 1 SIMPLE contacts NULL ref contacts$org_id contacts$org_id 5 test.orgs.org_id ROWS 100.00 Using index Warnings: Note 1003 /* select#1 */ select count(0) AS `COUNT(*)`,0 AS `0` from `test`.`bug30243_1` `orgs` left join `test`.`bug30243_3` `sa_opportunities` on((`test`.`sa_opportunities`.`org_id` = `test`.`orgs`.`org_id`)) left join `test`.`bug30243_2` `contacts` on((`test`.`contacts`.`org_id` = `test`.`orgs`.`org_id`)) where 1 select @@innodb_stats_method; @@innodb_stats_method nulls_ignored set global innodb_stats_method = "nulls_unequal"; select @@innodb_stats_method; @@innodb_stats_method nulls_unequal analyze table bug30243_1; Table Op Msg_type Msg_text test.bug30243_1 analyze status OK analyze table bug30243_2; Table Op Msg_type Msg_text test.bug30243_2 analyze status OK analyze table bug30243_3; Table Op Msg_type Msg_text test.bug30243_3 analyze status OK explain SELECT COUNT(*), 0 FROM bug30243_1 orgs LEFT JOIN bug30243_3 sa_opportunities ON orgs.org_id=sa_opportunities.org_id LEFT JOIN bug30243_2 contacts ON orgs.org_id=contacts.org_id; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE orgs NULL index NULL org_id 4 NULL ROWS 100.00 Using index 1 SIMPLE sa_opportunities NULL ref org_id org_id 5 test.orgs.org_id ROWS 100.00 Using index 1 SIMPLE contacts NULL ref contacts$org_id contacts$org_id 5 test.orgs.org_id ROWS 100.00 Using index Warnings: Note 1003 /* select#1 */ select count(0) AS `COUNT(*)`,0 AS `0` from `test`.`bug30243_1` `orgs` left join `test`.`bug30243_3` `sa_opportunities` on((`test`.`sa_opportunities`.`org_id` = `test`.`orgs`.`org_id`)) left join `test`.`bug30243_2` `contacts` on((`test`.`contacts`.`org_id` = `test`.`orgs`.`org_id`)) where 1 SELECT COUNT(*) FROM table_bug30423 WHERE org_id IS NULL; COUNT(*) 1024 set global innodb_stats_method = "nulls_unequal"; analyze table table_bug30423; Table Op Msg_type Msg_text test.table_bug30423 analyze status OK set global innodb_stats_method = "nulls_ignored"; analyze table table_bug30423; Table Op Msg_type Msg_text test.table_bug30423 analyze status OK set global innodb_stats_method = nulls_equal; drop table bug30243_2; drop table bug30243_1; drop table bug30243_3; drop table table_bug30423;