missing bulk operations between constant and bat

[monetdb-team]

Date: 2016-08-23 14:44:40 +0200
From: @swingbit
To: SQL devs <>
Version: 11.23.7 (Jun2016-SP1)
CC: @njnes

Last updated: 2016-12-21 13:08:32 +0100

Comment 22319

Date: 2016-08-23 14:44:40 +0200
From: @swingbit

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

create table t(i int);
explain select sql_max(2,i) from t;

The MAL plan produced uses a loop on t.

Reproducible: Always

Comment 22321

Date: 2016-08-25 13:24:31 +0200
From: @njnes

there is a problem with the sql type checking and calc.max is a pattern, ie
cannot be automatically used in a manifold operator. This indeed means additional
batcalc.max/min etc needs to be added.

Comment 22398

Date: 2016-09-30 10:40:42 +0200
From: MonetDB Mercurial Repository <>

Changeset 5e84ba611fc7 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=5e84ba611fc7

Changeset description:

Implemented batcalc.min and batcalc.max for when one argument is scalar.
This fixes bug #4057.

Comment 22399

Date: 2016-09-30 10:41:26 +0200
From: @sjoerdmullender

The fix should appear in the next feature release.