× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Diksha Kushwah
Diksha.kushwah(*) reported 2017-06-28T11:51:57Z  · tariqrahiman last modified 2017-06-30T02:16:03Z

Import Excel fail for JSON datatype when we use Batch /Threshold Transaction Type.


Dev
Thomas Conrad
tomconrad
QA
Jenny Nishimura
JennyNishimura
Priority Major
Complexity Unknown
Component DB - PostgreSQL
Version 18.0
Version: 19.0.0-alpha-63
Build #: 54914
Build Date: 2017-Jun-27 05:52:50 PM
 
steps to reproduce:
 
Connect to Postgres DB
 
create following table:
 
CREATE TABLE "t1"  ( 
"c1" json NULL,
"c2" jsonb NULL 
)
GO
 
Right click on table and select Import Data
select attached abc.xls file
Use default settings in General tab
Click on Next
Use default settings in Format tab
Click on Next
In options tab set destination Import into database
click on Next
In Transaction Tab set Transaction Type Batch/Threshold
Click on Next
 
Error message displayed in status tab:
 
t1 --> Execute batch failed: Batch entry 0 INSERT INTO "public"."t1"("c1", "c2")  VALUES('{ "customer": "John Doe", "items": {"product": "Beer","qty": 6}}', '{"name": "fred", "address": {"line1": "52 The Elms", "line2": "Elmstreet", "postcode": "ES1 1ES"}}') was aborted: ERROR: column "c1" is of type json but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.
  Position: 47  Call getNextException to see other errors in the batch.
 
t1 --> ERROR: column "c1" is of type json but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.
  Position: 47
 
Observation: 
 
1. This is also observed with .csv file.
2. Data Imported Successfully with Full Transaction Type.  
 
ADS Builds v 9.6 v9.5 v9.4
ADS 18.0.17-1 Y Y Y
ADS 18.0.0 N N N
ADS 19-alpha-63 Y Y Y
ADS 19-alpha-59 N N N
Y - issue reproducible
N- Issue does not reproduce
 
6 attachments
  •  
  •  
  • No shares
  •  
All Comments (5) Change History
Sort 

Issue #15355
Closed
Fixed
Resolved 2017-06-28T22:22:14Z
 
 
Completion
No due date
Fixed Build ADS 18.0.17-2 & ADS 19.0.0-alpha-65
No time estimate

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