You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Prasenjit Sarkar (JIRA)" <de...@db.apache.org> on 2006/08/30 02:26:22 UTC
[jira] Commented: (DERBY-1777) Regression: query works in 10.1.2.1
but fails with NullPointerException in 10.2.1.1
[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12431425 ]
Prasenjit Sarkar commented on DERBY-1777:
-----------------------------------------
There are 15 other queries that fail. Here's one more:
1.
SELECT
OTHER2PORT2PORT.PORT_ID PORT_ID,
OTHER2PORT2PORT.DETECTABLE DETECTABLE,
OTHER2PORT2PORT.PORT_ID2 PORT_ID2,
CASE
WHEN T_RES_PORT.DISPLAY_NAME IS NOT NULL THEN T_RES_PORT.DISPLAY_NAME
ELSE T_RES_PORT.NAME
END PORT2_NAME,
T_RES_PORT.PORT_NUMBER PORT_NUMBER,
OTHER2PORT2PORT.PORT2PORT_ID PORT2PORT_ID,
ENTITY2PORT.PREFIX_ID,
ENTITY2PORT.ENTITY_ID
FROM
T_RES_PORT,
(SELECT
PORT2PORT.PORT_ID2 PORT_ID,
OTHER2PORT.OTHER_ID OTHER_ID,
OTHER2PORT.PREFIX_ID PREFIX_ID,
OTHER2PORT.PORT_ID PORT_ID2,
PORT2PORT.DETECTABLE DETECTABLE,
PORT2PORT.PORT2PORT_ID PORT2PORT_ID
FROM
T_VIEW_PORT2PORT PORT2PORT,
T_VIEW_VOTHER2PORT OTHER2PORT
WHERE
PORT2PORT.PORT_ID1 = OTHER2PORT.PORT_ID) OTHER2PORT2PORT, T_VIEW_ENTITY2PORT ENTITY2PORT
WHERE
ENTITY2PORT.PORT_ID = T_RES_PORT.PORT_ID and
T_RES_PORT.PORT_ID = OTHER2PORT2PORT.PORT_ID and
OTHER2PORT2PORT.OTHER_ID = 1 and
OTHER2PORT2PORT.PREFIX_ID = 'x'
> 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
> Fix For: 10.2.1.0
>
>
> 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