#13179: Informix12.10 : unable to perform Select operation on table for datatype BSON when imports data using batch operation

deepalisalve reported 2015-03-26T06:54:03Z · last modified 2015-04-20T08:47:19Z

Informix12.10 : unable to perform Select operation on table for datatype BSON when imports data using batch operation

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - Import Tool
Version	16.0

Product: Aqua Data Studio

Version: 16.0.1-8

Build #: 43117

Build Date: 2015-Mar-24 04:04:04 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19

Memory: Max=704,643,072; Total=475,529,216; Free=246,952,168; CPUs=8

Operating Environment : Windows, Linux
Issue : Informix12.10 : unable to perform Select operation on table for datatype BSON when imports data using batch operation

Steps to Reproduce :
1) Launch ADS and connect to Informix 12.10. Open View log.
2) Create table using BSON datatype. Use below scripts of Create and Insert

CREATE TABLE "informix".t_bson ( col_bson BSON )

LOCK MODE PAGE

INSERT INTO "informix".t_bson(col_bson)

VALUES("{ID:10}"::JSON)

3) Export this data in csv file using export tool.
4) Now right click on same table and select import tool
5) In Import tool, browse csv file then click Next button till Transaction tab.
In Transaction tab, select "Transaction Type->Batch"
Click Next button.
>Data will successfully imported into specified table.
6) Now run Select(*) query for same table
>>Result is not displayed and shows message

>[Error] Script lines: 2-3 --------------------------

should be impossible

Observation :
1) Issues occurs only for datatype BSON and if we perform batch operation.
2) Even if you use new window it shows same error and unable to perform Select query.You will need to Create new table every time.

Please see attached screenshot "BSON_select".png"

2 attachments

BSON_select.png

2015-03-26T07:06:22Z

63 KB
13179.csv

2015-04-09T20:39:58Z

174 B

All Comments (5) Change History

deepalisalve 2015-03-26T09:02:51Z · (edited)

Importing through fluidshell same behavior observed.

tariqrahiman 2015-04-09T20:39:48Z

CREATE TABLE "informix".bson_batch( col_bson BSON )

LOCK MODE PAGE

INSERT INTO "informix".bson_batch(col_bson)

VALUES('{ID:10}'::JSON)

INSERT INTO "informix".bson_batch(col_bson)

VALUES('{ID:11}'::JSON)

INSERT INTO "informix".bson_batch(col_bson)

VALUES('{ID:12}'::JSON)

tariqrahiman 2015-04-09T20:40:33Z

Verified in ADS v16.0.3-12

deepalisalve 2015-04-10T04:22:25Z

Wroking fine.
Verified in ADS 17.0.0-dev-14 and ADS 16.0.3-14

deepalisalve 2015-04-20T08:47:19Z

Verified in ADS 16.0.4

Search Tips

Aqua Data Studio / nhilam

Informix12.10 : unable to perform Select operation on table for datatype BSON when imports data using batch operation

2 attachments

Issue #13179

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Informix12.10 : unable to perform Select operation on table for datatype BSON when imports data using batch operation

2 attachments

Issue #13179

Completion