Re: DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

On 2/1/24 00:51, Rick Hillegas wrote: When I run fxmovierentals6-all.sql, I get a violation of a different foreign key than the one mentioned in the comment at the end of the script. I get this error: ERROR 23516: The transaction was aborted because of a deferred constraint violation: Forei

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813401#comment-17813401 ] Bart van der Bilt commented on DERBY-6303: -- After fixing the data this works gre

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: (was: fxmovierentals6-all.sql) > Add ability to defer enforcement of uniq

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: movies_insert_fk7.sql > Add ability to defer enforcement of unique indexes un

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: movierentals26.sql > Add ability to defer enforcement of unique indexes until

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: (was: movies_insert_fk7.sql) > Add ability to defer enforcement of unique

Re: DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

When I run fxmovierentals6-all.sql, I get a violation of a different foreign key than the one mentioned in the comment at the end of the script. I get this error: ERROR 23516: The transaction was aborted because of a deferred constraint violation: Foreign key 'FK9_talent_talent_id_TalentPhoto

Re: DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

On 1/31/24 00:51, Rick Hillegas wrote: On 1/30/24 12:52 PM, jazz wrote: Hi, It would be great if this issue could be implemented, I have a use case for testing. How do I get access to JIRA to update the ticket? (to include the sql files for testing). You can request a JIRA account here: ht

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812859#comment-17812859 ] Bart van der Bilt commented on DERBY-6303: -- I added 2 sql files as test case. Al

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: movies_insert_fk7.sql > Add ability to defer enforcement of unique indexes un

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: fxmovierentals6-all.sql > Add ability to defer enforcement of unique indexes

Re: DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

On 1/30/24 12:52 PM, jazz wrote: Hi, It would be great if this issue could be implemented, I have a use case for testing. How do I get access to JIRA to update the ticket? (to include the sql files for testing). You can request a JIRA account here: https://selfserve.apache.org/jira-account.ht

DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

Hi, It would be great if this issue could be implemented, I have a use case for testing. How do I get access to JIRA to update the ticket? (to include the sql files for testing). When importing data into the database (which has foreign keys and unique constraints) this is useful. Import fail

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13980125#comment-13980125 ] Dag H. Wanvik commented on DERBY-6303: -- That might have performance implications: def

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13965747#comment-13965747 ] Rick Hillegas commented on DERBY-6303: -- Hi Dag, I haven't worked out any syntax for

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13965733#comment-13965733 ] Dag H. Wanvik commented on DERBY-6303: -- Hi Rick, do you have any specific syntax in m

[jira] [Created] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

Rick Hillegas created DERBY-6303: Summary: Add ability to defer enforcement of unique indexes until transaction end. Key: DERBY-6303 URL: https://issues.apache.org/jira/browse/DERBY-6303 Project: Derb