Bug #2259
computed character columns are not created for dynamic tables
Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
03/14/2014
Due date:
% Done:
100%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:
Related issues
History
#1 Updated by Stanislav Lomany over 12 years ago
1. For static temp tables computed columns ("__fieldName") are created for indexed character columns. For dynamic temp-tables they are not created which is incorrect.
2. Flags CHARACTER and IGNORE_CASE are not properly set for components of dynamic table indexes.
3. When CREATE-LIKE takes a table which uses computed columns as the argument, that causes error.
Testcase:
def temp-table tt
field f1 as char
index idx1 f1.
create tt.
def var h as handle.
def var bh as handle.
create temp-table h.
h:create-like("tt").
h:temp-table-prepare("tt").
bh = h:default-buffer-handle.
bh:buffer-create.
Error:
[03/14/2014 17:11:18 TMT] (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:ERROR) Column "__FIELD1" not found; SQL statement: create index idx__dtt1_1__1 on dtt1 (__field1, _multiplex, id) [42122-169]
#2 Updated by Eric Faulhaber over 12 years ago
- Assignee set to Stanislav Lomany
- Target version set to Milestone 11
#3 Updated by Stanislav Lomany over 12 years ago
- Assignee changed from Stanislav Lomany to Ovidiu Maxiniuc
#4 Updated by Eric Faulhaber about 12 years ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Issue has been addressed as part of #1661.
#5 Updated by Greg Shah over 9 years ago
- Target version changed from Milestone 11 to Cleanup and Stablization for Server Features