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 |
- [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND ... Drew, Stephen
- [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE... Steve Frierdich
- Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN... Mrs. Brisby
- Re: [sqlite] CHECKING fOR A STRING IN A COLUM... Steve Frierdich
- [sqlite] one SQL statement that will insert a... Steve Frierdich
- [sqlite] Are there any links on how to u... Steve Frierdich
- Re: [sqlite] Are there any links on... Clay Dowling
- Re: [sqlite] one SQL statement that will ... Dennis Cote
- Re: [sqlite] one SQL statement that ... D. Richard Hipp
- Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN... Cory Nelson
- [sqlite] INSERT OR REPLACE INTO or REPLACE IN... Steve Frierdich