Menu

MAX() is not treated like a function

2013-12-11
2013-12-14
  • Philipp Blaszczyk

    Didn't find the option to create a ticket.

    When using the following MySQL Code in the "syntax editor"

    SELECT MAX(node.nid) AS test, ...
    

    and then switching to "designer mode", SQLeo rewrites the code to

    SELECT MAX ( node.nid ) AS test, ...
    

    which is not valid anymore and produces a syntax error when running the query because of the added whitespace after the function name.

     
  • PAscal

    PAscal - 2013-12-11

    Hi,
    you are facing an other aspect of ticket 155 https://sourceforge.net/p/sqleo/tickets/155/

    ticket has been updated, but don't know yet when it will be fixed.
    Regards
    PAscal

     
  • PAscal

    PAscal - 2013-12-14

    This fix will be included in next release 2013.12
    Regards
    PAscal

     

Anonymous
Anonymous

Add attachments
Cancel