Bugs item #2468513, was opened at 2008-12-26 12:25
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=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

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

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