Hi,
I have a weird behavior here. Database after b&r, no errors. I try to
insert non-unique value into table with unique constraint and it fails
as it should. I encrypt it (AES128 from IBPhoenix) and the same
statement does not fail. Only the next one will throw unique violation.
Here's a snap from console:
$ .\isql.exe
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB' user
'sysdba' password 'masterkey';
Database: 'localhost:C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB', User:
SYSDBA
SQL> insert into product2suppdoc(productid, supportingdocumentid) values
(17,1);
Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "UNQ_PRODUCT2SUPPDOC" on
table "PRODUCT2SUPPDOC"
-Problematic key value is ("PRODUCTID" = 17, "SUPPORTINGDOCUMENTID" = 1)
SQL> alter database encrypt with aes128;
SQL> commit;
SQL> exit;
$ .\isql.exe
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB' user
'sysdba' password 'masterkey';
Database: 'localhost:C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB', User:
SYSDBA
SQL> insert into product2suppdoc(productid, supportingdocumentid) values
(17,1);
SQL> insert into product2suppdoc(productid, supportingdocumentid) values
(17,1);
Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "UNQ_PRODUCT2SUPPDOC" on
table "PRODUCT2SUPPDOC"
-Problematic key value is ("PRODUCTID" = 17, "SUPPORTINGDOCUMENTID" = 1)
SQL>
Any ideas what could be wrong and where to look at?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
------------------------------------------------------------------------------
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
