Re: [Squirrel-sql-users] A wrong SQL Update statement and Squirrel detect it, but still the first part of SQL statement is being executed

[Gerd W. <ger...@t-...>]

On 12.01.2012 23:00, John Hardin wrote:
> On Thu, 12 Jan 2012, Paulus Gunawan wrote:
>
>> UPDATE TABLE_A WHERE STATUS = 'X';
>
> That seems to be an incomplete UPDATE statement (no SET clause).
>
> What SQL engine accepted that query as valid? What is it supposed to do?
>
I copied the statement from Paulus's mail quoted below. The statement is 
not correct SQL syntax but from the context of the original mail the 
statement is good enough to make sense in its context.

But you are right, it would have been clearer if I had written

UPDATE TABLE_A ... WHERE STATUS = 'X'


Gerd



On 12.01.2012 15:02, Paulus Gunawan wrote:
 > Hello,
 > Sorry to disturb.
 > I'm currently using SquirreL SQL Client v3.1.2. This is a great SQL 
tools.
 > Recently I got a very bad accident because I wrongly wrote the SQL
 > statement as follows:
 > UPDATE TABLE_A WHERE STATUS = 'X' ; AND KEY='Y';
 > I found that SquirreL detect the error (there is an ':' in the mid of
 > statement there), however I found that SquirreL actually is executing
 > this part:
 > UPDATE TABLE_A WHERE STATUS = 'X';
 > This incident had given me a lot of problems.
 > My question is whether this kind of problem had been resolved in later
 > Squirrel release?
 > If not, how to raise the case in order this can be resolved. Please 
advise.
 > Thanks,
 > Paulus
 >
 >