Customer has reported that creating a table with static columns causes our extraction to function incorrectly. below are 2 create table examples which will create tables with the same amount of columns except that the first table has 2 static columns. If you run these scripts our extraction does not show the correct columns nor does it script the table correctly for the table with static columns.
create table test1.teammember_by_team1 ( teamname text, manager text static, location text static, membername text, nationality text, position text, PRIMARY KEY ((teamname), membername)) GO create table test1.teammember_by_team2 ( teamname text, manager text, location text, membername text, nationality text, position text, PRIMARY KEY (teamname, membername)) GO
While I am fixing this issue, I am testing issues and found that the following table script does not correctly script the primary keys when multiple keys are passed.
CREATE TABLE test1.loads ( machine inet, cpu int, mtime timeuuid, load float, PRIMARY KEY ((machine, cpu), mtime) ) WITH CLUSTERING ORDER BY (mtime DESC)
Making required code changes to insure that keys are correctly extracted and scripted.
(a) Modifications made to extraction to correctly support STATIC columns.
(b) Modifications made to extraction to correctly support key columns.
(c) Modifications made to the tree node so that static columns will display STATIC left of its type information.
Committed revision : 52569 - v18
Committed revision: 52570 - v17
(a) Modifications made to extraction to correctly support STATIC columns.
(b) Modifications made to extraction to correctly support key columns.
(c) Modifications made to the tree node so that static columns will display STATIC left of its type information.
Committed revision : 52569 - v18
Committed revision: 52570 - v17
Issue #14907 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
While I am fixing this issue, I am testing issues and found that the following table script does not correctly script the primary keys when multiple keys are passed.
Making required code changes to insure that keys are correctly extracted and scripted.