× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Slava Gryb
slavakiev reported 2013-10-28T11:52:48Z  · tariqrahiman last modified 2013-10-30T20:55:02Z

Regression with timestamp


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component DB - Cassandra
Version 14.0
Tested in Aqua Data Studio 14.0.3-4 Build #: 34540 on Ubuntu 12.04(Cassandra 2.0.1)
 
1, timestamp column in ADS tree and generated scripts shown as "TimestampType". Such table can't be open in Table Editor.  
 
E.g. if you create table:
 
create table stamp(ts timestamp,
primary key(ts))
go
 
It can't be opened in Table Editor - error "The query did not return any results" 
 
Also Script Object gives next:
 
CREATE TABLE "stamp"  ( 
"ts" TimestampType,
"ts" TimestampType,
PRIMARY KEY("ts","ts")
) WITH
"bloom_filter_fp_chance"='0.01' AND "caching"='KEYS_ONLY' AND "dclocal_read_repair_chance"='0.0' AND "gc_grace_seconds"='864000' AND "read_repair_chance"='0.1' AND "replicate_on_write"='true'
AND compaction = {'class':'SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression':'org.apache.cassandra.io.compress.LZ4Compressor'}
GO
 
2. Any insert into timestamp column produces error:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
create table fortime(id int, 
timestamp timestamp,
PRIMARY KEY(id))
go
insert into fortime(id,timestamp) values(1,'2011-02-03')
go
select * from fortime where id=1
-- java.lang.StringIndexOutOfBoundsException: String index out of range: -1 
go
insert into fortime(id,timestamp) values(2,345)
go
select * from fortime where id=2
--java.lang.StringIndexOutOfBoundsException: String index out of range: -1
go
 

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #10614
Closed
Fixed
Resolved 2013-10-29T20:25:33Z
 
 
Completion
No due date
Fixed Build ADS 14.0.3-8
No time estimate

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