This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 234483 - Mysql Function edit missing return
Summary: Mysql Function edit missing return
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 7.3.1
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-16 09:41 UTC by szigya
Modified: 2013-08-22 11:27 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description szigya 2013-08-16 09:41:37 UTC 
When I edit a function listed under Services/Connection/Database/Procedures, the editor skips RETURN statement, so can't edit the stored function.

E.g.:

DELIMITER @@
DROP FUNCTION getUserHistoryName @@
CREATE FUNCTION buk_misi.getUserHistoryName
(`id` INT(11),`datum` DATE, current_name VARCHAR(50))

BEGIN
 --- 
END @@ 
DELIMITER ; 

is displayed instead of
DELIMITER @@
DROP FUNCTION getUserHistoryName @@
CREATE FUNCTION buk_misi.getUserHistoryName
(`id` INT(11),`datum` DATE, current_name VARCHAR(50))
RETURNS VARCHAR(100)
BEGIN
 --- 
END @@ 
DELIMITER ; 


It would be also nice, if the DROP FUNCTION were DROP FUNCTION IF EXISTS. Thanks,
Mike
Comment 1 Libor Fischmeistr 2013-08-19 12:32:35 UTC 
Fix: http://hg.netbeans.org/core-main/rev/4587f5174d93

This should solve your problems. Please verify.

Thanks
Comment 2 Quality Engineering 2013-08-22 04:28:16 UTC 
Integrated into 'main-silver', will be available in build *201308212300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/4587f5174d93
User: Libor Fischmeistr <lfischmeistr@netbeans.org>
Log: #234483: Mysql Function edit missing return
Comment 3 szigya 2013-08-22 11:06:52 UTC 
Thank you, compiling was too big bite for my home pc. I'm gonna test it as soon as I can.
Comment 4 Libor Fischmeistr 2013-08-22 11:16:42 UTC 
(In reply to szigya from comment #3)
> Thank you, compiling was too big bite for my home pc. I'm gonna test it as
> soon as I can.

It's available in daily build, so you don't need to compile it on your PC: http://bits.netbeans.org/download/trunk/nightly/latest/
Comment 5 szigya 2013-08-22 11:18:48 UTC 
I tested it, works well. Thank you!
Mike
Comment 6 szigya 2013-08-22 11:27:26 UTC 
More specificly, I tried it last weekend :). Next time I will be wiser :). Thanks again.