Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 43043 invoked from network); 13 May 2008 18:24:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 May 2008 18:24:20 -0000 Received: (qmail 54868 invoked by uid 500); 13 May 2008 18:24:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 54841 invoked by uid 500); 13 May 2008 18:24:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 54830 invoked by uid 99); 13 May 2008 18:24:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 May 2008 11:24:21 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 May 2008 18:23:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id A673F234C111 for ; Tue, 13 May 2008 11:23:55 -0700 (PDT) Message-ID: <647501056.1210703035680.JavaMail.jira@brutus> Date: Tue, 13 May 2008 11:23:55 -0700 (PDT) From: "Mike Matrigali (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3219) Group by query with many aggregate columns and case statements fails with: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored In-Reply-To: <27625071.1195607863321.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-3219: ---------------------------------- Off hand I don't know if current derby code will ever read existing on disk character code using readExternal. Definitlely that is not the normal path. If so then changing writeExternal to write new data in a format that is backward compatible readable would be ok, though is a lot of overhead for a "0" length string. I will try to think of a case where old db's may still have the old format for the empty string and thus would not be fixed by your writeExternal change. > Group by query with many aggregate columns and case statements fails with: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-3219 > URL: https://issues.apache.org/jira/browse/DERBY-3219 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.3.1.4 > Reporter: Stan Bradbury > Assignee: Bryan Pendleton > Attachments: pivotView.zip > > > using the attached database (v10.3) - " select * from pivotview " fails with the stack trace below. A view (pivotview_ok) created on a subset of the columns in pivotview executes fine. Adding one column back into pivotview_ok causes failures most of the time. See attached for view definitions. > 2007-11-21 00:58:49.421 GMT Thread[main,5,main] (XID = 2734422), (SESSIONID = 0), (DATABASE = pivotview), (DRDAID = null), Failed Statement is: select * from pivotview > ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.store.raw.data.StreamFileContainer.fetchNext(Unknown Source) > at org.apache.derby.impl.store.raw.data.StreamFileContainerHandle.fetchNext(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeScan.mergeARow(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeScan.init(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeSort.openSortScan(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.openSortScan(Unknown Source) > at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.loadSorter(Unknown Source) > at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.openCore(Unknown Source) > at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source) > at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) > at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) > at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) > at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source) > at org.apache.derby.tools.ij.main(Unknown Source) > Caused by: java.io.EOFException > at java.io.DataInputStream.readBoolean(DataInputStream.java:248) > at org.apache.derby.impl.sql.execute.MaxMinAggregator.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source) > ... 22 more > ============= begin nested exception, level (1) =========== > java.io.EOFException > at java.io.DataInputStream.readBoolean(DataInputStream.java:248) > at org.apache.derby.impl.sql.execute.MaxMinAggregator.readExternal(Unknown Source) > at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source) > at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source) > at org.apache.derby.impl.store.raw.data.StreamFileContainer.fetchNext(Unknown Source) > at org.apache.derby.impl.store.raw.data.StreamFileContainerHandle.fetchNext(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeScan.mergeARow(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeScan.init(Unknown Source) > at org.apache.derby.impl.store.access.sort.MergeSort.openSortScan(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.openSortScan(Unknown Source) > at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.loadSorter(Unknown Source) > at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.openCore(Unknown Source) > at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source) > at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) > at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) > at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) > at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) > at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source) > at org.apache.derby.tools.ij.main(Unknown Source) > ============= end nested exception, level (1) =========== > Cleanup action completed -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.