Skip to content

Unexpected result when using IFNULL with large numbers #7468

Description

@suyZhong

Describe the bug
Consider the test cases below. It is unexpected that the third query returns an empty result, since the second query returns true, which means that the WHERE clause in the third query should be evaluated to true and thus return the row in the table.

To Reproduce

DROP TABLE IF EXISTS t0 CASCADE;

CREATE TABLE t0(c1 INTEGER);
INSERT INTO t0 (c1) VALUES (0);

SELECT * FROM t0; -- 0
SELECT (IFNULL(-1460368584, -32678)-(-380279465))<= t0.c1 FROM t0; -- true
SELECT * FROM t0 WHERE (IFNULL(-1460368584, -32678)-(-380279465))<= t0.c1;
-- Expected: 0
-- Actual: empty result

Expected behavior
As mentioned above

Screenshots
N/A

Software versions
Build from source:

> docker exec monetdb-test mserver5 --version --dbname=monetdb
MonetDB 5 server 11.50.0 (hg id: 9dc1e5d) (64-bit, 128-bit integers)
This is an unreleased version
Copyright (c) 1993 - July 2008 CWI
Copyright (c) August 2008 - 2023 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Found 503.5GiB available memory, 128 available cpu cores
Libraries:
Compiled by: @5245a54fef58 (x86_64-pc-linux-gnu)
Compilation: /usr/bin/cc 
Linking    : /usr/bin/ld

Issue labeling
Bug

Additional context
Add any other context about the problem here.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions