[jira] [Updated] (DERBY-7047) derby classCastException during SELECT statement
[ https://issues.apache.org/jira/browse/DERBY-7047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-7047: - Bug behavior facts: Seen in production > derby classCastException during SELECT statement > > > Key: DERBY-7047 > URL: https://issues.apache.org/jira/browse/DERBY-7047 > Project: Derby > Issue Type: Bug > Components: SQL, Store >Affects Versions: 10.14.2.0 >Reporter: Yoaz >Priority: Major > > we use embedded derby for tests and get a ClassCastException during > performing a select statement when multiple threads are executing the > following statement. > seems similar to the following ticket: > https://issues.apache.org/jira/browse/HIVE-16362 > "SELECT * FROM node_props WHERE node_id = ?" > our Derby jdbc version is : > *org.apache.derby:10.14.2.0* > following is our SELECT Statement: > Caused by: java.sql.SQLException: Java exception: > 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to > org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: > java.lang.ClassCastException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown > Source) > at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) > at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) > at > org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) > at > org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (DERBY-7047) derby classCastException during SELECT statement
[ https://issues.apache.org/jira/browse/DERBY-7047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-7047: - Component/s: Store SQL > derby classCastException during SELECT statement > > > Key: DERBY-7047 > URL: https://issues.apache.org/jira/browse/DERBY-7047 > Project: Derby > Issue Type: Bug > Components: SQL, Store >Affects Versions: 10.14.2.0 >Reporter: Yoaz >Priority: Major > > we use embedded derby for tests and get a ClassCastException during > performing a select statement when multiple threads are executing the > following statement. > seems similar to the following ticket: > https://issues.apache.org/jira/browse/HIVE-16362 > "SELECT * FROM node_props WHERE node_id = ?" > our Derby jdbc version is : > *org.apache.derby:10.14.2.0* > following is our SELECT Statement: > Caused by: java.sql.SQLException: Java exception: > 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to > org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: > java.lang.ClassCastException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown > Source) > at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) > at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) > at > org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) > at > org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (DERBY-7048) Unexpected quantified ALL predicate result
Knut Wannheden created DERBY-7048: - Summary: Unexpected quantified ALL predicate result Key: DERBY-7048 URL: https://issues.apache.org/jira/browse/DERBY-7048 Project: Derby Issue Type: Bug Components: SQL Affects Versions: 10.15.1.3 Reporter: Knut Wannheden According to the SQL standard the following query should return {{NULL}} rather than {{FALSE}}: {code:java} select 1 = all (select cast(null as numeric) from sysibm.sysdummy1) from sysibm.sysdummy1 {code} The same goes for the {{ANY}} predicate, which should also evaluate to {{NULL}} but currently returns {{false}}: {code:java} select 1 = any (select cast(null as numeric) from sysibm.sysdummy1) from sysibm.sysdummy1{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (DERBY-7047) derby classCastException during SELECT statement
[ https://issues.apache.org/jira/browse/DERBY-7047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yoaz updated DERBY-7047: Description: we use embedded derby for tests and get a ClassCastException during performing a select statement when multiple threads are executing the following statement. seems similar to the following ticket: https://issues.apache.org/jira/browse/HIVE-16362 "SELECT * FROM node_props WHERE node_id = ?" our Derby jdbc version is : *org.apache.derby:10.14.2.0* following is our SELECT Statement: Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) was: we use embedded derby for tests and get a ClassCastException during performing a select statement when multiple threads are executing the following statement. "SELECT * FROM node_props WHERE node_id = ?" our Derby jdbc version is : *org.apache.derby:10.14.2.0* following is our SELECT Statement: Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) > derby classCastException during SELECT statement > > > Key: DERBY-7047 > URL: https://issues.apache.org/jira/browse/DERBY-7047 > Project: Derby > Issue Type: Bug >Affects Versions: 10.14.2.0 >Reporter: Yoaz >Priority: Major > > we use embedded derby for tests and get a ClassCastException during > performing a select statement when multiple threads are executing the > following statement. > seems similar to the following ticket: > https://issues.apache.org/jira/browse/HIVE-16362 > "SELECT * FROM node_props WHERE node_id = ?" > our Derby jdbc version is : > *org.apache.derby:10.14.2.0* > following is our SELECT Statement: > Caused by: java.sql.SQLException: Java exception: > 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to > org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: > java.lang.ClassCastException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at
[jira] [Updated] (DERBY-7047) derby classCastException during SELECT statement
[ https://issues.apache.org/jira/browse/DERBY-7047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yoaz updated DERBY-7047: Description: we use embedded derby for tests and get a ClassCastException during performing a select statement when multiple threads are executing the following statement. "SELECT * FROM node_props WHERE node_id = ?" our Derby jdbc version is : *org.apache.derby:10.14.2.0* following is our SELECT Statement: Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) was: we use embedded derby for tests and get a ClassCastException during performing a select statement while run concurrently. Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) > derby classCastException during SELECT statement > > > Key: DERBY-7047 > URL: https://issues.apache.org/jira/browse/DERBY-7047 > Project: Derby > Issue Type: Bug >Affects Versions: 10.14.2.0 >Reporter: Yoaz >Priority: Major > > we use embedded derby for tests and get a ClassCastException during > performing a select statement when multiple threads are executing the > following statement. > "SELECT * FROM node_props WHERE node_id = ?" > our Derby jdbc version is : > *org.apache.derby:10.14.2.0* > following is our SELECT Statement: > Caused by: java.sql.SQLException: Java exception: > 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to > org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: > java.lang.ClassCastException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at
[jira] [Created] (DERBY-7047) derby classCastException during SELECT statement
Yoaz created DERBY-7047: --- Summary: derby classCastException during SELECT statement Key: DERBY-7047 URL: https://issues.apache.org/jira/browse/DERBY-7047 Project: Derby Issue Type: Bug Affects Versions: 10.14.2.0 Reporter: Yoaz we use embedded derby for tests and get a ClassCastException during performing a select statement while run concurrently. Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184) at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152) at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85) at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163) -- This message was sent by Atlassian JIRA (v7.6.3#76005)