Sqlitelogictest unknown bat append operation

[monetdb-team]

Date: 2018-01-18 11:53:09 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-02-12 16:12:05 +0100

Comment 26096

Date: 2018-01-18 11:53:09 +0100
From: @PedroTadim

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

There are still missing bat.append operations between different atoms. In this case appending a 70 bte to an integer BAT from an IN operation is failing.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab1 VALUES(51,14,96);
3. INSERT INTO tab1 VALUES(85,5,59);
4. INSERT INTO tab1 VALUES(91,47,68);
5. SELECT DISTINCT * FROM tab1 AS cor0 WHERE ( col0 ) NOT IN ( + col0, 70 );

Actual Results:

A MAL error:
'bat.append' undefined in: bat.append(X_42:bat[:int], X_40:bte, true:bit);

Expected Results:

An empty result set

Comment 26098

Date: 2018-01-18 12:37:32 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added tests for bugs 6516 and 6517

Comment 26100

Date: 2018-01-18 21:37:53 +0100
From: MonetDB Mercurial Repository <>

Changeset 9ddf37267b1c 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=9ddf37267b1c

Changeset description:

fixes for bugs 6516 and 6517, improved type checking in the 'IN/NOT IN' cases

Comment 26103

Date: 2018-01-18 21:38:30 +0100
From: @njnes

fixed type checking