db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Updated: (DERBY-318) SYS.SYSCOLUMN problem with "GENERATED BY DEFAULT" column w/ Network Server
Date Fri, 03 Jun 2005 00:35:23 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
This patch is submitted. Please resolve and close the bug. I think Army
(who submitted the bug) already has confirmed it is indeed fixed by
your patch.<br>
<br>
Satheesh<br>
<br>
Tomohito Nakayama (JIRA) wrote:<br>
<blockquote
 cite="mid1312466992.1117708013401.JavaMail.jira@ajax.apache.org"
 type="cite">
  <pre wrap="">     [ <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-318?page=all">http://issues.apache.org/jira/browse/DERBY-318?page=all</a>
]

Tomohito Nakayama updated DERBY-318:
------------------------------------

    Attachment: DERBY-318.patch

Modified:
1:
SYSCOLUMNS.COLUMNDEFAULT have "GENERATED_BY_DEFAULT", 
if the SYSCOLUMNS record stands for default autoinc column.
2:
Test for 1: was added to lang/syscat.sql.
3:
lang/syscat.sql became to executed in derbynetmats.runall.
This results addition of syscat.sql to both of derbynet and derbynetclient.


Testing:
Executed derbyall and found three error.

They seems to be same error as next.
<a class="moz-txt-link-freetext" href="http://www.multinet.no/~solberg/public/Apache/Derby/testlog/SunOS-5.10_i86pc-i386/179247-derbynetclientmats_diff.txt">http://www.multinet.no/~solberg/public/Apache/Derby/testlog/SunOS-5.10_i86pc-i386/179247-derbynetclientmats_diff.txt</a>
<a class="moz-txt-link-freetext" href="http://www.multinet.no/~solberg/public/Apache/Derby/testlog/Linux-2.4.20-31.9_i686-i686/179247-storeall_diff.txt">http://www.multinet.no/~solberg/public/Apache/Derby/testlog/Linux-2.4.20-31.9_i686-i686/179247-storeall_diff.txt</a>

Test result will be uploaded next to this patch.

  </pre>
  <blockquote type="cite">
    <pre wrap="">SYS.SYSCOLUMN problem with "GENERATED BY DEFAULT" column w/ Network
Server
--------------------------------------------------------------------------

         Key: DERBY-318
         URL: <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-318">http://issues.apache.org/jira/browse/DERBY-318</a>
     Project: Derby
        Type: Bug
  Components: Network Server
    Versions: 10.1.0.0
 Environment: Derby in Network Server mode with either JCC or Derby Net Client.
    Reporter: A B
 Attachments: DERBY-318.patch, derbyall_diff.txt

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&gt; create table t1 (i int generated by default as identity);
0 rows inserted/updated/deleted
ij&gt; 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
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>


Mime
View raw message