1
Vote

Missing detection of invalid alias specification

description

Reverse aliasing:
In the legacy database we ported reverse alias specifications had been used a few places like: "SELECT 'aliasName' = expr ". This had to be rewritten as "SELECT expr AS aliasName". The invalid naming was not detected by the wizard. (I recognize this is very difficult to test using regular expressions but thought I would let you know anyway.
 
Thanks for a great product.

comments

ghuey wrote Oct 13, 2010 at 9:33 PM

I agree. I put in a regex statement that should catch this. It will be in v3.4.1.

Thanks!
George