[antlr-interest] Upgrade a token/AST from inside the parser.

[Anthony Youngman]

And my comment was because I'm a fan of MV databases. You can use SQL to
access those, but because they are not 1NF, you need a load of extra
commands to massage the data to look like it's relational ... (for
example, UNNEST).

Cheers,
Wol 

-----Original Message-----
From: antlr-interest-bounces at antlr.org
[mailto:antlr-interest-bounces at antlr.org] On Behalf Of Martin Probst
Sent: 22 November 2005 13:02
To: antlr-interest at antlr.org
Subject: RE: [antlr-interest] Upgrade a token/AST from inside the
parser.

> ALL databases?
> 
> Sorry for jumping on my hobbyhorse, but from your other messages, you
> seem to be assuming that columns and tables are universals. 

Plus, I've once worked at a company producing a relational database that
provided some sort of a compatibility mode for Oracle. They were nicely
implementing all the Oracle bugs. Those were known to Oracle, but they
just didn't care because of their market power.
Be aware that there is an SQL standard, but that's only used for
teaching students. There is not a single implementation that you could
call compliant to the standard, not even close to. AFAIK Postgres is
closest, but Oracle is _really_ different (e.g. "" === NULL and other
funny things).

Your probably aware of that, so how do you want to create a
cross-database SQL parser?

Martin


* ************************************************************************ *

This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 8272 5300, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

* ************************************************************************ *