× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Shavi57 reported 2015-04-27T08:14:47Z  · tomconrad last modified 2018-03-08T23:03:06Z

MySQL: extractIndexes and extractIndex methods throws exception in View log and does not returns the expected output


PM
Priority Minor
Complexity Unknown
Component DB - MySQL
Version Future
Product: Aqua Data Studio
Version: 17.0.0-dev-18
Build #: 43680
Build Date: 2015-Apr-22 06:02:48 PM
 
Operating Environment: Linux (3.19.0-15-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072;  Total=431,489,024;  Free=241,499,008;  CPUs=8
 
Database Version: MySQL 5.7.4-m14
 
Steps to reproduce issue:
 
Execute script in attached .sql file 
Execute script in attached .xjs file
In aqua-script you have to set correct variables values for server,schema and database variables.
 
Actual result: 
- For MySQL server the extractIndexe and  extractIndexes methods are not working as expected. It does not returns the indexes.
 
- In View log exception is thrown "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sample.sample' doesn't exist".
 
Stack trace:
 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sample.sample' doesn't exist
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 \\...\\ .\\हिñçêČάй語简�?한\\.p⢬ꊈꑙ͠ void.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Cᝈꀠ᠖ꀟ short void.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Cᝈꀠ᠖ꀟ short void.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Cᝈꀠ᠖ꀟ short void.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Cᝈꀠ᠖ꀟ short void.z(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.vꁴ̅ꐁ̫.extractIndexes(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.mozilla.javascript.MemberBox.invoke(Unknown Source)
at org.mozilla.javascript.NativeJavaMethod.call(Unknown Source)
at org.mozilla.javascript.optimizer.OptRuntime.call2(Unknown Source)
at org.mozilla.javascript.gen.c_14._c_script_0(:9)
at org.mozilla.javascript.gen.c_14.call()
at org.mozilla.javascript.ContextFactory.doTopCall(Unknown Source)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Unknown Source)
at org.mozilla.javascript.gen.c_14.call()
at org.mozilla.javascript.gen.c_14.exec()
at org.mozilla.javascript.Context.evaluateString(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Rꉖ ⠔ᚺ new.ws(Unknown Source)
at com.aquafold.aquacore.open.y⠃ꎛꃥꆨ float.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)
 
5 attachments

Issue #13274

New
 
 
Completion
No due date
No fixed build
No time estimate

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