[Firebird-devel] [ firebird-Bugs-604729 ] blind execution of query

[SourceForge.net <no...@so...>]

Bugs item #604729, was opened at 2002-09-04 16:49
Message generated for change (Comment added) made by seanleyne
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=604729&group_id=9028

>Category: Core Engine
>Group: Irreproducible Bug
>Status: Deleted
>Resolution: Rejected
Priority: 5
Submitted By: Pavel Plesov (mclap)
Assigned to: Nobody/Anonymous (nobody)
Summary: blind execution of query

Initial Comment:
FB-T6.2.796                 


=====================================
1:
SQL> 
UPDATE ANEKDOTS SET AN_STATE="1",                                          
CON> 
AN_TEXT="ïÞÃÖÍÁÞÏÕÁÞ×Ð"ïÞÃÖÍÁÞÏÕÁÞ×Ð                                       

CON> WHERE AN_ID="13462";                                                       
Statement failed, 
SQLCODE = -104                                                
                                                                                
Dynamic SQL Error                                                               
-SQL error code = -
104                                                          
-Token unknown - line 2, char 25                                                
-ÞÃ                                                                             

2:
SQL> 
UPDATE ANEKDOTS SET AN_STATE="1",                                          

AN_TEXT="ïÞÃÖÍÁÞÏÕÁÞ×Ð \"ÌÅ ÃÌÞ×, ÌÅ 
ÎÍËÌ×\" ïÞÃÖÍÁÞÏÕÁÞ×Ð"                     
WHERE 
AN_ID="13462";                                                            
CON> CON> Records affected: 7853                                                


3:
SQL> UPDATE ANEKDOTS SET 
AN_STATE="1", AN_TEXT="abc \"a\" def" WHERE 
AN_ID="1346
2";                                                                             
Statement failed, SQLCODE = -104                                                
                                                                                

Dynamic SQL Error                                                               
-SQL error code = -104                                                          
-Token 
unknown - line 1, char 50                                                
-a                                                             

=====================================

3 
query. All of them wrong.

1 & 3 failed as must. But 2... 
executed w/o WHERE clause :(

Why ? ;-)

----------------------------------------------------------------------

>Comment By: Sean Leyne (seanleyne)
Date: 2004-12-31 02:51

Message:
Logged In: YES 
user_id=71163

This entry does not have anough information to allow for 
the "bug" to be reproduced.  

When more details (a complete test script) are provided, this 
entry will be reactivated.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=604729&group_id=9028