Product: Aqua Data Studio
Version: 15.0.7-23
Build #: 40450
Build Date: 2014-Oct-03 09:43:41 AM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=358,088,704; Free=183,686,192; CPUs=8
-
Connect to PostgreSQL database.
-
Double-click Databases to expand the node.
-
Again double-click on any database node to expand it.
-
Right-click on "public" schema, and click Query Analyzer.
-
Run the below script on Query Analyzer pane.
create table insert (
col_varchar varchar,
col_money money
);
-
Import data to the table using the attached file (InsertData.txt).
a) Delimited: ,
b) String Quoted Identifier: "
c) Destination: Preview INSERT statement
Issue: In the preview statement, ADS removes the paranthesis. Hence the value is inserted as positive record.
Observation:
a) If I insert data to any table using the insert statement, then the data in paranthesis is inserted as negative data.
b) According to property of import data tool, special characters and alphabetical characters are ignored for numeric data types. Only the numeric value is imported.
For money data type, if insert statement allows to paranthesis, then the same is expected while importing data.
Current result:
INSERT INTO public.insert(col_varchar, col_money)
VALUES('A', '5'::money)
GO
INSERT INTO public.insert(col_varchar, col_money)
VALUES('b', '7'::money)
GO
Expected Result:
INSERT INTO public.insert(col_varchar, col_money)
VALUES('A', '5'::money)
GO
INSERT INTO public.insert(col_varchar, col_money)
VALUES('b', '(7)'::money)
GO
