Issue Details (XML | Word | Printable)

Key: DERBY-318
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Tomohito Nakayama
Reporter: A B
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

SYS.SYSCOLUMN problem with "GENERATED BY DEFAULT" column w/ Network Server

Created: 27/May/05 02:42 AM   Updated: 11/Jun/05 12:37 AM
Return to search
Component/s: Network Server
Affects Version/s: 10.1.1.0
Fix Version/s: 10.1.1.0

Time Tracking:
Not Specified

File Attachments:
  Size
Text File Licensed for inclusion in ASF works DERBY-318.patch 2005-06-02 07:23 PM Tomohito Nakayama 292 kB
Text File Licensed for inclusion in ASF works derbyall_diff.txt 2005-06-02 07:25 PM Tomohito Nakayama 6 kB
Environment: Derby in Network Server mode with either JCC or Derby Net Client.

Resolution Date: 11/Jun/05 12:37 AM


 Description  « Hide
When connected to the Derby Network Server, if one has a table with a column defined as "GENERATED BY DEFAULT" and then one tries to select the "COLUMNDEFAULT" field from SYS.SYSCOLUMNS, the result is an NPE in the server code that leads to connection deallocation.

I don't know if this is a problem with the "GENERATED BY DEFAULT" feature or if it's a problem with Network Server--more investigation is required.

To reproduce, use ij to connect to a database using Network Server, and then:

ij> create table t1 (i int generated by default as identity);
0 rows inserted/updated/deleted
ij> select columndefault from sys.syscolumns;

COLUMNDEFAULT

----------------------------------------------------------------------------------------------------
----------------------------
null
java.lang.NullPointerException
        at org.apache.derby.impl.drda.DRDAConnThread.writeFdocaVal(DRDAConnThread.java:6550)
        at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(DRDAConnThread.java:5973)
        at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(DRDAConnThread.java:5796)
        at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:595)
        at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:226)
agentThread[DRDAConnThread_2,5,main]
ERROR 58009: Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x3


 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Tomohito Nakayama made changes - 02/Jun/05 07:23 PM
Field Original Value New Value
Attachment DERBY-318.patch [ 20379 ]
Tomohito Nakayama made changes - 02/Jun/05 07:25 PM
Attachment derbyall_diff.txt [ 20380 ]
Andrew McIntyre made changes - 03/Jun/05 05:12 AM
Fix Version/s 10.1.0.0 [ 10993 ]
A B made changes - 11/Jun/05 12:37 AM
Status Open [ 1 ] Resolved [ 5 ]
Assignee Tomohito Nakayama [ naka ]
Resolution Fixed [ 1 ]
A B made changes - 11/Jun/05 12:37 AM
Status Resolved [ 5 ] Closed [ 6 ]