Hi all
I thought that I was still affected by a bug fixed in 2014:
https://sourceforge.net/p/squirrel-sql/bugs/618/
Example:
SELECT * FROM CARS
WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ;
Instead of just executing the LIKE 'TOY%' statement, I'm prompted for
the variables which are in a commented block and should be therefore
ignored.
I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git
and found out that if I use '--' for commenting then sqlparam won't
prompt for variables:
SELECT * FROM CARS
WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3);
I don't know what's the recommended way to do this sort of things in
SQL, but I wanted to share this with you.
Thanks
Federico
|