Changes in SQL parser for 5.0. Be prepared please.

Hi All,

We have remove couple of wrong things in 4.x VSQL parser. Please prepare your code to remove this deprecated syntax.

1)  4.x did allow this
SELECT f1 as ‘New name’         << single quotes, i.e. Char literal
This is wrong, here must be only IDENT allowed

SELECT f1 as “New name”         << double quotes, delimited ident
SELECT f1 as NewName            << or even without quotes if no spaces

So if you have such single quotes in SQL code, please replace to double quotes. This will work even for 4.x

2) REGISTER DATABASE db_name [path_name]

Db_name in 4.x expected in single quotes. WRONG.
Should be again just IDENT.

Published by

Ruslan Zasukhin

VP Engineering and New Technology Paradigma Software, Inc