Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
rocksdb.type_varchar fails like this:
CURRENT_TEST: rocksdb.type_varchar
|
--- /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_varchar.result 2016-10-28 08:55:37.056371707 +0000
|
+++ /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_varchar.reject 2016-12-02 19:14:06.552690598 +0000
|
@@ -721,7 +721,7 @@
|
insert into t values (1, 'abcabcabcabcabcabcabcabcabcabcabc ');
|
explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t index NULL email_i 33 NULL # Using index
|
+1 SIMPLE t ALL NULL NULL NULL NULL #
|
select 'email_i' as index_name, count(*) AS count from t force index(email_i);
|
index_name count
|
email_i 1
|
@@ -734,7 +734,7 @@
|
insert into t values (1, 'a');
|
explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t index NULL email_i 33 NULL # Using index
|
+1 SIMPLE t ALL NULL NULL NULL NULL #
|
select 'email_i' as index_name, count(*) AS count from t force index(email_i);
|
index_name count
|
email_i 1
|
Initially this was reported here:
https://jira.mariadb.org/browse/MDEV-9658?focusedCommentId=87896&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-87896
but in the current tree, I see the same field->part_of_key for both MariaDB and MySQL:
(gdb) p tables_arg->table->field[0]->part_of_key
|
warning: can't find linker symbol for virtual table for `Field' value
|
$89 = {map = 3}
|
(gdb) p tables_arg->table->field[1]->part_of_key
|
warning: can't find linker symbol for virtual table for `Field' value
|
$90 = {map = 0}
|
Attachments
Issue Links
- is part of
-
MDEV-9658 Make MyRocks in MariaDB stable
- Closed
- relates to
-
MDEV-11321 MariaRocks: type_binary_indexes, type_blob_indexes fail due to different index statistics
- Closed