All the Perl that's Practical to Extract and Report

Got bugs to share? (Spot the bug)

cog on 2004-03-04T20:09:09

Hi :-)

I'm trying to get together a couple of bugs, such as this one:

UPDATE users SET state = 'DC' AND city = 'Washington'
WHERE state = 'DC' AND city = 'Washington'

(this one was originally here)

I'm interested in Perl, Java, C, Prolog, Haskell, whatever... :-) The idea would be to put some guys trying to spot those bugs (I haven't thought about it pretty well, but at least it will be entertaining for me :-) to collect the bugs, that is :-) )

4gl bug

runrig on 2004-03-04T23:44:06

This was a long uncaught bug. By default, all program variables are Sql bind variables, and if you're referring to a column in a table, then you need to qualify it by prefixing it with the table name, or a '@'.
delete from some_table where id_field = id_field
The table was used to pass data between programs, and we were wondering why some programs sometimes didn't get their data :-)