Bug #7120
NO-UNDO dynamic temp-table does not set the NO-UNDO at the .schema
Start date:
Due date:
% Done:
100%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:
History
#1 Updated by Constantin Asofiei over 3 years ago
This test:
def temp-table tt1 no-undo field f1 as clob.
def var ht as handle.
create temp-table ht.
ht:create-like(temp-table tt1:handle).
ht:temp-table-prepare("ttt").
message ht:undo.
produces this warning during the dynamic conversion:
WARNING: Large object fields can only be defined in NO-UNDO Temp-Tables. (14435)
Field field1(FIELD_CLOB):0 in table dtt1(TEMP_TABLE):0
This is because the NO-UNDO property:
<ast col="0" id="38654705667" line="0" text="properties" type="PROPERTIES">
<ast col="20" id="38654705668" line="1" text="no-undo" type="KW_NO_UNDO"/>
</ast>
is not being created by
DynamicTablesHelper.generateSchemaAst.#3 Updated by Ovidiu Maxiniuc over 3 years ago
- % Done changed from 0 to 100
- Assignee set to Ovidiu Maxiniuc
- Status changed from New to WIP
Good analysis!
Actually, the value of the undo table attribute is not copied from the source table. It is by default false. However, if desired, it CAN be set programmatically after create-like.
I added the missing node and the test works correctly now.
Committed to 6129c as r14809.
#4 Updated by Constantin Asofiei over 3 years ago
- Status changed from WIP to Test
Changes look good. Thanks.