[sqlite] SQLite 3.1.0 Column Names

Hello,

I have two tables:

"CREATE TABLE A (a_col TEXT, PRIMARY KEY (a_col))"

"CREATE TABLE B (b_col TEXT, a_col TEXT, PRIMARY KEY (b_col))"

I am trying to test the column names returned by the following query:

SELECT A.*, B.* FROM A, B WHERE A.a_col = B.a_col

Now whether or not I have one of these pragmas set after opening the transaction:

PRAGMA full_column_names;

PRAGMA short_column_names;

, the resulting column names are always:

a_col, b_col, a_col

breaking the unique constraint on column names in my column set. Can anyone spot anything wrong with this?

Regards,
Stephen Drew

Reply via email to