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
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 \\.\\.\\हिñçêČάй語简�?한\\.mᚾꋁᠡꄱvolatile.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)
Are never shared
Disappear as soon as the command completes
Verified in ADS v18.0.11-1. No exceptions occur and Constraint is scripted correctly
Verified in ADS v18.0.11-1. No exceptions occur and Constraint is scripted correctly
Issue #15209 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v19.0.0-dev-40, v18.0.11-1, v17.0.12-7 |
No time estimate |
Are never shared
Disappear as soon as the command completes