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 136855 - Nested blocks in stored procedures do not work correctly
Summary: Nested blocks in stored procedures do not work correctly
Status: RESOLVED WONTFIX
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-09 19:19 UTC by Roman Mostyka
Modified: 2008-06-09 20:37 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 Roman Mostyka 2008-06-09 19:19:29 UTC 
1. Connect to DB.
2. Open Query Editor.
3. Write SQL statement:
"delimiter \\
CREATE PROCEDURE p11 ()
BEGIN
  DECLARE x1 CHAR(5) DEFAULT 'outer';
  BEGIN
    DECLARE x1 CHAR(5) DEFAULT 'inner';
    SELECT x1;
  END;
  SELECT x1;
END; \\"
4. Execute statement.

Result: Only 'inner' is displayed. Is it our bug or my mistake? I got this example from MySQL 5 stored procedure
tutorial and there is written that 'inner' and then 'outer' should be displayed. It seems to me the same.
Comment 1 David Vancouvering 2008-06-09 20:37:29 UTC 
I think the problem with this particular stored procedure is that our SQL editor only displays one set of results,
that's a known limitation.  We can correctly execute the creation of a stored procedure but if a stored procedure
returns multiple results, we can not correctly display multiple results.  It's on our feature list, but is a low
priority compared to other things we need to accomplish.