#1730 (in 2.7.0) UPPER()

fixed
Marc Delisle
1
2013-06-11
2005-07-19
Marc Delisle
No

SELECT uid
FROM user_list
WHERE UPPER(login) = UPPER('CSMITH')

gives a syntax error.

Discussion

  • Logged In: YES
    user_id=326580

    the SQLParser add spaces which produces this error

    UPPER('word') becomes UPPER ( 'word' )

    the space between UPPER and ( is prohibited

    http://dev.mysql.com/doc/mysql/en/functions.html

    from the MySQL manual:

    "Note: By default, there must be no whitespace between a
    function name and the parenthesis following it. This helps
    the MySQL parser distinguish between function calls and
    references to tables or columns that happen to have the same
    name as a function. Spaces around function arguments are
    permitted, though."

     
  • Marc Delisle
    Marc Delisle
    2005-09-20

    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2005-09-20

    Logged In: YES
    user_id=210714

    patch merged

     
  • Marc Delisle
    Marc Delisle
    2005-09-20

    • assigned_to: nobody --> lem9
    • summary: UPPER() --> (in 2.6.5) UPPER()
     
  • Marc Delisle
    Marc Delisle
    2005-10-02

    • summary: (in 2.6.5) UPPER() --> (in 2.7.0) UPPER()
     
  • Marc Delisle
    Marc Delisle
    2005-12-04

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed