Server crashes with access violation when inserting row into table with unique
index
------------------------------------------------------------------------------------
Key: CORE-3627
URL: http://tracker.firebirdsql.org/browse/CORE-3627
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1, 2.5.0
Environment: Windows 7 64-bit, Windows XP 32-bit
Reporter: Marcin Wojda
Priority: Minor
To reproduce run the following two scripts with isql.exe (each script sould be
executed separately):
1. Create database with table and two rows with the script:
CREATE DATABASE 'test.fdb' USER 'sysdba' PASSWORD 'masterkey';
CREATE TABLE TestTable
(
"ID" INTEGER NOT NULL,
"CLASSID" INTEGER,
PRIMARY KEY ("ID")
);
insert into TestTable values(1, 1);
insert into TestTable values(2, 2);
2. Add index and try to insert a record with second script:
ALTER TABLE TestTable ADD KsgFK integer;
CREATE UNIQUE INDEX ClassIdKsgIdx ON TestTable (ClassId, KsgFK);
insert into TestTable values(3,1,Null);
The server will crash with message:
Access violation.
The code attempted to access a virtual address without privilege to do so. This
exception will cause the Firebird server to terminate abnormally.
Updating the table "TestTable" with query: update TestTable set Id = Id; before
inserting the third row solves the problem - the statment fails with message
"attemp to store duplicate value".
--
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
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
