SQL Parser test program: volunteers required ;)
lazarus / 16-Databases

----------------------------------------------------------------------
BigChimp · 2014-06-10 10:16

Hi all,

I've been working on improving the sql parser/generator included with
FPC in packages\fcl-db\src\sql
That parser is able to parse Firebird SQL statements (and could be
extended for other dialects).
It currently parses at least a DDL dump of the employee sample
database.

I've attached a Lazarus test program including the latest sources for
the parser/generator. It compiles and runs with Lazarus 1.2.2 and
probably earlier versions as well.

If people could load in their favourite nasty SQL script and press the
parse button, then report any errors (as well as the script), I'd be
very grateful.

Thanks a lot and happy breakage

----------------------------------------------------------------------
Mike.Cornflake · 2014-06-10 10:22

To be clear, you're just looking for Firebird based feedback at this
time yes?  

If no, I've more than a few evil MS SQL and MySQL SQL's I could run
through it for you.

----------------------------------------------------------------------
BigChimp · 2014-06-10 10:25

Quote from: Mike.Cornflake on June 10, 2014, 12:22:10 pmTo be clear,
you're just looking for Firebird based feedback at this time yes?  
Yes, I am. I suspect the parser would bomb fairly quickly (e.g. on the
first GO statement if present)