Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

copy into file wrongly exports functions #4054

monetdb-team opened this issue Nov 30, 2020 · 0 comments

copy into file wrongly exports functions #4054

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2016-08-22 13:44:30 +0200
From: @skinkie
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2016-10-13 10:04:45 +0200

Comment 22315

Date: 2016-08-22 13:44:30 +0200
From: @skinkie

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/51.0.2704.79 Chrome/51.0.2704.79 Safari/537.36
Build Identifier:

skinkie@chamechaude ~ $ /opt/monetdb-aug2016/bin/mclient -d htm
create table test (test text);
insert into test values ('123:456:789');
select split_part(test, ':', 2) from test;
| splitpart_test |
| 456 |
1 tuple (4.606ms)

Now with copy into:

copy (select split_part(test, ':', 2) from test) into '/tmp/export/htm/test.csv' DELIMITERS ',' NULL AS '';
1 affected row (3.772ms)

cat /tmp/export/htm/test.csv

The input for the function is duplicated in the output.

Reproducible: Always

MonetDB 5 server v11.24.0 (64-bit, 128-bit integers)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
Visit for further information
Found 62.8GiB available memory, 8 available cpu cores
libpcre: 8.38 2015-11-23 (compiled with 8.38)
openssl: OpenSSL 1.0.2h 3 May 2016 (compiled with OpenSSL 1.0.2h 3 May 2016)
libxml2: 2.9.4 (compiled with 2.9.4)
Compiled by: skinkie@chamechaude (x86_64-pc-linux-gnu)
Compilation: gcc -O3 -pipe -march=broadwell -mabm -mavx256-split-unaligned-load -mavx256-split-unaligned-store -mclflushopt -mrtm -mxsavec -mxsaves -pipe -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/x86_64-pc-linux-gnu/bin/ld -m elf_x86_64

Comment 22322

Date: 2016-08-25 14:04:42 +0200
From: @njnes

Is this already fixed? I could not repeat the problem on the Jun2016 branch

Comment 22323

Date: 2016-08-25 15:02:27 +0200
From: @skinkie

I reported it on the default branch, I'll test later today.

Comment 22324

Date: 2016-08-25 15:17:54 +0200
From: @skinkie

This still happens in default.

Comment 22330

Date: 2016-08-29 14:56:41 +0200
From: @sjoerdmullender

Regression in default branch.

Comment 22354

Date: 2016-09-04 20:09:23 +0200
From: @njnes

this is caused by the split_project optimizer. Now we handle this exception.

Comment 24501

Date: 2016-10-13 10:04:45 +0200
From: @sjoerdmullender

Jun2016-SP2 has been released.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant