Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sqlitelogictest unavailable calc.- MAL operations #6566

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Sqlitelogictest unavailable calc.- MAL operations #6566

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2018-04-03 16:22:40 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2019-05-06 19:58:55 +0200

Comment 26333

Date: 2018-04-03 16:22:40 +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:

Despite activating FULL_IMPLEMENTATION macro in gdk_calc.c in changeset ff833040fa32 for bug #6513, the SQL compiler still generates unavailable MAL operations.

Reproducible: Always

Steps to Reproduce:

  1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
  2. INSERT INTO tab0 VALUES(97,1,99), (15,81,47), (87,21,10);
  3. SELECT - col0 - - - col0 * + CAST ( NULL AS INTEGER ) FROM tab0;
  4. SELECT ALL - col1 * - 16 * + CAST ( NULL AS INTEGER ) FROM tab0 cor0;

Actual Results:

In the first SELECT query, the following MAL exception is generated:
Semantic errors TypeException:user.sql.init[12]:'calc.-' undefined in: X_32176:hge := calc.-(X_32175:int);

In the second SELECT query:
Semantic errors TypeException:user.sql.init[14]:'calc.-' undefined in: X_32228:lng := calc.-(X_32227:int);

Expected Results:

For both SELECT queries a single column result set with 3 NULL values.

Comment 26335

Date: 2018-04-03 16:36:57 +0200
From: MonetDB Mercurial Repository <>

Changeset 549d90c8aba5 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=549d90c8aba5

Changeset description:

Added tests for bugs 6565 and 6566

Comment 27000

Date: 2019-05-06 11:22:28 +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.

Comment 27002

Date: 2019-05-06 19:58:55 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6566, ie make sure we keep atleast one expression in a groupby
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant