#273 (in 2.6.5) do not add a blank before (

closed-accepted
Parsing (8)
1
2005-12-04
2005-09-19
No

do not add ' ' before (

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."

fixes bugs:

[ 1283273 ] support of area() function
https://sourceforge.net/tracker/index.php?func=detail&aid=1283273&group_id=23067&atid=377408
[ 1255600 ] weird MySQL syntax error
http://sourceforge.net/tracker/index.php?func=detail&aid=1255600&group_id=23067&atid=377408
[ 1240939 ] UPPER()
https://sourceforge.net/tracker/index.php?func=detail&aid=1240939&group_id=23067&atid=377408

Discussion

  • Sebastian Mendel

    Logged In: YES
    user_id=326580

    ah, sorry

    as i dont had the time to fully understand the parser i
    think it would be better to just update the
    sqlparser.data.php ... here it is

    btw. could someone please add comments to the arrays in
    sqlparser.data.php describing the use of this arrays? so it
    would be more easy to update this in the future

     
  • Marc Delisle

    Marc Delisle - 2005-09-20
    • priority: 5 --> 1
    • assigned_to: nobody --> lem9
    • summary: do not add a blank before ( --> (in 2.6.5) do not add a blank before (
    • status: open --> open-accepted
     
  • Marc Delisle

    Marc Delisle - 2005-09-20

    Logged In: YES
    user_id=210714

    Merged patch to sqlparser.data.php, thanks.

     
  • Marc Delisle

    Marc Delisle - 2005-12-04
    • status: open-accepted --> closed-accepted
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks