[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-6905: ----------------------------------- Attachment: dblook_tests.diff I agree with Rick's assessment that these tests are failing due to the new column we added to SYSCOLUMNS. And, I believe that the output is now correctly including the new column. Attached 'dblook_tests.diff' is a patch which promotes the output files; with this patch applied, these tests pass for me. Vardhan, can you please review the tests and this patch and let me know what you think? > Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column > ----------------------------------------------------------------------- > > Key: DERBY-6905 > URL: https://issues.apache.org/jira/browse/DERBY-6905 > Project: Derby > Issue Type: Sub-task > Components: SQL > Affects Versions: 10.13.1.0 > Reporter: Bryan Pendleton > Assignee: Harshvardhan Gupta > Priority: Minor > Fix For: 10.14.0.0 > > Attachments: dblook_tests.diff > > > DERBY-6542 changed IDENTITY columns to build upon the underlying > SEQUENCE objects. SEQUENCE objects can have a CYCLE option > set for them, and as of DERBY-6852, the CYCLE option controls the > behavior of the IDENTITY column that uses that SEQUENCE. > It would be nice if SYS.SYSCOLUMNS would report the CYCLE option > that is in effect for a IDENTITY column in that column's row in SYSCOLUMNS. -- This message was sent by Atlassian JIRA (v6.4.14#64029)