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
"123:456:789","456"

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 http://www.monetdb.org/ for further information
Found 62.8GiB available memory, 8 available cpu cores
Libraries:
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.