Aqua Data Studio 15.0.0-dev-256
Build #: 37570
Database: Vertica 7.0.0
OS:Windows 8
Built on: 2014-Apr-28 05:22:50 PM
Steps to Reproduce:
1.Connect to Vertica Database.
2.Create the following flex table script
CREATE FLEX TABLE "public"."darkdata4" (
"date_col" date NOT NULL
)
ORDER BY "date_col"
GO
Table created successfully.
3.From Menu option select "Tools" option,from Tools menu option ,select option Schema Compare.
4.Go to Server1 pane option in schema compare window and click on Server1 option and from Server1 option select Vertica Database,from database drop down list select
option vbmart and from schema drop down list select schema "Public".
Follow the same steps for server2 pane and select database vbmart and from schema drop down list select schema "Public".
5.From Schema Object Pane in Schema Compare Window ,select option Tables.
6.Go to Object Pane,and from Object pane select flex table "darkdata4" for both the database and schema.
7. Click on button compare.
8.From schema compare window,select the table and click on Compare Data Icon.
Here it is observe that in view log it will give exception.
Exception: java.lang.NullPointerException
at \\...\\ .\\??ñçêC???????\\.w???? throw.a(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.w???? throw.aXa(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.N????.start(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.w???? throw.E(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.w???? throw.l(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.w???? throw.<init>(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.u???? return return.Gk(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.S???? goto volatile.action(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.y??/? continue 4.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Not able to reproduce in 15.0.0-dev-255. Your script does not have the Partition By Clause while creating the table and how does it get displayed in the Script ? Can you do a SELECT version() and let us know what version.