[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12435501 ] A B commented on DERBY-1777: ----------------------------
Thank you for the review and commit, Rick. I know you recently sent an email about the imminent 10.2 release candidate--are you planning to do another mega-merge before the candidate? If not, would you be willing to commit this to 10.2, as well? Thanks for your time! > Regression: query works in 10.1.2.1 but fails with NullPointerException in > 10.2.1.1 > ----------------------------------------------------------------------------------- > > Key: DERBY-1777 > URL: http://issues.apache.org/jira/browse/DERBY-1777 > Project: Derby > Issue Type: Bug > Environment: WinXP SP2 dualcore 2.8 GHz 2 GBmemory > Reporter: Prasenjit Sarkar > Assigned To: A B > Fix For: 10.2.1.0 > > Attachments: Aperi.zip, d1777_v1.patch, d1777_v2.patch, Derby1777.zip > > > However, here's a query that works in 10.1.2.1 but not in 10.2.1.1 -- > database can be assumed to be the same in Derby - 1205 > SELECT DISTINCT > ZONE.ZONE_ID ZONE_ID, > PORT.PORT_ID PORT_ID, > ENTITY_TO_PORT.TYPE, > ENTITY_TO_PORT.PREFIX_ID, > ENTITY_TO_PORT.ENTITY_ID, > ENTITY_TO_PORT.DISPLAY_NAME, > ENTITY_TO_PORT.PORT_DISPLAY_NAME, > PORT2ZONE.MEMBER_NAME, > PORT2ZONE.ZONE_MEMBER_ID, > PORT.PORT_NUMBER > FROM > T_RES_ZONE ZONE left outer join T_VIEW_PORT2ZONE PORT2ZONE on > ZONE.ZONE_ID = PORT2ZONE.ZONE_ID left outer join T_RES_PORT PORT on > PORT2ZONE.PORT_ID = PORT.PORT_ID left outer join T_VIEW_ENTITY_TO_PORT > ENTITY_TO_PORT on > PORT2ZONE.PORT_ID = ENTITY_TO_PORT.PORT_ID and > PORT2ZONE.ZONE_ID = ENTITY_TO_PORT.ZONE_ID, T_RES_FABRIC FABRIC > WHERE PORT2ZONE.ZONE_ID = ZONE.ZONE_ID and > ZONE.FABRIC_WWN = FABRIC.FABRIC_WWN and > FABRIC.FABRIC_ID = 1 > Same db as before. > In 10.2.1.1 it gives the following error (should this be a new issue?) > java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, > SQLERRMC: java.lang.NullPointerExceptionXJ001.U > at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) > at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) > at > org.eclipse.aperi.server.guireq.topology.views.ViewerSanL1.init(ViewerSanL1.java:1828) > > at > org.eclipse.aperi.server.guireq.topology.views.ViewerInit.init(ViewerInit.java:41) > > at > org.eclipse.aperi.server.guireq.topology.views.ViewerInit.main(ViewerInit.java:69) > > Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: > -1, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U > at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown > Source) > at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown > Source) > at > org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown > Source) > at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown > Source) > at > org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown > Source) > at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) > at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) > ... 4 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
