Bugs item #2704016, was opened at 2009-03-22 20:35
Message generated for change (Tracker Item Submitted) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2704016&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: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: 'null' from copy into gets wrong
Initial Comment:
There are two issues here; one is easy to reproduce the other one I cannot yet
reproduce in a smaller setting.
Create a file /tmp/nullcheck containing:
'null'
create table testnull (test varchar(10));
copy 1 records into testnull from '/tmp/nullcheck' USING DELIMITERS '\n', '''';
select * from testnull will give now an empty value.
While: insert into testnull values('null'); will result into the string 'null'
inside the table.
The actual observation was that anything starting with 'nu...' would become a
null variable; but outside the OSM insert script I cannot reproduce this
behavior. The expected behavior would be that 'null' would be just the string.
While the quoteless variant would get into NULL.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2704016&group_id=56967
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs