getImportedKeys() throws exception

16 views
Skip to first unread message

CKSo

unread,
Oct 11, 2011, 5:39:48 AM10/11/11
to Xerial
create table test(id integer primary key);
create table test2(id integer primary key, test_id integer, foreign
key(test_id) references test);

call connection.getMetaData().getImportedKeys() for test2 throws
exception
java.lang.NullPointerException
at org.sqlite.MetaData.escape(MetaData.java:838)
at org.sqlite.MetaData.getImportedKeys(MetaData.java:546)

Telmo

unread,
Oct 26, 2011, 9:14:30 AM10/26/11
to Xerial

if you create a 3rd table like:

create table test3(id integer primary key, test_id integer, foreign
key(test_id) references test(id));

the problem stops. you can see the difference by querying:

pragma foreign_key_list(test2);
pragma foreign_key_list(test3);

maybe sqlite shouldn't accept the "references test" without the
"(id)"?
Reply all
Reply to author
Forward
0 new messages