You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create table t6815 (type_digits int);
select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
Reproducible: Always
Steps to Reproduce:
start mserver5
start mclient
run sql commands:
create table t6815 (type_digits int);
select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
Actual Results:
builtin opt gdk_dbpath = /home/dinther/dev/dev/INSTALL/var/monetdb5/dbfarm/demo
builtin opt mapi_port = 50000
builtin opt mapi_open = false
builtin opt mapi_ipv6 = false
builtin opt mapi_autosense = false
builtin opt sql_optimizer = default_pipe
builtin opt sql_debug = 0
cmdline opt embedded_r = true
cmdline opt embedded_py = 3
cmdline opt embedded_c = true
cmdline opt mapi_port = 41000
MonetDB 5 server v11.35.10 (hg id: 5560e86e5fdf)
This is an unreleased version
Serving database 'demo', using 8 threads
Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
Found 31.243 GiB available main-memory of which we use 25.463 GiB
Copyright (c) 1993 - July 2008 CWI.
Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:41000/
MonetDB/GIS module loaded
MonetDB/SQL module loaded
MonetDB/Python3 module loaded
MonetDB/R module loaded
./start_INSTALL_mserver5.sh: line 8: 15990 Segmentation fault (core dumped) /home/dinther/dev/dev/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set embedded_py=3 --set embedded_c=true --set mapi_port=41000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.35.10 (hg id: 5560e86e5fdf), 'demo'
FOLLOW US on https://twitter.com/MonetDB or https://github.com/MonetDB/MonetDB
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create table t6815 (type_digits int);
operation successful
sql>select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
sql>
write error on stream
[home ~]$
Fix for bug #6815, ie call exp_subtype to get the type of an expression instead of differentiating the 'tpe' field, because for e_func and e_aggr, it's not stored in there
The text was updated successfully, but these errors were encountered:
Date: 2020-01-30 13:59:04 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.35.9 (Nov2019-SP1)
CC: @PedroTadim
Last updated: 2020-02-21 12:36:58 +0100
Comment 27533
Date: 2020-01-30 13:59:04 +0100
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:70.0) Gecko/20100101 Firefox/70.0
Build Identifier:
following 2 sql commands let mserver5 crash.
create table t6815 (type_digits int);
select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
Reproducible: Always
Steps to Reproduce:
create table t6815 (type_digits int);
select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
Actual Results:
builtin opt gdk_dbpath = /home/dinther/dev/dev/INSTALL/var/monetdb5/dbfarm/demo
builtin opt mapi_port = 50000
builtin opt mapi_open = false
builtin opt mapi_ipv6 = false
builtin opt mapi_autosense = false
builtin opt sql_optimizer = default_pipe
builtin opt sql_debug = 0
cmdline opt embedded_r = true
cmdline opt embedded_py = 3
cmdline opt embedded_c = true
cmdline opt mapi_port = 41000
MonetDB 5 server v11.35.10 (hg id: 5560e86e5fdf)
This is an unreleased version
Serving database 'demo', using 8 threads
Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
Found 31.243 GiB available main-memory of which we use 25.463 GiB
Copyright (c) 1993 - July 2008 CWI.
Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:41000/
MonetDB/GIS module loaded
MonetDB/SQL module loaded
MonetDB/Python3 module loaded
MonetDB/R module loaded
./start_INSTALL_mserver5.sh: line 8: 15990 Segmentation fault (core dumped) /home/dinther/dev/dev/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set embedded_py=3 --set embedded_c=true --set mapi_port=41000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.35.10 (hg id: 5560e86e5fdf), 'demo'
FOLLOW US on https://twitter.com/MonetDB or https://github.com/MonetDB/MonetDB
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create table t6815 (type_digits int);
operation successful
sql>select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815;
sql>
write error on stream
[home ~]$
Expected Results:
no crash of mserver5 please
Comment 27534
Date: 2020-01-30 15:20:59 +0100
From: MonetDB Mercurial Repository <>
Changeset 45734606a35c made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=45734606a35c
Changeset description:
Comment 27535
Date: 2020-01-30 16:00:34 +0100
From: MonetDB Mercurial Repository <>
Changeset a8ed813d5c81 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=a8ed813d5c81
Changeset description:
The text was updated successfully, but these errors were encountered: