innodb_stats_method=nulls_ignored works incorrectly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Low
|
Unassigned | ||
5.1 |
Invalid
|
Low
|
Unassigned | ||
5.5 |
Invalid
|
Low
|
Unassigned | ||
Rnt-5.1 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
MySQL dev-team implemented option innodb_stats_method incorrectly.
On nulls_ignored value we have incorrect statistics.
Test-cases in related branches:
oleg.tsarev (0) /storage/
Logging: /storage/
111119 2:40:08 [Note] Flashcache bypass: disabled
111119 2:40:08 [Note] Flashcache setup error is : open flash device failed
MySQL Version 5.5.17
Too long tmpdir path '/storage/
- using tmpdir: '/tmp/kJuXcQL9OJ'
Checking supported features...
- skipping ndbcluster
- skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /storage/
Checking leftover processes...
Removing old var directory...
Creating var directory '/storage/
Installing system database...
Using server port 33614
=======
TEST RESULT TIME (ms) or COMMENT
-------
worker[1] - 'localhost:13000' was not free
worker[1] - 'localhost:13010' was not free
worker[1] - 'localhost:13020' was not free
worker[1] Using MTR_BUILD_THREAD 303, with reserved ports 13030..13039
main.percona_
main.percona_
Test ended at 2011-11-19 02:41:01
CURRENT_TEST: main.percona_
--- /storage/
+++ /storage/
@@ -15,4 +15,17 @@
ANALYZE TABLE t;
Table Op Msg_type Msg_text
test.t analyze status OK
+Failed with '--innodb_
+SELECT count(*) FROM t WHERE id IS NULL;
+count(*)
+94425
+SELECT count(*) FROM t WHERE id IS NOT NULL;
+count(*)
+5664
+SHOW INDEXES FROM t;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
+t 1 t 1 id A 100536 NULL NULL YES BTREE
+
+We are expected cardinality approximately equal to not null count, but this is false
+
DROP TABLE t;
mysqltest: Result length mismatch
- saving '/storage/
-------
The servers were restarted 1 times
Spent 19.686 of 53 seconds executing testcases
Completed: Failed 1/2 tests, 50.00% were successful.
Failing test(s): main.percona_
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://
mysql-test-run: *** ERROR: there were failing test cases
oleg.tsarev (0) /storage/
Related branches
- Laurynas Biveinis (community): Approve
- Oleg Tsarev (community): Needs Resubmitting
-
Diff: 745 lines (+733/-0)2 files modifiedpatches/bug63320.patch (+732/-0)
patches/series (+1/-0)
tags: | added: cr i19957 |
So... this is Closed in upstream MySQL and it appears we just have the upstream fix now. Closing as Invalid.