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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • 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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: