Re: [mdb-dev] SQL parsing

[<br...@br...>]

Access does it that way, but the SQL 99 standard is '' for string
literals and "" for identifiers.  I would personally like to keep the
SQL engine tracking the standard as close as possible.

I am not opposed to introducing [] to also mean identifier, as that is
supplemental and doesn't conflict with the standard.

On a side note, I think I'll finally get the time to merge some
patches this week.  The entire family (myself included) got the flu
over the past two weeks, and is just now recovering.

Brian

On Sat, 21 Aug 2004 22:11:19 -0700 (PDT), Jeff Smith wrote:

> 
> I will soon be taking a look at some of the SQL/ODBC issues raised
> recently, but first I
> want to take care of something a little more fundamental.
> 
> Currently, we parse SQL syntax something like this...
>   123 - numeric constant
>   xyz - identifier
>   'xyz' - string constant
>   "xyz" - identifier
> 
> Access does it more like this...
>   123 - numeric constant
>   xyz - identifier
>   'xyz' - string constant
>   "xyz" - string constant
>   [xyz] - identifier
> 
> I have a patch to change the parsing to the latter, but I am probing
> for any objections
> before I apply.  My personal feelings are we run the least risk by
> trying to match Access
> as closely as reasonably possible.
> 
>  -- Jeff Smith
> 
> 
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank
Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev