Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34238

Results in “BIGINT Value Out of Range” Error When Executing SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 11.3.2, 10.11
    • N/A
    • Optimizer
    • None
    • Not for Release Notes

    Description

      MariaDB returns an error message: BIGINT value is out of range in '-9223372036854775808 * 1454377110' when performing a SELECT.
      However, I didn't directly have -9223372036854775808 * 1454377110 in my SELECT.

      Repeat steps:

      Create the table:

      CREATE TABLE t0 (c_0 INT, c_1 INT, c_2 INT);
      

      Execute the following query:

      SELECT t0.c_1 
      FROM t0 
      WHERE (t0.c_1 = t0.c_0 * t0.c_1 AND t0.c_0 = -9223372036854775808) 
      AND t0.c_1 = 1454377110;
      

      Expected Behavior
      The query should return an empty set

      Actual Behavior
      The query results in an error message: BIGINT value is out of range in '-9223372036854775808 * 1454377110'

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              dwenking chaos
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.