|
From: Gerd W. <ger...@t-...> - 2016-12-21 23:32:35
|
Federico, this bug is fixed. The fix is available here: https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161222_0014 Please give it a try. Thanks Gerd Am 21.12.2016 um 15:14 schrieb Federico Bruni: > 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 > > > > > > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/intel > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
