Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv27968/src/test/BugTracker-2009/Tests
Added Files:
COPY_INTO_char_NULL.SF-2560780.sql.in
Log Message:
propagated changes of Tuesday Feb 03 2009 - Wednesday Feb 04 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/03 - stmane:
src/test/BugTracker-2009/Tests/COPY_INTO_char_NULL.SF-2560780.sql.in,1.1.2.1
added test for
[ 2560780 ] COPY INTO imports single characters as NULL
https://sourceforge.net/tracker/index.php?func=detail&aid=2560780&group_id=56967&atid=482468
appears to work fine with the Feb2009 release branch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: COPY_INTO_char_NULL.SF-2560780.sql.in ---
CREATE TABLE a (
b VARCHAR(50),
c VARCHAR(50)
);
COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$TSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',';
SELECT * FROM a;
COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$TSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',' NULL AS '';
SELECT * FROM a;
DROP TABLE a;
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
