Sqlitelogic test infinite loop while compiling SQL query

[monetdb-team]

Date: 2018-04-14 21:43:37 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @kutsurak, @njnes

Last updated: 2019-05-06 11:22:26 +0200

Comment 26368

Date: 2018-04-14 21:43:37 +0200
From: @PedroTadim

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

On default branch, run the query bellow for an infinite loop in exp_bin function call.

Reproducible: Always

Steps to Reproduce:

1. SELECT ALL - 70 + + - 89 - + ( SUM ( + CASE - NULLIF ( + 87, CASE CAST ( NULL AS INTEGER ) WHEN 13 / + ( 68 * - ( 64 ) )
   THEN + 39 WHEN 70 * - 95 THEN 60 ELSE 15 + + 25 END * 5 ) WHEN + 36 THEN NULL WHEN 24 THEN NULL ELSE 66 END ) ) AS col2;

Actual Results:

Infinite loop in exp_bin call in rel_bin.c, leaving infinite time to compile the query.

Expected Results:

-225

Backtrace:

0 findVariable (mb=0x7f72680518f0, name=0x7f727e59ea00 "AL14034") at mal_instruction.c:593
1 0x00007f72af1076e8 in pushArgumentId (mb=0x7f72680518f0, p=0x7f723b8463e0, name=0x7f727e59ea00 "AL14034") at mal_instruction.c:1352
2 0x00007f729b8636f1 in stmt_var (be=0x7f7268002b60, varname=0x7f727e59ed49 "L14034", t=0x7f7268044c80, declare=1, level=2) at sql_statement.c:327
3 0x00007f729b84297f in exp_bin (be=0x7f7268002b60, e=0x7f7268032a00, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:521
4 0x00007f729b8423e4 in exp_bin (be=0x7f7268002b60, e=0x7f7268032a90, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:450
5 0x00007f729b842612 in exp_bin (be=0x7f7268002b60, e=0x7f7268032c10, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:480
6 0x00007f729b842612 in exp_bin (be=0x7f7268002b60, e=0x7f7268032ca0, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:480
7 0x00007f729b842612 in exp_bin (be=0x7f7268002b60, e=0x7f7268033200, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:480
8 0x00007f729b842612 in exp_bin (be=0x7f7268002b60, e=0x7f72680334e0, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:480
9 0x00007f729b842612 in exp_bin (be=0x7f7268002b60, e=0x7f7268033aa0, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:480
10 0x00007f729b8423e4 in exp_bin (be=0x7f7268002b60, e=0x7f7268033b30, left=0x0, right=0x0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:450
.....

Comment 26370

Date: 2018-04-14 22:14:30 +0200
From: MonetDB Mercurial Repository <>

Changeset ff8bda80d298 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=ff8bda80d298

Changeset description:

Added test for Bug #6579

Comment 26386

Date: 2018-04-20 10:07:46 +0200
From: MonetDB Mercurial Repository <>

Changeset 629384f37bb0 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=629384f37bb0

Changeset description:

fixes for bug #6579, ie split aggr/function into a lower
project earlier.

Comment 26998

Date: 2019-05-06 11:22:26 +0200
From: MonetDB Mercurial Repository <>

Changeset 49fdc1899528 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=49fdc1899528

Changeset description:

Adding more sqlite tests failing queries:

Bug #6605 outputs only 3 columns out of 6 on default.
Bug #6566 crashes on both Apr2019 and default.
Bug #6579 crashes on default.