#14687: Ubuntu: Boolean datatype is considered as Numeric | Aqua Data Studio

Issues
Search Tips

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
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Narendra Vatsaraj

narendravatsaraj(*) reported 2016-09-12T08:51:54Z · last modified 2018-03-10T01:41:00Z

Ubuntu: Boolean datatype is considered as Numeric

Dev
QA

Priority	Low
Complexity	Unknown

Component	Tools - Excel Import
Version	Future - PM

1.Open ADS 17.0.8
2.Connect to any database who supports Boolean data type.(say PostgreSQL).
3.Execute below SQL.

CREATE TABLE "boolean_table1" (

"c_boolean" bool NULL

)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(false)

GO

INSERT INTO "boolean_table1"("c_boolean")

VALUES(true)

GO

4.Save this grid result in excel file.(I used "View As Spreadsheet" option).

5.Try to import saved excel file in this table.
6.In saved xlsx file, values are exported as 1 for TRUE and 0 for FALSE.

7.When we import this excel file, UI treats boolean data as Numeric datatype.

Observation: If we consider excel file having true/false values,then ADS maps as "Boolean".
If we try to import excel file having values 1/0 ,then ADS maps as "Numeric".

2 attachments

boolean.xlsx

2016-09-12T08:51:54Z

5 KB
ADS_V17_0_8.png

2016-09-12T08:51:54Z

234 KB

All Comments (3) Change History

Narendra Vatsaraj

narendravatsaraj(*) 2016-09-12T08:53:09Z

From Dev Ram

Dear All,

I have done check-in at SVN r747 to resolve issue#2130,#2143,#2167 made changes to POI's AQExcelSheet.java and to resolve issue#2220 made changes to Metamodel's AQExcelSheet.java

Ready For Review

Narendra Vatsaraj

narendravatsaraj(*) 2016-09-12T08:53:28Z

From Tom

Hi Ram, I don't think that the changes resolve the issue. It seems that the column is defined as a numeric and so any value is translated into a numeric. I was not able to find a way to determine that the column is a boolean. Have another look and see if there is a way to resolve it. Thanks, Tom

Narendra Vatsaraj

narendravatsaraj(*) 2016-09-12T08:53:49Z

From SachinPrakash

When importing a column whose destination type is boolean, we could try converting the input data to a boolean. What would the logic be? If 0 or "false" then FALSE else TRUE?

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