Bugs item #2704016, was opened at 2009-03-22 20:35
Message generated for change (Comment added) made by sjoerd
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: Closed
>Resolution: Fixed
Priority: 6
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.
----------------------------------------------------------------------
>Comment By: Sjoerd Mullender (sjoerd)
Date: 2009-04-01 17:35
Message:
This was fixed.
I added a test sql/src/test/BugTracker-2009/Tests/nullstr.SF-2704016.sql.
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-03-22 22:38
Message:
Other (worse) example now works too:
CREATE TABLE "sys"."node_tags" (
"node" int,
"k" varchar(255),
"v" varchar(1024)
);
/tmp/nulltest:
1, 'test', 'Nullen RA'
COPY 1 RECORDS INTO node_tags from '/tmp/nulltest' USING DELIMITERS ',',
'\n', '''';
sql>select * from node_tags;
+------+------+---+
| node | k | v |
+======+======+===+
| 1 | test | n |
: : : u :
: : : l :
: : : l :
+------+------+---+
1 tuple
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2704016&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
