[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