× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Thomas Conrad
tomconrad reported Jul 18, 2017  · last modified Feb 8, 2018

Cassandra - JDBC should be enhanced to handle the new types


Dev
kunal kalbande
kunalkalbande
QA
Thomas Conrad
tomconrad
Priority Low
Complexity Unknown
Component DB - Cassandra
Version 18.5

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.
 

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments Change History (18)
Sort 
Thomas Conrad
tomconrad   Jul 18, 2017
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.
 

 
Tariq Rahiman
tariqrahiman   Jul 20, 2017
Field Old Value New Value
Type Support Feature
Nhi Lam
nhilam   Sep 6, 2017
Field Old Value New Value
Version 20.0 18.5
Nhi Lam
nhilam   Sep 14, 2017
Field Old Value New Value
Dev Assignee SachinPrakash (Sachin Prakash) kunalkalbande (kunal kalbande)
QA Assignee tariqrahiman (Tariq Rahiman) tomconrad (Thomas Conrad)
Abdullah Asif
abdullah   Sep 21, 2017
Field Old Value New Value
QA Assignee tomconrad (Thomas Conrad) abdullah (Abdullah Asif)
sagar zond
sagarzond   Sep 22, 2017
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
Supriya sarade
supriyasarade   Oct 4, 2017
Field Old Value New Value
Status Resolved Verified
Thomas Conrad
tomconrad   Oct 4, 2017
Field Old Value New Value
Resolution Fixed Incomplete
Resolved Date Sep 22, 2017 10:41 AM
Status Verified Reopened
sagar zond
sagarzond   Oct 5, 2017
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
Supriya sarade
supriyasarade   Oct 9, 2017
Field Old Value New Value
Status Resolved Verified
Abdullah Asif
abdullah   Oct 11, 2017
Field Old Value New Value
QA Assignee abdullah (Abdullah Asif) tomconrad (Thomas Conrad)
Thomas Conrad
tomconrad   Nov 15, 2017
Field Old Value New Value
Resolution Fixed Incomplete
Resolved Date Oct 5, 2017 1:41 PM
Status Verified Reopened
Pankaj Isarka
Pankaj.Isarka   Nov 16, 2017
Field Old Value New Value
Resolution Incomplete
Status Reopened In Progress
Pankaj Isarka
Pankaj.Isarka   Nov 16, 2017
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
Thomas Conrad
tomconrad   Nov 16, 2017
Field Old Value New Value
Resolution Fixed Incomplete
Resolved Date Nov 16, 2017 3:35 PM
Status Resolved Reopened
Pankaj Isarka
Pankaj.Isarka   Nov 20, 2017
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
Thomas Conrad
tomconrad   Nov 20, 2017
Field Old Value New Value
Status Resolved Verified
Thomas Conrad
tomconrad   Feb 8, 2018
Field Old Value New Value
Status Verified Closed

Issue #15387
Closed
Fixed
Resolved Nov 20, 2017
 
 
Completion
No due date
Fixed Build 18.5
Time Estimate 20 hours 30 minutes

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017