Aqua Data Studio 15.0.0-dev-334
Database Version: MySQL 5.7
Precondition :
Go to File options in ADS menubar
Select Options option
Uncheck General > ';' Statement separator option
Uncheck Scripts > MySQL > ';' Statement separator option
Click on OK button
1. Create Database
CREATE DATABASE `sample`
DEFAULT CHARACTER SET latin1
DEFAULT COLLATE latin1_swedish_ci
GO
2. Create Table
CREATE TABLE `messages` (
`id` int(11) UNSIGNED ZEROFILL AUTO_INCREMENT COMMENT 'ID COLUMN' NOT NULL,
`message` varchar(255) COMMENT 'MESSAGE COLUMN' NOT NULL DEFAULT 'NULL',
`time` timestamp COMMENT 'TIMESTAMP' NULL,
PRIMARY KEY(`id`)
)
3.Open Query Analyzer and execute below script:
CREATE PROCEDURE `sample`.`proc_insertion` (IN W_IN INT)
BEGIN
IF W_IN >= 0 THEN
INSERT INTO `sample`.`messages`(`message`)
VALUES('Procedure proc_insertion executed successfully');
END IF;
END
GO
CREATE FUNCTION `sample`.`print`()
RETURNS TEXT
LANGUAGE SQL
BEGIN
RETURN 'Function Executed Successfully';
END
GO
2. Follow below steps to reproduce bug:
Go to Schema Browser
Expand MySQL Server node
Expand Databases node
Expand sample Database
Open View Log
Scenario:
Expand Procedure node
Right click on proc_insertion
Select Alter option (any right click option)
Actual Result: In View log an jdbc exception is displayed.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM INFORMATION_SCHEMA.ROUTINES r LEFT JOIN INFORMATION_SCHEMA.PARAMETERS p ON ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at \\...\\ .\\हिñçêČάй語简�?한\\.kꂗ̃ꉾ́.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.V⠯ꀟꏚꇼ 7 6.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.V⠯ꀟꏚꇼ 7 6.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.T̻ꑅ⡼ꀄ 7$1.de(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.t᠍ᢆꆷᢟ static.process(Unknown Source)
at com.common.ui.util.BackgroundThread.run(Unknown Source)
Note: Same issue is producible for Function.
|
233 KB
Ivan, please look at this for 14.0 and 15.0
Issue was created with a customer fix 2 weeks ago. Extract parameter fixed for both 14 adn 15
Issue was created with a customer fix 2 weeks ago. Extract parameter fixed for both 14 adn 15
Issue #12298 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v15.0.0-dev-335 |
No time estimate |
Ivan, please look at this for 14.0 and 15.0