Product: Aqua Data Studio
Version: 18.0.0-rc-2
Build #: 52354
Build Date: 2016-Dec-19 07:48:06 PM
Steps to Reproduce:
1. Create a VoltDB schema having an Geospatial datatypes table.
(Use Geospatial.sql)
2. Connect to VoltDB database server in ADS.
3. Expand tree node, Geospatial tables are displayed successfully in tree node.
4. Right click on created tables and choose Script object to window as >> SELECT/Select * from option.
SELECT * FROM PARKS
GO
SELECT * FROM TOWNS
GO
5. Select statements displayed in QA window. Now Execute Select query in QA window.
Actual Result:In view logs exception thrown.
java.lang.AssertionError: Unknown type: 27
at org.voltdb.VoltType.get(VoltType.java:419)
at org.voltdb.VoltTable.getColumnType(VoltTable.java:607)
at org.voltdb.jdbc.JDBC4ResultSetMetaData.getColumnType(JDBC4ResultSetMetaData.java:108)
at \\.\\.\\हिñçêČάй語简�?한\\.h⠱ꁨꐳꅲchar3.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.h⠱ꁨꐳꅲchar3.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Oᡈ᠃ꂯᜲchar.run(Unknown Source)
java.lang.AssertionError: Unknown type: 26
at org.voltdb.VoltType.get(VoltType.java:419)
at org.voltdb.VoltTable.getColumnType(VoltTable.java:607)
at org.voltdb.jdbc.JDBC4ResultSetMetaData.getColumnType(JDBC4ResultSetMetaData.java:108)
at \\.\\.\\हिñçêČάй語简�?한\\.h⠱ꁨꐳꅲchar3.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.h⠱ꁨꐳꅲchar3.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Oᡈ᠃ꂯᜲchar.run(Unknown Source)
Observation:
1. This is new datatypes and introducing in
VoltDB 6.0
2. Using in-build voltdb-6.8.jar file under ADS datastudio /lib folder,
'SELECT/Select * From' queries executed successfully in QA window and result also displayed.Refer attached screenshot.
