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-344) NPE while performing a 'select distinct ' on a database in softupgrademode with 10.1
Date Wed, 08 Jun 2005 22:10:28 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">
Submitted this patch.<br>
<br>
Sending       
java\engine\org\apache\derby\iapi\store\access\BackingStoreHashtable.java<br>
Transmitting file data .<br>
Committed revision 189662.<br>
<br>
Satheesh<br>
<br>
Jack Klebanoff (JIRA) wrote:<br>
<blockquote
 cite="mid1679928918.1118199880430.JavaMail.jira@ajax.apache.org"
 type="cite">
  <pre wrap="">     [ <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-344?page=all">http://issues.apache.org/jira/browse/DERBY-344?page=all</a>
]

Jack Klebanoff updated DERBY-344:
---------------------------------

    Attachment: BackingStoreHashtable2005-06-07.diff

[PATCH] The attached patch fixes the bug.
It has passed the derbylang and storeall test suites.
svn status is:
M      java\engine\org\apache\derby\iapi\store\access\BackingStoreHashtable.java


  </pre>
  <blockquote type="cite">
    <pre wrap="">NPE while performing a 'select distinct ' on a database in softupgrademode
with 10.1
------------------------------------------------------------------------------------

         Key: DERBY-344
         URL: <a class="moz-txt-link-freetext" href="http://issues.apache.org/jira/browse/DERBY-344">http://issues.apache.org/jira/browse/DERBY-344</a>
     Project: Derby
        Type: Bug
  Components: SQL
    Versions: 10.1.0.0
 Environment: Windows 2000
    Reporter: Rajesh Kartha
    Assignee: Jack Klebanoff
 Attachments: BackingStoreHashtable2005-06-07.diff

Performing a 'select distinct' on a database create with v10.0 and running under softupgrademode
with v10.1 throws a NPE. 
The ij tool in v10.1 was started using java -Dderby.database.allowPreReleaseUpgrade=true org.apache.derby.tools.ij

to allow softupgrades. 
ij&gt; connect 'jdbc:derby:videodb';
ij&gt; select distinct title from music_titles;
TITLE
--------------------------------------------------
 ACPE_music Blue You Flew Moo Do
APIH_music  You Flew Moo Do
ABZC_music  You Flew Moo Do
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
Following is the stack trace from the derby.log:
2005-06-07 23:15:53.921 GMT Thread[main,5,main] (XID = 279297), (SESSIONID = 0), (DATABASE
= videodb), (DRDAID = null), Failed Statement is: select distinct title from music_titles
java.lang.NullPointerException
	at org.apache.derby.iapi.store.access.BackingStoreHashtable.cloneRow(BackingStoreHashtable.java:326)
	at org.apache.derby.iapi.store.access.DiskHashtable$ElementEnum.nextElement(DiskHashtable.java:351)
	at org.apache.derby.iapi.store.access.BackingStoreHashtable$BackingStoreHashtableEnumeration.nextElement(BackingStoreHashtable.java:739)
	at org.apache.derby.impl.sql.execute.DistinctScanResultSet.getNextRowCore(DistinctScanResultSet.java:140)
	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:471)
	at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:346)
	at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:299)
	at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:334)
	at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:271)
	at org.apache.derby.tools.JDBCDisplayUtil.DisplayResults(JDBCDisplayUtil.java:260)
	at org.apache.derby.impl.tools.ij.utilMain.displayResult(utilMain.java:381)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:434)
	at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310)
	at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
	at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
	at org.apache.derby.tools.ij.main(ij.java:60)
Cleanup action completed
The schema looks like:
CREATE TABLE music_titles (
 title                        varchar (50) NOT NULL,
 artist                       varchar (50) NOT NULL,
 artist_more                  varchar (50) not null,
 distributor                  varchar (50),
 record_label                 varchar (50),
 type                         CHARACTER (10),CONSTRAINT music_titles_pk
 PRIMARY KEY (title, artist, artist_more))
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>


Mime
View raw message