PRSQL9103015: Referencing a Table Created in a Transaction ID Number: Q70835
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103015
SYMPTOMS Referencing a table that was supposed to be created by a SELECT INTO statement inside of a BEGIN…COMMIT transaction will GP-fault SQL Server.
CAUSE A SELECT INTO statement is not allowed within a user-defined transaction.
RESOLUTION Create the table outside of the user-defined transaction. If the transaction fails, set the global variable @@error, and rollback the transaction. Then, outside of the transaction, check for the value of @@error, and drop the table if this value is set.