Hello Everyone, I'm glad to see I'm not the only one who wants this.
I'm thinking perhaps I wasn't clear enough in my first e-mail that I created a patch for the time being. You can download the patch, along with already modified source, static libraries and binaries for Linux i386, Linux AMD64, and Windows here: http://nsrt.nachsoftware.org/sqlite3-3.7.14.1-without-dblquote-string.tar.bz2 467a12059d50850f394066195d70c659 c15bc452d9db38ac47a557d06f89ff0658220861 If you're compiling yourself, add -DSQLITE_OMIT_DBLQUOTED_STRINGS to your flags to remove double quoted string literals from being supported. I really wanted to know what people think of the patch itself. @Tom >this tolerance by SQLite for misquoted identifiers allows a lot of errors. The case I'm dealing with here is actually misquoted string literals, which affects misspelled identifiers. I assume that's what you meant. While I see some wanting the ability to drop [] and `` from identifier support for the sake of purity, I don't know of a case where keeping it actually breaks any valid SQL. @Simon >Perhaps this and a couple of similar things will be fixed in SQLite4. While I hope that too, I would like a fix to become mainline in SQLite3. As is, you can play with my patch right now in the latest version of SQLite3! @Dave >The behaviour of quoting with [identifier] or `identifier` seems to do what you want, but, as the docs say, these are not standard SQL. Nice idea! Definitely one to consider without any kind of patch. However if you're trying to write cross platform SQL, that can be a bit painful. :( @Dan >I tested out the original poster's patch and it works great. Any way this can be made into a "PRAGMA strict_mode" so that it would be usage-specific rather than compile-specific? Thanks for testing it. I appreciate the feedback and glad to hear it works well for you. I don't know a lot about SQLite's source code. I just really wanted this fixed, and thank God after 15 minutes of grepping the source, I happened upon the code which seems to control double quoted string literals. I don't really know SQLite's source code, let alone the pragma system, but if I have time, I'll see what I can do. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
