Browse Component - ASF JIRA

All Projects : Derby : SQL (Component)

Open Issues

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