MYSQL Functions : DbVis Software

a

anonymous

started a topic over 11 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Hi,
First congrats to all on a great new release!  Love this product!

Question:

Why do i need to add comment clauses to compile my function definitions.

see http://stackoverflow.com/questions/6628390/mysql-trouble-with-creating-user-defined-function-udf

MYSQL Workbench also had this problem.

I posted this question on experts-exchange.

here is the function

SET GLOBAL log_bin_trust_function_creators = 1;

--/      0 then  set iVal = p_iVal - 1;
        end if; 
    
        INSERT INTO
            test.sequence
            (
                name,
                val,
                inc_val,
                first_val,
                max_val
            )
            VALUES
            (
                p_name,
                iVal,
                p_incVal,
                p_iVal,
                p_maxVal
                
            );
        
        return 0;
    END
/  

Hans Bergsten

said over 11 years ago

[This reply is migrated from our old forums.]

Re: MYSQL Functions

Hi Jim,

Thanks, glad to hear you're happy with 9.0!

For the answer your question, please see the answer to this very similar question:

http://www.dbvis.com/forum/thread.jspa?threadID=4254

Best Regards,
Hans

a

anonymous

said over 11 years ago

[This reply is migrated from our old forums. The original author name has been removed]

Re: MYSQL Functions

Hi Hans,

No that is not what I was looking for.  When I create a function I have to add

--/

whats up with that?

Roger Bjärevall

said over 11 years ago

[This reply is migrated from our old forums.]

Re: MYSQL Functions

Jim,

The reason is that DbVisualizer use semicolon ";" as a statement separator. For TRIGGERS, PROCEDURES and other objects, semicolon may be embedded in the block of code and due to this it will fail since DbVisualizer will split at each semicolon and run them separately.

To workaround this the solutions in the post Hans referred too should be used.

I hope this make sense.

Regards

Roger

Hans Bergsten

said over 11 years ago

[This reply is migrated from our old forums.]

Re: MYSQL Functions

Jim,

--/ is the SQL Block begin delimiter, which is one of the alternatives to handle statements of this kind described in the post I referenced.

Best Regards,
Hans

How can we help you today?

MYSQL Functions

anonymous

Hans Bergsten

anonymous

Roger Bjärevall

Hans Bergsten