Re: [sqlite] is ticket 4037 not a bug?

2009-11-19 Thread Schrum, Allan
: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Bogdan Ureche Sent: Tuesday, November 17, 2009 2:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] is ticket 4037 not a bug? I can imagine query generators tend to use more, possibly redundant

Re: [sqlite] is ticket 4037 not a bug?

2009-11-19 Thread Bogdan Ureche
Allan, Thank you very much for the reply. You are correct when stating that, according to SQLite documentation this SQL syntax is not expected to work. Therefore, it is not a bug. Perhaps it should be added to the list of SQL92 features unsupported by SQLite. But I am asking myself: was that

Re: [sqlite] is ticket 4037 not a bug?

2009-11-19 Thread John Elrick
Bogdan Ureche wrote: Allan, Thank you very much for the reply. You are correct when stating that, according to SQLite documentation this SQL syntax is not expected to work. Therefore, it is not a bug. Perhaps it should be added to the list of SQL92 features unsupported by SQLite. IMHO it's

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Jean-Denis Muys
On 11/17/09 6:10 , Bogdan Ureche bogdan...@gmail.com wrote: 1. Is this a bug or not? If not, any reason why not? 2. Are other databases supporting this syntax? 3. Is this an invalid syntax according to the SQL standard? 4. Is there a workaround? I would appreciate any help. Bogdan

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Stephan Wehner
On Mon, Nov 16, 2009 at 9:49 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bogdan Ureche wrote: I just noticed the ticket was closed without being fixed, with the following remark: I was the one who closed it and added that remark. Now, I have

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Bogdan Ureche
Many thanks to all who replied, that was very helpful. So the ticket was closed because the old CVSTRACKER was closed, and a new ticket should be created with the replacement mechanism, after being discussed in the mailing list. @Roger: I apologize for the misunderstanding. If it alters the

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Kees Nuyt
On Mon, 16 Nov 2009 21:49:58 -0800, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bogdan Ureche wrote: I just noticed the ticket was closed without being fixed, with the following remark: I was the one who closed it and added that remark. Now, I have

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Bogdan Ureche
I can imagine query generators tend to use more, possibly redundant, qualifiers than a human programmer would. -- ( Kees Nuyt ) c[_] That may be true but sometimes the qualifiers are needed to avoid ambiguity, in which case they are not redundant. Bogdan

[sqlite] is ticket 4037 not a bug?

2009-11-16 Thread Bogdan Ureche
Hi, A few weeks ago I created ticket 4037 with the description: The following query select databasename.tablename.* from databasename.tablename returns: near *: syntax error However, the following query returns no error: select databasename.tablename.fieldname from databasename.tablename

Re: [sqlite] is ticket 4037 not a bug?

2009-11-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bogdan Ureche wrote: I just noticed the ticket was closed without being fixed, with the following remark: I was the one who closed it and added that remark. Now, I have to admit that English is not my first language, nor the second, but the way