Operating Environment: Mac OS X (10.12.3, x86_64) / UTF-8 / en / AU / Oracle Corporation 1.8.0_40-b27
Connect any database (e.g Mysql-5.7)
//Create table using below script
CREATE TABLE test_datetime_scenario (
col1 smallint(5) NOT NULL,
col2 Datetime(6) NOT NULL,
col3 INT NOT NULL,
col4 INT NOT NULL,
PRIMARY KEY(col1, col2)
)
GO
INSERT INTO `test_datetime_scenario`(`col1`, `col2`, `col3`, `col4`)
VALUES(2, '2017-6-15 12:30:12.8596', 10, 10)
GO
INSERT INTO `test_datetime_scenario`(`col1`, `col2`, `col3`, `col4`)
VALUES(1, '2017-06-15 12:30:12.895675', 10, 10)
GO
INSERT INTO `test_datetime_scenario`(`col1`, `col2`, `col3`, `col4`)
VALUES(1, '2017-06-15 12:30:12.124568', 10, 10)
GO
Steps->01
Go to File menu->options
Go to Result format option and select Mysql database
Select datatypes->Datetime/Timestamp and select format "$#,##0.00;($#,##0.00)"
Click on ok button
Steps->02
Go to table tree node and Open query analyzer and execute below "SELECT" script
SELECT * FROM `test_datetime_scenario`
GO
SELECT script executed successfully and displayed a result set in assigned result format.
Click on view as spreadsheet icon
Actual Result:
You can see that "view as spreadsheet" icon is not working.
Expected Result:
"spreadsheet" should be opened after pressing "view as spreadsheet" icon.
Broken Build > 18.0.11-2 and Build #: 54291 and Build Date: 2017-May-08 09:52:01 PM
Check view log
java.lang.NoSuchFieldError: TIMESTAMP_FORMAT
at \\.\\.\\हिñçêČάй語简�?한\\.Xꆊꋻꄼꁢtransient.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.tꍃꄁꅛꃅvoid.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.tꍃꄁꅛꃅvoid.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.tꍃꄁꅛꃅvoid.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.nꆇ⣙ꄇꑚ.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.nꆇ⣙ꄇꑚ.b(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Cꆽꉇꈮᛞbreak1.bXI(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Cꆽꉇꈮᛞbreak1$1.action(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.oꁐꌶꋠᚩ.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:866)
at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:650)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:381)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Changes to this issue caused the java.lang.NoSuchFieldError Exception <aquadatastudio:#15211> When using sqlexport to export data to Excel file, timestamp values should use Timestamp format and date values should use Date format