Re: [sqlite] Poor performance with nested query in outer join

On 10 Dec 2011, at 10:35pm, Nick Smallbone wrote: > the difference between my query and your query is > that I have a subquery (select * from b) and you don't. I understand that SQLite handles VIEWs as if you had defined and saved a SELECT statement. So if you JOIN with a VIEW, does SQLite

[sqlite] sqlite3_auto_extension() memory leaks

static void init_db(sqlite3* db, char** pzErrMsg, const struct sqlite3_api_routines* *pThunk) { . } BOOL CMyDlg::OnInitDialog() { . sqlite3_auto_extension ((void (*)(void)) init_db); }

Re: [sqlite] Poor performance with nested query in outer join

"Black, Michael (IS)" writes: > Natural joins are generally considered to be evil. Too many columns > in common can be bad. > > If you just spell it out it works as expected > > sqlite> explain query plan select * from a left join b where a.id=1 and > b.id=a.id; >

Re: [sqlite] Is a column name of 'AS' a restricted column name

Thanks for the replies. I can now work around the problem by either converting the column name AS to A_S and easily recode the application to use A_S in the SQL statements and data retrieval or just make sure I quote the column name. Other aspects of my post, thanks for the REAL pointer for

Re: [sqlite] Is a column name of 'AS' a restricted column name

On Sun, 11 Dec 2011 10:01:02 +, Account 69 wrote: > Hello, > > Just started to use SQLite3 instead of MSAccess within my programming > environment can hit a problem. I have searched the mailing list and also > other internet sites for help but could not find any. > >

Re: [sqlite] Is a column name of 'AS' a restricted column name

On 11 Dec 2011, at 10:01am, Account 69 wrote: > Is a column name of "AS" a restricted column name in SQLlite? Can anyone > point me to a webpage that species these restricted column names or is this > an error on my part somewhere No, you got it right:

Re: [sqlite] Is a column name of 'AS' a restricted column name

AS is a key word, so I believe you either have to put it in single or double quotes to use it as a column name: INSERT INTO [shopdata] (Date_TS, HS, "AS")... Hopefully I'm remembering correctly what I've read in the past. Eric Pankoke Mobile Games Reviewer My Site: http://www.rustysabre.com/

[sqlite] Is a column name of 'AS' a restricted column name

Hello, Just started to use SQLite3 instead of MSAccess within my programming environment can hit a problem. I have searched the mailing list and also other internet sites for help but could not find any. In my table I have (for simplicity) 4 columns (ID, Date, HS, AS) My data comes from an