"Option" causing errors

[Ruslan Zasukhin]

On 8/12/06 1:59 AM, "Chuck Neal" <chuck at mediamacros.com> wrote:

Hi Check,

Aha, right, 

with_option
    :    "with" ("grant" | "admin") "option"

This is new SQL rules to support Roles/Users.

What query did crash for you?

    CREATE TABLE option ..      ?

Please add this bug into Mantis from your account.


> I ran into an interesting problem today.  I have a legacy project that I
> updated from 2.2 to 2.4 in Director.  Everything appeared to work at
> first, but then I started getting missing info.  After about 2 hours of
> debugging I found the issue by manually entering items into Studio
> (between crashes). Apparently "Option" is now a restricted word. If I
> put it in quotes it works, but otherwise I just get no results.
> 
> I realize that every language has reserved keywords, but most SQL
> implementations also make exceptions in queries for things like table
> names, etc.  Can this be adjusted and also better warning placed when
> reserved words are added?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]