sqlite 3.0.8, windows XP
I'm attempting to create some tables and indexes in a attached database (bar) and after everything is complete and I go back in to the previously attached database and do a .schema I get the following:
"Error: malformed database schema - index table_field_name cannot reference objects in database ref"
the following script can be used to reproduce the problem in a windows XP command prompt
any ideas?
Jim
--- cut here --- del foo bar
sqlite3 foo create table xxx (xxx char); .quit
sqlite3 bar create table xxx (xxx char); .quit
sqlite3 foo
attach database bar as ref;
create table ref.table_field
(
name varchar(255),
nbr varchar(255)
);
create unique index ref.table_field_name on ref.table_field (name);
create table ref.alias_table_field
(
name varchar(255),
alias varchar(255)
);
create unique index ref.alias_table_field_name on ref.alias_table_field (name);
create unique index ref.alias_table_field_alias on ref.alias_table_field (alias);
.quit
sqlite3 bar .schema .quit
--- end of script ---
