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

[John H. <jh...@im...>]

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?

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Where We Want You To Go Today 09/13/07: Microsoft patents in-OS
   adware architecture that incorporates monitoring and analysis of
   user actions and interrupting the user to display apparently
   relevant advertisements (U.S. Patent #20070214042)
-----------------------------------------------------------------------
  5 days until Benjamin Franklin's 306th Birthday