[Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Federico B. <fe...@in...> - 2016-12-21 14:14:59
|
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 |