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

ERROR_FOR_DIVISION_BY_ZERO not throwing error

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.19
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      Windows 8.1

      Description

      ERROR_FOR_DIVISION_BY_ZERO doesn't appear to be honored.

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 1043
      Server version: 10.0.19-MariaDB mariadb.org binary distribution
       
      Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> SHOW VARIABLES LIKE 'sql_mode';
      +---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Variable_name | Value                          |
      +---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
      +---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> SELECT 1/0;
      +------+
      | 1/0  |
      +------+
      | NULL |
      +------+
      1 row in set, 1 warning (0.00 sec)
       
      MariaDB [(none)]> show warnings;
      +---------+------+---------------+
      | Level   | Code | Message       |
      +---------+------+---------------+
      | Warning | 1365 | Division by 0 |
      +---------+------+---------------+
      1 row in set (0.00 sec)

      There is a warning, but according to https://mariadb.com/kb/en/mariadb/sql_mode/ it should "Return a 1365 'Division by 0' error (instead of a warning)"

        Attachments

          Activity

            People

            • Assignee:
              greenman Ian Gilfillan
              Reporter:
              Sparticuz Kyle McNally
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: