Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.0.16
-
None
-
Custom packages with MariaDB 10.0.16 and tokudb-7.5.4
Description
Reported upstream at: https://tokutek.atlassian.net/browse/DB-890
Huge inconsistency when running these queries:
MariaDB DBSTORE localhost dewiki > pager cat > /dev/null
|
PAGER set to 'cat > /dev/null'
|
MariaDB DBSTORE localhost dewiki > SELECT * FROM revision WHERE rev_page=9023902 and rev_id=147187984;
|
1 row in set (0.00 sec)
|
|
|
MariaDB DBSTORE localhost dewiki > SELECT * FROM revision WHERE rev_page=9023902;
|
Empty set (0.00 sec)
|
Expected to return the same row even when queried the same row with a partial primary key:
MariaDB DBSTORE localhost dewiki > nopager
|
PAGER set to stdout
|
MariaDB DBSTORE localhost dewiki > SHOW CREATE TABLE revision\G
|
|
|
1. row ***************************
|
Table: revision
|
Create Table: CREATE TABLE `revision` (
|
`rev_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
|
`rev_page` int(8) unsigned NOT NULL DEFAULT '0',
|
`rev_text_id` int(8) unsigned NOT NULL DEFAULT '0',
|
`rev_comment` varbinary(255) NOT NULL,
|
`rev_user` int(5) unsigned NOT NULL DEFAULT '0',
|
`rev_user_text` varbinary(255) NOT NULL DEFAULT '',
|
`rev_timestamp` varbinary(14) NOT NULL DEFAULT '',
|
`rev_minor_edit` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
`rev_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
`rev_len` int(8) unsigned DEFAULT NULL,
|
`rev_parent_id` int(8) unsigned DEFAULT NULL,
|
`rev_sha1` varbinary(32) NOT NULL DEFAULT '',
|
`rev_content_model` varbinary(32) DEFAULT NULL,
|
`rev_content_format` varbinary(64) DEFAULT NULL,
|
PRIMARY KEY (`rev_page`,`rev_id`),
|
UNIQUE KEY `rev_id` (`rev_id`),
|
KEY `rev_timestamp` (`rev_timestamp`),
|
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
|
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
|
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
|
) ENGINE=TokuDB AUTO_INCREMENT=147190982 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED `compression`='tokudb_zlib'
|
1 row in set (0.00 sec)
|