HailDB internal SYS_ tables index access not working

Bug #659214 reported by Stewart Smith
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Low
Stewart Smith
7.0
Fix Released
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)
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.