Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Visual Editing |
| Version | 16.0 |
Operating Environment : Windows, Linux
Issue : Informix 12.1, unable to create table with datatype JSON and BSON.
Steps to Reproduce :
1.Launch ADS.
2.Goto tree node and right click on "Tables" and select option "Create Table"
3) In Create Table window,
1) Select schema that you want
2) Specify column name and select datatype "JSON/BSON"
3) Click on "Create" button
>>Table will not get created and it shows message "Type (bson) is not found" / "Type (json) is not found".
Please see attached screenshot "json_bson.png"
|
|
52 KB
Not able to reproduce the issue. Can you try with the latest version of ADS ? Also let us know what version of Informix you are trying to connect to
I am testing with Informix12.1.
Yes i have tested with latest version "ADS 16.0.0-dev-30 " and it still giving me error.
Can you please try with below script :
1) CREATE TABLE informix.table_Json ( c_json JSON )
Go
2) CREATE TABLE informix.table_Bson ( c_bson BSON )
Go
I am testing with Informix12.1.
Yes i have tested with latest version "ADS 16.0.0-dev-30 " and it still giving me error.
Can you please try with below script :
1) CREATE TABLE informix.table_Json ( c_json JSON )
Go
2) CREATE TABLE informix.table_Bson ( c_bson BSON )
Go
I can create the JSON/BSON data and insert data. I sent you an email earlier with the SQLs. Can you make sure that you have the correct 12.1 server and the Driver ? We don't seem to have any issues.
I can create the JSON/BSON data and insert data. I sent you an email earlier with the SQLs. Can you make sure that you have the correct 12.1 server and the Driver ? We don't seem to have any issues.
Informix12.10FC1 does not support JSON,BSON. You can create tables with JSON or the BSON datatypes with the version Informix12.10FC4
Informix12.10FC1 does not support JSON,BSON. You can create tables with JSON or the BSON datatypes with the version Informix12.10FC4
Issue #12671 |
| Closed |
| Invalid |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Not able to reproduce the issue. Can you try with the latest version of ADS ? Also let us know what version of Informix you are trying to connect to