Tested in Aqua Data Studio 14.0.3-4 Build #: 34540 on Ubuntu 12.04(Cassandra 2.0.1)
In Table properties and in Script Object/SCript Scema column from Primary Key is duplicated.
E.g. create table only with one column id( in ADS GUI or by SQL statement) and then Script Object in Windows as Create:
CREATE TABLE idtable(
id int,
PRIMARY KEY(id)
able to reproduce in Cassandra v2.0+ only
Looks like this issue is due to using keyspace created in version 1.2.10. When I created new keyspace in version 2.0.1 then this issue does not occure fully(Table Options is correct but Script Object/SCript Scema still show duplication)
Looks like this issue is due to using keyspace created in version 1.2.10. When I created new keyspace in version 2.0.1 then this issue does not occure fully(Table Options is correct but Script Object/SCript Scema still show duplication)
In Cassandra 1.2.x, key columns are stored in schema_columnfamilies and non-key columns are in schema_columns. However, in Cassandra 2.x, all columns are in schema_columns. Therefore, the key columns were duplicated.
Fixed metadata extraction code to skip the key columns in schema_columns.
In Cassandra 1.2.x, key columns are stored in schema_columnfamilies and non-key columns are in schema_columns. However, in Cassandra 2.x, all columns are in schema_columns. Therefore, the key columns were duplicated.
Fixed metadata extraction code to skip the key columns in schema_columns.
Issue #10604 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.3-8 |
No time estimate |
able to reproduce in Cassandra v2.0+ only