[jira] [Closed] (DERBY-6876) Can't create triggers on a table - error 42X94

[ https://issues.apache.org/jira/browse/DERBY-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura closed DERBY-6876. - Resolution: Won't Fix > Can't create triggers on a table - error 42X94 >

[jira] [Comment Edited] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

[ https://issues.apache.org/jira/browse/DERBY-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15252362#comment-15252362 ] Aleksei Kovura edited comment on DERBY-6882 at 4/23/16 4:17 AM: Some

[jira] [Commented] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

[ https://issues.apache.org/jira/browse/DERBY-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15252362#comment-15252362 ] Aleksei Kovura commented on DERBY-6882: --- Some assistance would be nice actually. I tried checking

[jira] [Commented] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

[ https://issues.apache.org/jira/browse/DERBY-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15249709#comment-15249709 ] Aleksei Kovura commented on DERBY-6882: --- Hi Rick, I didn't find any other workaround, so please port

[jira] [Updated] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

[ https://issues.apache.org/jira/browse/DERBY-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6882: -- Description: I'm trying to import data from another Derby database with foreignViews tool

[jira] [Updated] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

[ https://issues.apache.org/jira/browse/DERBY-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6882: -- Description: I'm trying to import data from another Derby database with foreignViews tool

[jira] [Created] (DERBY-6882) Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT

Aleksei Kovura created DERBY-6882: - Summary: Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT Key: DERBY-6882 URL: https://issues.apache.org/jira/browse/DERBY-6882

[jira] [Commented] (DERBY-6876) Can't create triggers on a table - error 42X94

[ https://issues.apache.org/jira/browse/DERBY-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15217926#comment-15217926 ] Aleksei Kovura commented on DERBY-6876: --- Thanks Rick, I didn't think of that. I'm still trying to

[jira] [Commented] (DERBY-6876) Can't create triggers on a table - error 42X94

[ https://issues.apache.org/jira/browse/DERBY-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15216352#comment-15216352 ] Aleksei Kovura commented on DERBY-6876: --- Is there a way to retain values of generated column somehow

[jira] [Commented] (DERBY-6876) Can't create triggers on a table - error 42X94

[ https://issues.apache.org/jira/browse/DERBY-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15197119#comment-15197119 ] Aleksei Kovura commented on DERBY-6876: --- Thanks, I figured that much out, but I was hoping for a

[jira] [Created] (DERBY-6876) Can't create triggers on a table - error 42X94

Aleksei Kovura created DERBY-6876: - Summary: Can't create triggers on a table - error 42X94 Key: DERBY-6876 URL: https://issues.apache.org/jira/browse/DERBY-6876 Project: Derby Issue Type:

[jira] [Updated] (DERBY-6876) Can't create triggers on a table - error 42X94

[ https://issues.apache.org/jira/browse/DERBY-6876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6876: -- Attachment: trigger_bug.zip > Can't create triggers on a table - error 42X94 >

[jira] [Comment Edited] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

[ https://issues.apache.org/jira/browse/DERBY-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14632738#comment-14632738 ] Aleksei Kovura edited comment on DERBY-6783 at 7/23/15 7:00 PM:

[jira] [Commented] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

[ https://issues.apache.org/jira/browse/DERBY-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14632738#comment-14632738 ] Aleksei Kovura commented on DERBY-6783: --- Thanks Abhinav and Bryan. I'll try to build

[jira] [Commented] (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE

[ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14141891#comment-14141891 ] Aleksei Kovura commented on DERBY-4611: --- I need to have a default value for a column

[jira] [Comment Edited] (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE

[ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14141891#comment-14141891 ] Aleksei Kovura edited comment on DERBY-4611 at 9/20/14 9:17 AM:

[jira] [Comment Edited] (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE

[ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14141891#comment-14141891 ] Aleksei Kovura edited comment on DERBY-4611 at 9/20/14 9:23 AM:

[jira] [Issue Comment Deleted] (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE

[ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-4611: -- Comment: was deleted (was: I need to have a default value for a column to be current_timestamp

[jira] [Commented] (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE

[ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14141899#comment-14141899 ] Aleksei Kovura commented on DERBY-4611: --- Are there plans for this to be implemented?

[jira] [Updated] (DERBY-6723) Allow derived table as a source in MERGE statement

[ https://issues.apache.org/jira/browse/DERBY-6723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6723: -- Priority: Major (was: Minor) Allow derived table as a source in MERGE statement

[jira] [Updated] (DERBY-6723) Allow derived table as a source in MERGE statement

[ https://issues.apache.org/jira/browse/DERBY-6723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6723: -- Description: I'm trying to utilize MERGE to do an upsert operation like this: MERGE INTO

[jira] [Updated] (DERBY-6723) Allow derived table as a source in MERGE statement

[ https://issues.apache.org/jira/browse/DERBY-6723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksei Kovura updated DERBY-6723: -- Description: I'm trying to utilize MERGE to do an upsert operation like this: MERGE INTO