[MDEV-5187] Many built-in system functions are classified as UNKNOWN_FUNC Created: 2013-10-25 Updated: 2015-04-04 Resolved: 2015-04-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Parser |
| Affects Version/s: | 5.5.34 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Vilho Raatikka | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | upstream | ||
| 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. |
| Comments |
| Comment by Elena Stepanova [ 2014-10-19 ] |
|
It's the same in all MySQL versions, 5.7 included, right? |
| Comment by Vilho Raatikka [ 2014-10-23 ] |
|
elenst Yes. No, I should probably do that if I only knew how to do it and where. |
| Comment by Elena Stepanova [ 2014-10-23 ] |
|
vilho, Usual way – bugs.mysql.com => Report a bug. |
| Comment by Sergei Golubchik [ 2015-04-04 ] |
|
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. |