× Heads up!

Aqua Data Studio / nhilam

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

Cassandra - JDBC should be enhanced to handle the new types


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
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.
 

 

tariqrahiman   Jul 20, 2017
Field Old Value New Value
Type Support Feature
nhilam   Sep 6, 2017
Field Old Value New Value
Version 20.0 18.5
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   Sep 21, 2017
Field Old Value New Value
QA Assignee tomconrad (Thomas Conrad) abdullah (Abdullah Asif)
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
supriyasarade   Oct 4, 2017
Field Old Value New Value
Status Resolved Verified
tomconrad   Oct 4, 2017
Field Old Value New Value
Resolution Fixed Incomplete
Resolved Date Sep 22, 2017 10:41 AM
Status Verified Reopened
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
supriyasarade   Oct 9, 2017
Field Old Value New Value
Status Resolved Verified
abdullah   Oct 11, 2017
Field Old Value New Value
QA Assignee abdullah (Abdullah Asif) tomconrad (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   Nov 16, 2017
Field Old Value New Value
Resolution Incomplete
Status Reopened In Progress
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
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   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
tomconrad   Nov 20, 2017
Field Old Value New Value
Status Resolved Verified
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