× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Shavi57 reported 2014-06-23T12:25:16Z  · tariqrahiman last modified 2014-06-29T18:00:06Z

After performing any right click option on Procedure/Function "MySQLSyntaxErrorException" exception is thrown


Priority Low
Complexity Unknown
Component App - Visual Editing
Version 15.0

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.

 

 

1 attachment

Issue #12298

Closed
Fixed
Resolved 2014-06-23T17:35:12Z
 
 
Completion
No due date
Fixed Build v15.0.0-dev-335
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017