Bugs item #1842019, was opened at 2007-12-01 00:08
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1842019&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core
Group: MonetDB5 5.2
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: mharrison (matt_harrison)
>Assigned to: Niels Nes (nielsnes)
Summary: BULK load failing for NUMERIC columns
Initial Comment:
Using a build from today, I'm still getting issues with bulk load...
CREATE TABLE bulk2 (
id NUMERIC(9, 0) NOT NULL,
fax NUMERIC(10, 0),
phone NUMERIC(10, 0),
acctnum NUMERIC(7, 0),
PRIMARY KEY (id)
);
contents of /tmp/bulk.csv:
1001||1231231234|1001
1002|1234|1231231235|1002
COPY 2 RECORDS INTO bulk2 from '/tmp/bulk.csv' USING DELIMITERS '|', '\n';
COPY 2 RECORDS INTO bulk2 from '/tmp/bulk.csv' USING DELIMITERS '|', '\n';
!SQLException:sql:decimal wrong format (|1231231234|1001)
!SQLException:sql:value |1231231234|1001 from line 0 not inserted
!SQLException:importTable:failed to import table
Timer 1.362 msec 0 rows
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-12-01 09:10
Message:
Logged In: YES
user_id=43556
Originator: NO
Test added too src/test/bugs/Tests/decimal_copy_into_bug.sql
Now also empty values are (again) treated as NULL values.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1842019&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
