[ https://issues.apache.org/jira/browse/TRAFODION-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall closed TRAFODION-1678. ------------------------------------------- Fixed in Release 2.0. > Some statements cause DROP SCHEMA to fail with DTM error 97 > ----------------------------------------------------------- > > Key: TRAFODION-1678 > URL: https://issues.apache.org/jira/browse/TRAFODION-1678 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 1.3-incubating > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > Fix For: 2.0-incubating > > > The following script succeeds in sqlci, however in Trafci, the last two DROP > SCHEMA statements fail with DTM error 97: > log mytest.log clear; > create schema myschema_1; > set schema myschema_1; > create table mytable (a int, b int); > -- update statistics for table mytable on every column; > showcontrol all; > drop schema myschema_1 cascade; > create schema myschema_2; > set schema myschema_2; > create table mytable (a int, b int); > update statistics for table mytable on every column; > -- showcontrol all; > drop schema myschema_2 cascade; > create schema myschema_3; > set schema myschema_3; > create table mytable (a int, b int); > update statistics for table mytable on every column; > showcontrol all; > drop schema myschema_3 cascade; > create schema myschema_4; > set schema myschema_4; > create table mytable (a int, b int); > update statistics for table mytable on every column; > showtransaction; > drop schema myschema_4 cascade; > exit; > Here is an example of the failing DROP SCHEMA statement taken from a Trafci > log: > SQL>drop schema myschema_3 cascade; > *** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit > transaction. [2015-09-22 17:39:06] > The "drop schema myschema_4 cascade" fails similarly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)