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

Many built-in system functions are classified as UNKNOWN_FUNC

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Not a Bug
        • Affects Version/s: 5.5.34
        • Fix Version/s: N/A
        • Component/s: Parser
        • Labels:
        • Environment:
          any

          Description

          Item_func::Functype is not set for some functions and thus the function type for those is UNKNOWN_FUNC, for example, for soundex(), rand(), and repeat().

          (On the other hand, functions that are not known are classified as FUNC_SP.)

          Setting proper type would help in examining the type of function.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment - - edited

                Vilho Raatikka,

                It's the same in all MySQL versions, 5.7 included, right?
                Did you try to report it upstream?

                Show
                elenst Elena Stepanova added a comment - - edited Vilho Raatikka , It's the same in all MySQL versions, 5.7 included, right? Did you try to report it upstream?
                Hide
                Permalink
                vilho Vilho Raatikka added a comment -

                Elena Stepanova Yes. No, I should probably do that if I only knew how to do it and where.

                Show
                vilho Vilho Raatikka added a comment - Elena Stepanova Yes. No, I should probably do that if I only knew how to do it and where.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Vilho Raatikka, Usual way – bugs.mysql.com => Report a bug.

                Show
                elenst Elena Stepanova added a comment - Vilho Raatikka , Usual way – bugs.mysql.com => Report a bug.
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                As far as I understand, Functype is set to a distinct value when it's used somewhere in the code to know the type of this particular Item_func (usually for optimization or query transformation purposes). There is no guarantee that every Item_func will have a distinct Functype return value. See if you can use item name instead.

                Show
                serg Sergei Golubchik added a comment - As far as I understand, Functype is set to a distinct value when it's used somewhere in the code to know the type of this particular Item_func (usually for optimization or query transformation purposes). There is no guarantee that every Item_func will have a distinct Functype return value. See if you can use item name instead.

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    vilho Vilho Raatikka
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: