Bug #48283 stored proc lines does not get executed
Submitted: 25 Oct 2009 5:45 Modified: 25 Oct 2009 15:29
Reporter: Miran Cvenkel Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:5.1.31-comunity OS:Linux (centOS)
Assigned to: CPU Architecture:Any
Tags: stored proc mysql query browser

[25 Oct 2009 5:45] Miran Cvenkel
Description:
Not sure if this is mysql query browser or server thing.  
The same thing on ver 5.1.39, reverted to 5.1.31 to see if that would make a difference. On win xp this is no problem (5.1.31).

The folloving proc executes ewerything except insert part, insert keyword  isn't colored blue as it should be in mysql query browser 

-------------------------------------------------------------------------------
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`test`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`()
BEGIN
 

drop table if exists Tree;
CREATE TABLE Tree (CHILD_ID VARCHAR(30),PARENT_ID VARCHAR(30));

insert into tree (CHILD_ID,PARENT_ID)values ('8','8');

END$$

DELIMITER ;
-------------------------------------------------------------------------------

I extracted this from larger proc that did not yield expected results.

Allso noticed that on winXP you can run: "CALL test();" from query tab, on linux you can't, gives you "query canceled", same version of mysql query browser.Works from script tab doh.

How to repeat:
Call test();

cent os + 1.2.12  mysql query browser + upper procedure.
[25 Oct 2009 5:52] Miran Cvenkel
allso noticed that create, table,... gets blue the second you type it, but not insert and update.
[25 Oct 2009 5:59] Miran Cvenkel
inser and update turns bold when typed, don't know what that means.
[25 Oct 2009 8:24] Valeriy Kravchuk
Please, check if it works as expected in Query Browser 1.2.17 on Windows. GUI tools on Linux are not supported.
[25 Oct 2009 11:03] Miran Cvenkel
Ok did that, works. Sory to hear that GUI is no suportedd on linux, although then I don't know why I can then get RHEL distribution of it.

Thanks.
[25 Oct 2009 15:29] Valeriy Kravchuk
You can still use it, if it works for you. We just do not fix bugs in (old) GUI tools on Linux any more. So, in case of bugs, either try to use (newer) Windows version or wait for MySQL Workbench 5.2 to implement all QB functionality and to be declared GA (alpha for now).