Re: [sqlite] Proposed removal of (mis-)feature

2008-08-12 Thread Dennis Cote
Eugene Wee wrote: >> >> If it does not have any compatibility with any other database, >> ONLY then I say that one should drop #3 quoting convention. >> > I believe that MySQL allows double quotes to be used as string > delimiters by default, but then this would not be a compatibility break >

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-08 Thread Eugene Wee
Hi, palmer ristevski wrote: > He is my vote. > I like the fact that conventions #1 and #2 make things compatible with other > databases. > Does #3, by chance, do the same with another database not mentioned > (eg. Oracle). > > If it does not have any compatibility with any other database, > ONLY

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Mihai Limbasan
Yes, please remove #3. Now is a particularly good time for it seeing as the 3.6 line is quite new. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Darren Duncan
D. Richard Hipp wrote: > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals. My concern is, though, > that this might

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread palmer ristevski
convention. Palmer > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 7 Aug 2008 13:26:07 -0400 > Subject: [sqlite] Proposed removal of (mis-)feature > > String literals in SQL are suppose to be enclosed in single-quotes - > Pascal-style. Double-quotes

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Wilson, Ron P
ent: Thursday, August 07, 2008 1:26 PM To: General Discussion of SQLite Database Subject: [sqlite] Proposed removal of (mis-)feature String literals in SQL are suppose to be enclosed in single-quotes - Pascal-style. Double-quotes are used around table and/or column names in cases where t

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Clark Christensen
+1 in favor of removing non-standard quoting mechanism #3. - Original Message From: D. Richard Hipp <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thursday, August 7, 2008 10:26:07 AM Subject: [sqlite] Proposed removal of (

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Fred Williams
Hipp Sent: Thursday, August 07, 2008 12:26 PM To: General Discussion of SQLite Database Subject: [sqlite] Proposed removal of (mis-)feature String literals in SQL are suppose to be enclosed in single-quotes - Pascal-style. Double-quotes are used around table and/or column names in cases where the

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Jeffrey Becker
On Thu, Aug 7, 2008 at 2:13 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > > On Thu, 7 Aug 2008 13:26:07 -0400, drh wrote: > > [snip] > >>So I'm giving some thought to removing feature (3) above and >>disallowing double-quoted string literals. My concern is, though, >>that this might break many

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Noah Hart
+3 on removal of #3 Noah --- On Thu, 8/7/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: From: D. Richard Hipp <[EMAIL PROTECTED]> Subject: [sqlite] Proposed removal of (mis-)feature To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Thursd

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Kees Nuyt
On Thu, 7 Aug 2008 13:26:07 -0400, drh wrote: [snip] >So I'm giving some thought to removing feature (3) above and >disallowing double-quoted string literals. My concern is, though, >that this might break many existing applications. > >What opinion do you, gentle users, have of this

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Michael Ruck
Remove it. Better now than never. Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von D. > Richard Hipp > Gesendet: Donnerstag, 7. August 2008 19:26 > An: General Discussion of SQLite Database > Betreff: [sql

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread peter
On Thu, Aug 07, 2008 at 01:26:07PM -0400, D. Richard Hipp wrote: > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > [..] > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals.

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Stephen Oberholtzer
On Thu, Aug 7, 2008 at 1:26 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > String literals in SQL are suppose to be enclosed in single-quotes - > Pascal-style. Double-quotes are used around table and/or column names > in cases where the name would otherwise be a keyword or when the name >

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Ken
+2 on removal of #3. --- On Thu, 8/7/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: From: D. Richard Hipp <[EMAIL PROTECTED]> Subject: [sqlite] Proposed removal of (mis-)feature To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Thursday, Augu

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Stephen Woodbridge
I'm +1 on this change. While I have not run into it as a feature or mis-feature, I would concur that it is ambiguous and problematic. A simple clear syntax benefits everyone. BTW, Thanks for all you effort to produce this wonder software. Best regards, -Steve W D. Richard Hipp wrote: >