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

Erroneous SET STATEMENT produces two identical errors

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Fixed
        • Affects Version/s: N/A
        • Fix Version/s: 10.1.4
        • Component/s: Admin statements
        • Labels:
          None

          Description

          MariaDB [test]> set statement non_existing=1 for select 1;
ERROR 1193 (HY000): Unknown system variable 'non_existing'
MariaDB [test]> show errors;
+-------+------+----------------------------------------+
| Level | Code | Message                                |
+-------+------+----------------------------------------+
| Error | 1193 | Unknown system variable 'non_existing' |
| Error | 1193 | Unknown system variable 'non_existing' |
+-------+------+----------------------------------------+
2 rows in set (0.00 sec)

MariaDB [test]> select @@error_count;
+---------------+
| @@error_count |
+---------------+
|             2 |
+---------------+
1 row in set (0.00 sec)

          It looks redundant. 

          commit e64f5d8f758bcc1a8856ba9fba01780533f80747
Author: Oleksandr Byelkin <sanja@mariadb.com>
Date:   Sun Oct 26 16:27:54 2014 +0100

    Fixed test suite global variable saving

          All the same in Percona server.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-5231 Per query variables from Percona Server [patch]

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                Technical task - A technical task. MDEV-6923 Testing for SET STATEMENT .. FOR (MDEV-5231, per-query variables)

                • Major - Major loss of function.
                • Closed
                links to

                Web Link Bug#1386210 - Erroneous SET STATEMENT produces two identical errors

                  Activity

                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  revision-id: be73c7ee4415af4c1188689e1642a39512c2ecbd
                  parent(s): 9f4ee16bf351ea2969d73abcdea92e70538c723c
                  committer: Oleksandr Byelkin
                  branch nick: server
                  timestamp: 2015-03-11 14:57:30 +0100
                  message:

                  MDEV-6951: Erroneous SET STATEMENT produces two identical errors

                  Double error reporting removed.

                  Show
                  sanja Oleksandr Byelkin added a comment - revision-id: be73c7ee4415af4c1188689e1642a39512c2ecbd parent(s): 9f4ee16bf351ea2969d73abcdea92e70538c723c committer: Oleksandr Byelkin branch nick: server timestamp: 2015-03-11 14:57:30 +0100 message: MDEV-6951 : Erroneous SET STATEMENT produces two identical errors Double error reporting removed.

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: