Invalid blob id when add a new blob column of type text and update another field
--------------------------------------------------------------------------------
Key: CORE-5600
URL: http://tracker.firebirdsql.org/browse/CORE-5600
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.2
Environment: Windows 10 Enterprise
Reporter: bug tracker
Priority: Blocker
I can create the issue using folowing steps:
step 1:
-------
CREATE TABLE Operation ( ID BIGINT NOT NULL,Operation_Type BIGINT NOT
NULL,DATE_CREATE BIGINT NOT NULL,DATE_OPERATION BIGINT NOT NULL,Code BIGINT NOT
NULL,NAME BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,D_VALUE
DOUBLE PRECISION DEFAULT 0 NOT NULL )
step 2:
-------
ALTER TABLE Operation ADD CONSTRAINT operation_pk_1 PRIMARY KEY ( ID )
step 3:
-------
execute block
as
declare i bigint = 1;
begin
while (i <= 20) do
begin
update or insert into Operation(ID,
Operation_Type,DATE_CREATE,DATE_OPERATION,Code,NAME,D_VALUE) values
(:i,0,132345666243423423,132345666243423423,:i,'test',1);
i = i + 1;
end
end
step 4:
-------
ALTER TABLE Operation ADD surname BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT
'' NOT NULL
step 5:
-------
update operation set code=2 where id=2
When update is done if I run Select * from Operation, the error 'Invalid Blob
Id' appears.
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
