+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: Thursday, August 7, 2008, 12:26 PM
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
contains non-standard characters.
But SQLite tries to be flexible and accommodating. To this end, it
accepts some non-standard quoting mechanisms:
1. Names can be enclosed in [...] for compatibility with Access
and SQLServer.
2. Names can be enclosed in grave accents for compatibility with
MySQL.
3. Double-quoted names fall back to being string literals if
there is no matching table or column name.
In retrospect, (3) seems to be a bad idea. It is accident-prone and
leads to all kinds of confusion. For example, if double-quotes are
being used correctly (which is to say to quote table or column names)
but a misspelling occurs in the name, the token reverts to being a
string literal rather than throwing an error. Or if a double-quoted
string really is being used as a string literal, but later a new
column is added to a table that has the same name as the string text,
the string literal will suddenly take on the value of the column. It
seems like we have one or two problem reports per month on this
mailing list that involve people using double-quoted names where they
should be using single-quoted string literals instead.
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 matter?
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
