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

    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

        Activity

          People

            psergei Sergei Petrunia
            dwenking Wenqian Deng
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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