Re: [sqlite] SQLite 3.1.0 Column Names

Kurt Welgehausen wrote: results in the SQLite shell; I think it's a bug. Also, there are some typos in the docs: the section on short_column-names is labeled full_column_names, and there are words missing from both sections. I think probably someone should write a bug ticket. Already done, see tick

RE: [sqlite] SQLite 3.1.0 Column Names

distinguish (which is either the table name or table alias used). Regards, Steve -Original Message- From: CARIOTOGLOU MIKE [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 10:07 AM To: 'sqlite-users@sqlite.org' Subject: RE: [sqlite] SQLite 3.1.0 Column Names Ok,

RE: [sqlite] SQLite 3.1.0 Column Names

EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 10:07 AM To: 'sqlite-users@sqlite.org' Subject: RE: [sqlite] SQLite 3.1.0 Column Names Ok, since this issue with column names has gone on long enough, and we seem to be getting nowhere, I would like to propose an API change. Here i

Re: [sqlite] SQLite 3.1.0 Column Names

CARIOTOGLOU MIKE wrote: Ok, since this issue with column names has gone on long enough, and we seem to be getting nowhere, I would like to propose an API change. Here is the rationale : Normally, a query does not need or can use "qualified" names (like something.something). An explicit, hard-coded

RE: [sqlite] SQLite 3.1.0 Column Names

Ok, since this issue with column names has gone on long enough, and we seem to be getting nowhere, I would like to propose an API change. Here is the rationale : Normally, a query does not need or can use "qualified" names (like something.something). An explicit, hard-coded query knows the struct

Re: [sqlite] SQLite 3.1.0 Column Names

Steve, Well, you forced me to download v3.1 (;-). I confirmed your results in the SQLite shell; I think it's a bug. Also, there are some typos in the docs: the section on short_column-names is labeled full_column_names, and there are words missing from both sections. I think probably someone shoul

RE: [sqlite] SQLite 3.1.0 Column Names

Kurt, Apologies. I believe I have also tried: Exec("PRAGMA full_column_names=1;") Steve -Original Message- From: Drew, Stephen Sent: Tuesday, January 25, 2005 4:33 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] SQLite 3.1.0 Column Names Kurt, Thanks for the reply.

RE: [sqlite] SQLite 3.1.0 Column Names

uted at the location above, the following names are returned: a_col, b_col, a_col. I need these to be unique! Am I missing something? Are they compile-time pragmas? Thanks, Steve -Original Message- From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 4:19 PM To

Re: [sqlite] SQLite 3.1.0 Column Names

> PRAGMA full_column_names; > > PRAGMA short_column_names; Did you really set them, or just query them? : PRAGMA full_column_names; PRAGMA full_column_names = 0|1; Query or change the short-column-names flag. ... Regards

[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