Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv20577/Tests

Modified Files:
        All 
Added Files:
        varchar.SF-2471371.sql 
Log Message:
Varchar semantics are not obeyed in a COPY statement


U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- All 27 Dec 2008 15:46:15 -0000      1.12
+++ All 27 Dec 2008 17:16:28 -0000      1.13
@@ -13,6 +13,7 @@
 string_length_not_checked.SF-2075078
 update_set_negative.SF-2075197
 varchar_char_semantics.SF-2075085
+varchar.SF-2471371
 view_reply_incorrect.SF-2075097
 year_overflow_bug.SF-2075133
 select_not_wrong_result.SF-2080151

--- NEW FILE: varchar.SF-2471371.sql ---
CREATE TABLE myvar_test (
  col1  VARCHAR(1),
  col2  VARCHAR(2)
) ;

COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n' NULL as '';
|a|1b

COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n' NULL as '';
|a|b2b

COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n' NULL as '';
|aa|bb

COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n' NULL as '';
|a|b

select * from myvar_test;

DROP   TABLE myvar_test ;


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

Reply via email to