× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2016-02-08T19:18:57Z  · last modified 2016-02-15T16:07:03Z

MySQL Visual Explain: gives error for versions 5.0 and below


customer request
Priority Major
Complexity Unknown
Component Q Analyzer - Visual Explain Plan - MySQL
Version 17.0
Version: 17.0.2-2
Build #: 48494
Build Date: 2016-Feb-05 09:47:03 AM
 
MySQL Visual Explain gives error for versions 5.0 and below
Able to reproduce in MySQL 5.0 at 1.72
MySQL v 4.1 at 1.73
 
To reproduce:
 
1. Navigate to MySQL 5.0  at AWS ending 1.72
2. Go to chinook database
3. type and do a Execute Explain
 
SELECT * FROM album
GO
 
4.  We get an error message 
 
Describe Error: Failed to execute EXPLAIN plan: 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 'SELECT * FROM album' at line 1
 
5. Under ADS -> SQL Log you get exception in Explain Partitions query as below
 
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 'SELECT * FROM album' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
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 \\.\\.\\हिñçêČάй語简�?한\\.nꈴꀋꏢꈀnative.executeQuery(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.oꃤꄗ⡦᡹5if.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.tꍄ⣰ꀘ⠜import2.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.d⡾⡩᠞ꌿ7.run(Unknown Source)
 
3 attachments

Issue #14264

Closed
Fixed
Resolved 2016-02-08T21:19:35Z
 
 
Completion
No due date
Fixed Build ADS 17.0.2-5
No time estimate

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