[Firebird-devel] [FB-Tracker] Created: (CORE-3296) invalid request BLR at offset 95

[Karol B. (JIRA) <tr...@fi...>]

invalid request BLR at offset 95
--------------------------------

                 Key: CORE-3296
                 URL: http://tracker.firebirdsql.org/browse/CORE-3296
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.1.3, 2.1.4
            Reporter: Karol Bieniaszewski


CREATE TABLE VAT_ZAK
(
  ID Integer NOT NULL,
  SYS_NR Integer,
  CONSTRAINT PK_VAT_ZAK__ID PRIMARY KEY (ID)
);

CREATE TABLE ELEMENTY
(
   ID Integer NOT NULL,
  ID_VAT_SPRZ Integer,
CONSTRAINT PK_ELEMENTY__ID PRIMARY KEY (ID)
);



UPDATE  
ELEMENTY E  
SET  
E.ID_VAT_SPRZ= 
CASE 
(SELECT V.SYS_NR FROM VAT_ZAK V WHERE V.ID=E.ID_VAT_SPRZ)  
WHEN 1 THEN (SELECT V.ID FROM VAT_ZAK V WHERE V.SYS_NR=7)  
WHEN 2 THEN (SELECT V.ID FROM VAT_ZAK V WHERE V.SYS_NR=8)  
WHEN 3 THEN (SELECT V.ID FROM VAT_ZAK V WHERE V.SYS_NR=9)  
ELSE E.ID_VAT_SPRZ  END 


Engine Code    : 335544343
Engine Message :
invalid request BLR at offset 95
context already in use (BLR error)






-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira