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

Reply via email to