HailDB internal SYS_ tables index access not working
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Low
|
Stewart Smith | ||
7.0 |
Fix Released
|
Low
|
Stewart Smith |
Bug Description
LD_PRELOAD=
haildb.
haildb.
--- ../plugin/
+++ ../plugin/
@@ -89,31 +89,11 @@
explain select t.name t,c.name c from data_dictionary
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t ALL NULL NULL NULL NULL #
-1 SIMPLE c ALL PRIMARY NULL NULL NULL # Using where; Using join buffer
+1 SIMPLE c ref PRIMARY PRIMARY 1 data_dictionary
select t.name t,c.name c from data_dictionary
t c
-SYS_FOREIGN ID
-SYS_FOREIGN FOR_NAME
-SYS_FOREIGN REF_NAME
-SYS_FOREIGN N_COLS
-SYS_FOREIGN_COLS ID
-SYS_FOREIGN_COLS POS
-SYS_FOREIGN_COLS FOR_COL_NAME
-SYS_FOREIGN_COLS REF_COL_NAME
-data_dictionar
-data_dictionar
select t.name as table_name,c.name as column_name from data_dictionary
Related branches
- Drizzle Merge Team: Pending requested
-
Diff: 1109 lines (+124/-252)45 files modifiedplugin/haildb/config_table_function.cc (+1/-5)
plugin/haildb/datadict_table_message.cc (+17/-12)
plugin/haildb/haildb_datadict_dump_func.cc (+1/-5)
plugin/haildb/haildb_engine.cc (+26/-9)
plugin/haildb/haildb_version_func.cc (+0/-91)
plugin/haildb/haildb_version_func.h (+0/-24)
plugin/haildb/plugin.ini (+2/-2)
plugin/haildb/status_table_function.cc (+8/-58)
plugin/haildb/test-suite-dir/haildb/tests/r/basic_index_lookup.result (+8/-8)
plugin/haildb/test-suite-dir/haildb/tests/r/basic_nopkey_index_read.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/basic_pkey_index_reverse_scan.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/basic_pkey_index_scan.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/bench_count_distinct.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/config_fast_shutdown2.result (+0/-3)
plugin/haildb/test-suite-dir/haildb/tests/r/datadict_tables.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/haildb_version_func.result (+0/-3)
plugin/haildb/test-suite-dir/haildb/tests/r/index_multicolumn_unique.result (+2/-2)
plugin/haildb/test-suite-dir/haildb/tests/r/index_null.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/index_varchar.result (+2/-2)
plugin/haildb/test-suite-dir/haildb/tests/r/secondary_index_scan.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/status_table_function.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/type_blob.result (+3/-3)
plugin/haildb/test-suite-dir/haildb/tests/r/type_date.result (+3/-3)
plugin/haildb/test-suite-dir/haildb/tests/r/type_datetime.result (+7/-7)
plugin/haildb/test-suite-dir/haildb/tests/r/type_enum.result (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/r/type_float.result (+2/-2)
plugin/haildb/test-suite-dir/haildb/tests/t/basic_index_lookup.test (+8/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/basic_nopkey_index_read.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/basic_pkey_index_reverse_scan.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/basic_pkey_index_scan.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/bench_count_distinct.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/config_fast_shutdown2-master.opt (+0/-1)
plugin/haildb/test-suite-dir/haildb/tests/t/config_fast_shutdown2.test (+0/-1)
plugin/haildb/test-suite-dir/haildb/tests/t/config_file_per_table_enable.test (+1/-1)
plugin/haildb/test-suite-dir/haildb/tests/t/datadict_tables.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/haildb_version_func.test (+0/-1)
plugin/haildb/test-suite-dir/haildb/tests/t/index_multicolumn_unique.test (+2/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/index_null.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/index_varchar.test (+2/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/secondary_index_scan.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/type_blob.test (+3/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/type_date.test (+3/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/type_datetime.test (+4/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/type_enum.test (+1/-0)
plugin/haildb/test-suite-dir/haildb/tests/t/type_float.test (+2/-0)
Changed in drizzle: | |
milestone: | none → 2010-10-11 |
status: | Confirmed → Fix Released |