Skip to content
← Customer Feedback for Devart

Settings and activity

2 results found

  1. view with a UDF calling an aggregate function adds quotes around the aggregate

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  dbForge Studio for MySQL » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please provide us the following information:
    1. Version of the MySQL server.
    2. CREATE definition of the UDF.
    3. The assembly file containing the functions called by the UDF.

    An error occurred while saving the comment
    Graham Charles commented  · 

    Yes, it seems to be a old version bug -- error present in 5.01, not in 5.5. So it'll be MySql's fault, not Devart's...

    If you're still interested in seeing it happen, here's the function.

    (Oh, and sorry, not a UDF, a stored function. Got my MSSQL/MySql terms mixed up.)

    CREATE FUNCTION dateAsString(vDate datetime)
    RETURNS char(10) CHARSET latin1
    BEGIN

    DECLARE ret char(10);

    SET ret = CAST(
    DATE_FORMAT(vDate, "%Y-%m-%d") AS char(10));

    RETURN ret;

    END

    Graham Charles shared this idea  · 

  2. We need possibility to draw more

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  dbForge Studio for MySQL » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Graham Charles supported this idea  ·