SQLite REFERENCES

[Former user]

SQLite allows foreign key REFERENCES with an absent column name, to refer to a column of the same name, e.g.

CREATE TABLE a (id INTEGER PRIMARY KEY);
CREATE TABLE b (id INTEGER PRIMARY KEY REFERENCES a);

In this case SQLite returns an empty value for the foreign column name, breaking SQLiteDialect.get_foreign_keys().

0.6.6 Test and patch attached.

[Former user]

Reproduces the error.

[Former user]

Patch

[Mike Bayer]

fb97a666bb6e352ae908d763d2d8ac3c087cd529 ba5240aec039906f0e79d9cb3e2e9323e873fc3b

thanks for the fix !

[Mike Bayer]

Removing milestone: 0.6.7 (automated comment)