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

MySQL BUG#11748187 - 35410: STORED FUNCTION: CONFUSING 'ORDER CLAUSE' IN ERROR MESSAGE

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None

          Description

          revno: 3402.31.20
committer: Raghav Kapoor <raghav.kapoor@oracle.com>
branch nick: mysql-trunk-bug-11748187
timestamp: Fri 2011-12-09 12:25:51 +0530
message:
  BUG#11748187 - 35410: STORED FUNCTION: CONFUSING 'ORDER CLAUSE' IN ERROR MESSAGE

  BACKGROUND:
  A stored function is created that refers in the body to an
  identifier that cannot be resolved. The error message produced
  by invoking the function says something about 'order clause'.
  The function has no ORDER BY clause, nor is it invoked within
  a statement that has an ORDER BY clause.
  The error message is confusing.

  FIX:
  This bug has been fixed by explicitly resetting THD::where
  value to its default in sp_head::execute_function in sp_head.cc
  file. Also a test case has been written in sp.test and the
  corresponding result file has also been updated.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: