× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Shavi57 reported 2013-09-17T06:46:51Z  · tariqrahiman last modified 2013-09-27T22:28:31Z

Do not transforms (null) string into NULL in Table Data Editor


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component Tools - Table Data Editor
Version 14.0
Aqua Data Studio 14.0.0-rc-20
 
Database Version: Cassandra 1.2.8
 
1.Go to ADS menu bar-> File-> Options-> General-> Select Table Data Editor-> Check Paste Transforms (null) string into NULL
2.Create table and insert some values in it:
CREATE TABLE "test"  ( 
"c1" text,
"c2" int,
"c3" int,
PRIMARY KEY("c1")
 
INSERT INTO "test"("c1", "c2", "c3") 
  VALUES('asf', 0, 0) 
 
3.Right Click on table "test' in tree node and select Edit Table Data
4.Select c2  cell and right click on it and select Set Cell(s) to Null.
It pastes (null) string into selected cell 
5.Save and Refresh the table data editor
It gives error "Invalid STRING constant () for c2 of type int"
Because it generates SQL statement: 
UPDATE "Shavi"."test"
SET "c2"=''
WHERE "c1"='asf'
GO
 
It do not transforms (null) string into NULL and that is the reason we get error message.

Issue #10020

Closed
Fixed
Resolved 2013-09-24T14:41:48Z
 
 
Completion
No due date
Fixed Build 14.0.0-rc-29/15.0.0-dev-16
No time estimate

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