[fpc-pascal] Reopen issue 20500: TSQLParser cant Parse Statements containing "as"
Reinier Olislagers
reinierolislagers at gmail.com
Mon Oct 17 18:53:28 CEST 2011
The issue reporter gave this example:
select ORDERNO as OrderNo from ORDERS as Orders;
It does parse AS, but only for a field.
Michael Van Canneyt replied:
TSQLParser implements SQL syntax as used in Firebird, and firebird does
not allow AS for a tablename, just append the alias.
The correct syntax would be:
select ORDERNO as OrderNo from ORDERS Orders;
However:
On my Firebird 2.5, this works perfectly (in FlameRobin and SQLWorkBench/J):
select * from rdb$relations as tables;
Would it make sense to reopen this bug?
Thanks,
Reinier
More information about the fpc-pascal
mailing list