Bugs item #1842019, was opened at 2007-11-30 16:08
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
Resolution: None
Priority: 5
Private: No
Submitted By: mharrison (matt_harrison)
Assigned to: Nobody/Anonymous (nobody)
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
----------------------------------------------------------------------
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
