Bugs item #2468513, was opened at 2008-12-26 12:25
Message generated for change (Comment added) made by mlkersten
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2468513&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: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Martin Kersten (mlkersten)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: copy into does not detect syntax errors

Initial Comment:
The load_with_offset file contains erroneous input, which is not properly 
detected.

CREATE TABLE my_test (
  col1  INT,
  col2  INT,
  col3  INT,
  col4  VARCHAR(1),
  col5  VARCHAR(1)
 ) ;

COPY 5 OFFSET 5 RECORDS INTO my_test FROM stdin USING DELIMITERS '|','\n' NULL 
as '';
123|1.01||aaa|bbb
553|.02||aaa|bbb
223|2.03||aaa|bbb

----------------------------------------------------------------------

>Comment By: Martin Kersten (mlkersten)
Date: 2008-12-27 18:22

Message:
test file added:
BugTracker-2008/Tests/copy-format.SF-2468513.sql


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2468513&group_id=56967

------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to