Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug30423.result

raw
1 set global innodb_stats_method = default;
2 select @@innodb_stats_method;
3 @@innodb_stats_method
4 nulls_equal
5 select count(*) from bug30243_3 where org_id is not NULL;
6 count(*)
7 20
8 select count(*) from bug30243_3 where org_id is NULL;
9 count(*)
10 16384
11 select count(*) from bug30243_2 where org_id is not NULL;
12 count(*)
13 224
14 select count(*) from bug30243_2 where org_id is NULL;
15 count(*)
16 65536
17 select @@innodb_stats_method;
18 @@innodb_stats_method
19 nulls_equal
20 analyze table bug30243_1;
21 Table Op Msg_type Msg_text
22 test.bug30243_1 analyze status Engine-independent statistics collected
23 test.bug30243_1 analyze status OK
24 analyze table bug30243_2;
25 Table Op Msg_type Msg_text
26 test.bug30243_2 analyze status Engine-independent statistics collected
27 test.bug30243_2 analyze status OK
28 analyze table bug30243_3;
29 Table Op Msg_type Msg_text
30 test.bug30243_3 analyze status Engine-independent statistics collected
31 test.bug30243_3 analyze status OK
32 set global innodb_stats_method = "NULL";
33 ERROR 42000: Variable 'innodb_stats_method' can't be set to the value of 'NULL'
34 set global innodb_stats_method = "nulls_ignored";
35 select @@innodb_stats_method;
36 @@innodb_stats_method
37 nulls_ignored
38 analyze table bug30243_1;
39 Table Op Msg_type Msg_text
40 test.bug30243_1 analyze status Engine-independent statistics collected
41 test.bug30243_1 analyze status OK
42 analyze table bug30243_2;
43 Table Op Msg_type Msg_text
44 test.bug30243_2 analyze status Engine-independent statistics collected
45 test.bug30243_2 analyze status OK
46 analyze table bug30243_3;
47 Table Op Msg_type Msg_text
48 test.bug30243_3 analyze status Engine-independent statistics collected
49 test.bug30243_3 analyze status OK
50 explain SELECT COUNT(*), 0
51 FROM bug30243_1 orgs
52 LEFT JOIN bug30243_3 sa_opportunities
53 ON orgs.org_id=sa_opportunities.org_id
54 LEFT JOIN bug30243_2 contacts
55 ON orgs.org_id=contacts.org_id ;
56 id select_type table type possible_keys key key_len ref rows Extra
57 1 SIMPLE orgs ALL NULL NULL NULL NULL ROWS
58 1 SIMPLE sa_opportunities ref org_id org_id 5 test.orgs.org_id ROWS Using index
59 1 SIMPLE contacts ref contacts$org_id contacts$org_id 5 test.orgs.org_id ROWS Using index
60 select @@innodb_stats_method;
61 @@innodb_stats_method
62 nulls_ignored
63 set global innodb_stats_method = "nulls_unequal";
64 select @@innodb_stats_method;
65 @@innodb_stats_method
66 nulls_unequal
67 analyze table bug30243_1;
68 Table Op Msg_type Msg_text
69 test.bug30243_1 analyze status Engine-independent statistics collected
70 test.bug30243_1 analyze status OK
71 analyze table bug30243_2;
72 Table Op Msg_type Msg_text
73 test.bug30243_2 analyze status Engine-independent statistics collected
74 test.bug30243_2 analyze status OK
75 analyze table bug30243_3;
76 Table Op Msg_type Msg_text
77 test.bug30243_3 analyze status Engine-independent statistics collected
78 test.bug30243_3 analyze status OK
79 explain SELECT COUNT(*), 0
80 FROM bug30243_1 orgs
81 LEFT JOIN bug30243_3 sa_opportunities
82 ON orgs.org_id=sa_opportunities.org_id
83 LEFT JOIN bug30243_2 contacts
84 ON orgs.org_id=contacts.org_id;
85 id select_type table type possible_keys key key_len ref rows Extra
86 1 SIMPLE orgs ALL NULL NULL NULL NULL ROWS
87 1 SIMPLE sa_opportunities ref org_id org_id 5 test.orgs.org_id ROWS Using index
88 1 SIMPLE contacts ref contacts$org_id contacts$org_id 5 test.orgs.org_id ROWS Using index
89 SELECT COUNT(*) FROM table_bug30423 WHERE org_id IS NULL;
90 COUNT(*)
91 1024
92 set global innodb_stats_method = "nulls_unequal";
93 analyze table table_bug30423;
94 Table Op Msg_type Msg_text
95 test.table_bug30423 analyze status Engine-independent statistics collected
96 test.table_bug30423 analyze status OK
97 set global innodb_stats_method = "nulls_ignored";
98 analyze table table_bug30423;
99 Table Op Msg_type Msg_text
100 test.table_bug30423 analyze status Engine-independent statistics collected
101 test.table_bug30423 analyze status OK
102 set global innodb_stats_method = nulls_equal;
103 drop table bug30243_2;
104 drop table bug30243_1;
105 drop table bug30243_3;
106 drop table table_bug30423;