Looks like we need to enhance the JDBC to handle new types for V3.0
1. Here is the ddl to create the table. Open a Cassandra QA window and execute the following:
|
135 KB
Field | Old Value | New Value |
---|---|---|
Description | Looks like we need to enhance the JDBC to handle new types for V3.0 1. Here is the ddl to create the table. Open a Cassandra QA window and execute the following:
CREATE TABLE "new_datatypes" (
date_s date,
smallint_s smallint,
time_s time,
tinyint_s tinyint,
PRIMARY KEY(smallint_s)
) WITH
"bloom_filter_fp_chance"='0.01' AND "dclocal_read_repair_chance"='0.0' AND "gc_grace_seconds"='864000' AND "read_repair_chance"='0.1'
AND compaction = {'class':'SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression':'org.apache.cassandra.io.compress.LZ4Compressor'}
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(45,'2017-07-03','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(44,'2017-07-04','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(42,'2017-07-03','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(40,'2017-07-03','19:10:12',10)
GO
2. When you do a select on this table in the QA window, select * from new_datatypes, you get a java.lang.StringIndexOutOfBoundsException: String index out of range: -1 exception. See here.
|
Looks like we need to enhance the JDBC to handle new types for V3.0 1. Here is the ddl to create the table. Open a Cassandra QA window and execute the following:
CREATE TABLE "new_datatypes" (
date_s date,
smallint_s smallint,
time_s time,
tinyint_s tinyint,
PRIMARY KEY(smallint_s)
) WITH
"bloom_filter_fp_chance"='0.01' AND "dclocal_read_repair_chance"='0.0' AND "gc_grace_seconds"='864000' AND "read_repair_chance"='0.1'
AND compaction = {'class':'SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression':'org.apache.cassandra.io.compress.LZ4Compressor'}
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(45,'2017-07-03','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(44,'2017-07-04','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(42,'2017-07-03','19:10:12',10)
GO
INSERT INTO new_datatypes(smallint_s, date_s, time_s, tinyint_s)
VALUES(40,'2017-07-03','19:10:12',10)
GO
2. When you do a select on this table in the QA window, select * from new_datatypes, you get a java.lang.StringIndexOutOfBoundsException: String index out of range: -1 exception. See here.
|
Field | Old Value | New Value |
---|---|---|
Type | Support | Feature |
Field | Old Value | New Value |
---|---|---|
Version | 20.0 | 18.5 |
Field | Old Value | New Value |
---|---|---|
Dev Assignee | SachinPrakash (Sachin Prakash) | kunalkalbande (kunal kalbande) |
QA Assignee | tariqrahiman (Tariq Rahiman) | tomconrad (Thomas Conrad) |
Field | Old Value | New Value |
---|---|---|
QA Assignee | tomconrad (Thomas Conrad) | abdullah (Abdullah Asif) |
Field | Old Value | New Value |
---|---|---|
Fixed Build | 18.5 | |
Resolution | Fixed | |
Resolved Date | Sep 22, 2017 10:41 AM | |
Status | New | Resolved |
Time Estimate | 10.0 |
Field | Old Value | New Value |
---|---|---|
Status | Resolved | Verified |
Field | Old Value | New Value |
---|---|---|
Resolution | Fixed | Incomplete |
Resolved Date | Sep 22, 2017 10:41 AM | |
Status | Verified | Reopened |
Field | Old Value | New Value |
---|---|---|
Resolution | Incomplete | Fixed |
Resolved Date | Oct 5, 2017 1:41 PM | |
Status | Reopened | Resolved |
Time Estimate | 10.0 | 12.0 |
Field | Old Value | New Value |
---|---|---|
Status | Resolved | Verified |
Field | Old Value | New Value |
---|---|---|
QA Assignee | abdullah (Abdullah Asif) | tomconrad (Thomas Conrad) |
Field | Old Value | New Value |
---|---|---|
Resolution | Fixed | Incomplete |
Resolved Date | Oct 5, 2017 1:41 PM | |
Status | Verified | Reopened |
Field | Old Value | New Value |
---|---|---|
Resolution | Incomplete | |
Status | Reopened | In Progress |
Field | Old Value | New Value |
---|---|---|
Resolution | Fixed | |
Resolved Date | Nov 16, 2017 3:35 PM | |
Status | In Progress | Resolved |
Time Estimate | 12.0 | 20.0 |
Field | Old Value | New Value |
---|---|---|
Resolution | Fixed | Incomplete |
Resolved Date | Nov 16, 2017 3:35 PM | |
Status | Resolved | Reopened |
Field | Old Value | New Value |
---|---|---|
Resolution | Incomplete | Fixed |
Resolved Date | Nov 20, 2017 5:27 AM | |
Status | Reopened | Resolved |
Time Estimate | 20.0 | 20.5 |
Field | Old Value | New Value |
---|---|---|
Status | Resolved | Verified |
Field | Old Value | New Value |
---|---|---|
Status | Verified | Closed |
Issue #15387 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 18.5 |
Time Estimate 20 hours 30 minutes |
1 issue link |
relates to #15487
Issue #15487Cassandra - Add new 3.0 types to the ERM |