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

LP:1028296 - Changing Server SQL Mode not apply to stored procedures

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Changing Server SQL Mode not apply to stored procedures

      SET sql_mode='NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE';

      Query: insert into bonus_results (calc_date, id_prod_type, id_user) value ('2012-08-00', 1, 2)

      Error Code: 1292
      Incorrect date value: '2012-08-00' for column 'calc_date' at row 1

      It's right, but same SQL in stored procedures continue work

      Workaround only recreate all stored procedures

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            ntman NT Man (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: