× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2017-05-08T20:45:32Z  · tariqrahiman last modified 2017-05-15T03:55:45Z

Sybase ASE -> Script table fails to extract and script constraint


customer request
Priority Critical
Complexity Unknown
Component DB - Sybase ASE
Version 17.0
Attempting to script table fails to script constraint.
CREATE TABLE tbl_test (a varchar(20) NOT NULL,b varchar(30) NOT NULL,c varchar(30) NOT NULL,d datetime NOT NULL,e datetime NULL)
GO
ALTER TABLE tbl_test ADD CONSTRAINT tbl_test_const_a UNIQUE (d, b, a) 
GO
Customer experiences following exception in sql log:
com.sybase.jdbc4.jdbc.SybSQLException: Attempt to insert NULL value into column 4 in work table (table id 2323841017); column does not allow NULLS.  UPDATE fails.
    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4117)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3207)
    at com.sybase.jdbc4.tds.Tds.getResultSetResult(Tds.java:3973)
    at com.sybase.jdbc4.tds.TdsCursor.open(TdsCursor.java:328)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2604)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:555)
    at \\.\\.\\हिñçêČάй語简?한\\.mvolatile.executeQuery(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.I̞ꇒꂔꈑ.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.I̞ꇒꂔꈑ.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.I̞ꇒꂔꈑ.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.I̞ꇒꂔꈑ.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.Fꌺꋚꋟꊘprotected.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.Fꌺꋚꋟꊘprotected.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.Bꑄꌭꉿthrows.a(Unknown Source)
    at \\.\\.\\हिñçêČάй語简?한\\.aꑸꇲ.a(Unknown Source)
    at com.aquafold.datastudio.mainframe.ActionHandler.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 com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
    at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
    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)

Issue #15209

Closed
Fixed
Resolved 2017-05-08T20:53:58Z
 
 
Completion
No due date
Fixed Build v19.0.0-dev-40, v18.0.11-1, v17.0.12-7
No time estimate

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