HailDB internal SYS_ tables index access not working

Bug #659214 reported by Stewart Smith on 2010-10-12
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Low
Stewart Smith
7.0
Low
Stewart Smith

Bug Description

LD_PRELOAD=/usr/local/lib/libeatmydata.so ./test-run.pl --suitepath=../plugin/haildb/test-suite-dir/ --suite=haildb count_distinct datadict_tables

haildb.count_distinct [ pass ] 119
haildb.datadict_tables [ fail ]
--- ../plugin/haildb/test-suite-dir//haildb/tests/r/datadict_tables.result 2010-10-12 17:24:21.024403895 +0300
+++ ../plugin/haildb/test-suite-dir//haildb/tests/r/datadict_tables.reject 2010-10-12 17:25:03.185655971 +0300
@@ -89,31 +89,11 @@
 explain select t.name t,c.name c from data_dictionary.haildb_sys_tables as t, data_dictionary.haildb_sys_columns as c where t.id=c.table_id;
 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.t.ID #Using where
 select t.name t,c.name c from data_dictionary.haildb_sys_tables as t, data_dictionary.haildb_sys_columns as c where t.id=c.table_id;
 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_dictionary/haildb_table_definitions table_name
-data_dictionary/haildb_table_definitions message
 select t.name as table_name,c.name as column_name from data_dictionary.haildb_sys_tables t,data_dictionary.haildb_sys_columns c where t.id=c.table_id order by table_name,column_name;

Related branches

Stewart Smith (stewart) on 2010-10-13
Changed in drizzle:
milestone: none → 2010-10-11
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers