The patch was made against the published 5.5.4 release
sql.c for 5.5.4 is very geared for Oracle syntax. I
have fixed a number of issues where it was unable to
parse a variety of my PLSQL packages. So there are
quite a few Oracle specific parsing bug fixed.
This patch was made to work specifically with Sybase
Adaptive Server Anywhere 9.0.2, but in doing this, it
means opening the syntax to support more ANSI style SQL.
Some of the additional syntax types supported are:
MobiLink Table Scripts
MobiLink Conn Scripts
The other item I have added is scope. For example,
with the current sql.c you can turn on "local
variables". But if you have a complex Oracle package
which could easily have 30 different procedures within,
you did not know which variable was defined in which
procedure. Now the local variables are displayed with:
This type of scoping was added to a number of objects,
like records and fields. Depends what object was
tagged if adding scope made sense or not.
Expanded the syntax for existing objects. For example
it will recognize:
CREATE TABLE DBA.T1
CREATE TABLE "DBA"."T2"
So many objects can have owner/schema names (DBA
above), the parser now accepts this. Double quotes
should be ignored, but accepted.
When reading records, choose a more appropriate
stopping point since tables can look like this:
create table t1 (
foreign key (),
You do not want to create tags for constraint, primary
key and so on.
Support EXCEPTION clauses.
Where an exception handler could be:
WHEN OTHERS THEN
x := x + 3;
There have been many more refinements, just not sure
what level of detail is needed on this page.
Sign up for the SourceForge newsletter:No, thanks