All Projects : Derby : SQL (Component)



 Select:   Open Issues   Road Map   Change Log   Popular Issues   

Open Issues

Viewing 50 of 262 unresolved issue(s).

Versions

(with open issues due to be fixed per version for this component)
   Bug DERBY-4371 UNRESOLVED Non-selected columns for SELECT DISTINCT allowed in ORDER BY clause if ordered by expression Critical Open
   Bug DERBY-3714 UNRESOLVED Significant performance degradation if Hibernate creates different order of attributes Critical Open
   Bug DERBY-2380 UNRESOLVED A statement plan holds onto resources such as its generated class even after it has been invalidated. Major Open
   Bug DERBY-2349 UNRESOLVED Accessing a BLOB column twice in an INSERT trigger leads to errors in the value on-disk Major Open
   Improvement DERBY-2212 UNRESOLVED Add "Unique where not null" to create index Major Open
   Improvement DERBY-2252 UNRESOLVED Add Jar IDs to the EXTERNAL names in routine declarations Major Open
   Improvement DERBY-2485 UNRESOLVED Add OO callback scheme for transaction commit & rollback at LanguageConnectionContext layer Major Open
   Improvement DERBY-3908 UNRESOLVED Add a mechanism for cancelling runaway transactions. Major Open
   Improvement DERBY-3670 UNRESOLVED Add spatial datatypes to Derby Major Open
   Improvement DERBY-455 UNRESOLVED Add support for creating index on expressions Major Open
   Improvement DERBY-4398 UNRESOLVED Allow OFFSET/FETCH in subqueries Major Open
   Improvement DERBY-4397 UNRESOLVED Allow ORDER BY in subqueries Major Open
   Improvement DERBY-4074 UNRESOLVED Allow UPDATE TABLE SET (col1,col2) = (SELECT a,b FROM ...) syntax Major Open
   Improvement DERBY-603 UNRESOLVED Allow aggregates to be used within the WHERE clause of a SELECT that is part of a HAVING clause. Major Open
   Improvement DERBY-4066 UNRESOLVED Allow functions/procedures to take Blob/Clob arguments Major Open
   Improvement DERBY-4003 UNRESOLVED Allow user-defined functions in GROUP BY expressions Major Open
   Bug DERBY-4389 UNRESOLVED ArrayIndexOutOfBoundsException in RIGHT JOIN with COALESCE Major Open
   Bug DERBY-4451 UNRESOLVED ArrayIndexOutOfBoundsException or ASSERT FAILED when inserting generated columns out of order Major Open
   Bug DERBY-4449 UNRESOLVED ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column Major Open
   Bug DERBY-4448 UNRESOLVED ArrayIndexOutOfBoundsException when trying to override generated column Major Open
   Bug DERBY-4403 UNRESOLVED Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression containing scalar subquery Major Open
   Bug DERBY-3396 UNRESOLVED At the end transaction time(through commit/rollback), is clearing of the conglomerate (used for scans for update and delete) for an activation happening in the right place? Major Open
   Bug DERBY-3944 UNRESOLVED CHECK constraints involving user-coded functions may return different results depending on who performs the triggering INSERT/UPDATE Major Open
   Bug DERBY-2002 UNRESOLVED Case expression allows NULL in all parts of <result> Major Open
   Bug DERBY-896 UNRESOLVED Cast date to timestamp results in "ERROR 42846: Cannot convert types 'DATE' to 'TIMESTAMP'." Major Open
   Improvement DERBY-2875 UNRESOLVED Check if collation determination logic can be consolidated in one central place rather than multiple places in the compile package Major Open
   Sub-task DERBY-2490 UNRESOLVED DERBY-2485
Clarify transaction management in LanguageConnectionContext.
Major Open
   Bug DERBY-1433 UNRESOLVED Client driver does not handle string literals containing "where current of" correctly Major Open
   Improvement DERBY-2465 UNRESOLVED Clob data type should use getCharacterStream() to read a column data from a VTI instead of getString(). Major Open
   Bug DERBY-3697 UNRESOLVED Compiler exception when invoking a routine with NUMERIC argument on J2ME Major Open
   Bug DERBY-3870 UNRESOLVED Concurrent Inserts of rows with XML data results in an exception Major Open
   Improvement DERBY-4437 UNRESOLVED Concurrent inserts into table with identity column perform poorly Major Open
   Bug DERBY-215 UNRESOLVED Correlation name not allowed for updatable columns in updatable cursors Major Open
   Improvement DERBY-3651 UNRESOLVED Current DataTypeDescriptor.comparable() is subset of SQL spec. Enhance it to fully implement SQL spec Major Open
   Improvement DERBY-3505 UNRESOLVED Current implementation of ROW_NUMBER() window function does not stop execution once criteria is met Major Open
   Improvement DERBY-1996 UNRESOLVED DatabaseMetaData.getColumns() takes long time to return columns for a particular schema of Apache JDO TCK Major Open
   Bug DERBY-4302 UNRESOLVED Deadlock on system tables Major Open
   Improvement DERBY-3069 UNRESOLVED Derby does not resolve functions bound to methods with varargs. Major Open
   Improvement DERBY-1631 UNRESOLVED Derby needs to support drop view cascade in order for revoke privilege to function correctly Major Open
   Improvement DERBY-2678 UNRESOLVED Derby should follow SQL standards when operand(s) in the collation operation have collation derivation of NONE Major Open
   Bug DERBY-3370 UNRESOLVED Derby should not support commit/rollback inside a SQL-invoked external function. Major Open
   Bug DERBY-4296 UNRESOLVED Derby should require EXECUTE privilege on SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE before allowing users to execute it Major Open
   Improvement DERBY-3662 UNRESOLVED Derby should support the SQL 2003 explict casting behavior Major Open
   Improvement DERBY-3256 UNRESOLVED Derby's reserved keyword list does not agree with either the SQL 92 or SQL 2003 standards Major Open
   Improvement DERBY-2852 UNRESOLVED Derby: Replication and Availability Major Open
   Bug DERBY-1139 UNRESOLVED Division operator may give wrong results with NUMERIC operands Major Open
   Improvement DERBY-2397 UNRESOLVED Dropping SQL objects could be improved by reducing the number of classes required. Major Open
   Bug DERBY-3940 UNRESOLVED Dropping a column does not drop triggers which mention that column Major Open
   Bug DERBY-1632 UNRESOLVED During revoke privilege, Derby does not look for replacement privilege for the dependent objects and simply drops the dependent objects. This is not SQL compliant and should be fixed. Major Open
   Bug DERBY-568 UNRESOLVED ERROR 42Y07: Schema 'SchemaName' does not exist. But Schema already present in sql sentence Major Open
  Viewing 50 of 262 Issues.
Unreleased 10.3.3.1 2
Released 10.4.1.3 2
Unreleased 10.6.0.0 5
Unreleased 11.0.0.0 1
  Unscheduled 252

Preset Filters


Component Summary

Open Open 251
   28%
In Progress In Progress 4
Reopened Reopened 7
   1%
Resolved Resolved 159
   18%
Closed Closed 461
   52%

Open Issues

By Priority
Critical Critical 2
   1%
Major Major 155
   59%
Minor Minor 103
   39%
Trivial Trivial 2
   1%

By Assignee
Anurag Shekhar 1
Bryan Pendleton 2
   1%
Dag H. Wanvik 2
   1%
Daniel John Debrunner 3
   1%
Dibyendu Majumdar 1
Kathey Marsden 1
Knut Anders Hatlen 2
   1%
Mamta A. Satoor 5
   2%
Rick Hillegas 1
Suran Jayathilaka 2
   1%
Unassigned 242
   92%