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

SQL inside an anonymous block is executed with wrong SQL_MODE

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: N/A
        • Fix Version/s: 10.1.1
        • Component/s: None
        • Labels:
          None

          Description

          Note: It might be related to MDEV-6606 or even have the same root cause.

          create table t1 (a int);
# Query OK, 0 rows affected (0.98 sec)

set sql_mode='';
# Query OK, 0 rows affected (0.00 sec)

select a from t1 having a > 1;
# Empty set (0.01 sec)

delimiter |
begin not atomic select a from t1 having a > 1; end |
# ERROR 1463 (42000): Non-grouping field 'a' is used in HAVING clause

          bb-MDEV-5317
commit 6502f42f679e605fcdbd6c8b49d2813f553001b0
Author: Sergei Golubchik <serg@mariadb.org>
Date:   Mon Aug 18 14:28:48 2014 +0200

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-5317 Compound statement / anonymous blocks

                • Major - Major loss of function.
                • Closed

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 10 minutes
                        10m