Browse Component - ASF JIRA

10.5.3.0 ( 21/Aug/09 | Release Notes )

Progress:
1 of 1 issues have been resolved

Next release after 10.5.2.0 release candidate #1

DERBY-4331

FIXED

Join returns results in wrong order

10.5.2.0 ( 30/Jul/09 | Release Notes )

Progress:
11 of 11 issues have been resolved

10.5.2 Release July 30 2009 (794445) Now deprecated

DERBY-4268

FIXED

"SECURITY" is reserved as SQL keyword.

DERBY-4212

FIXED

Prepared statement with OFFSET/FETCH gives different results on subsequent execute

DERBY-4198

FIXED

When using the FOR UPDATE OF clause with SUR (Scroll-insensive updatable result sets), the updateRow() method crashes

DERBY-4142

FIXED

java.lang.VerifyError causing java.sql.SQLException: Cannot create an instance of generated class ... in lang.GeneratedColumnsTest and GeneratedColumnsPermsTest on IBM iseries

DERBY-3737

FIXED

Document the new SignatureChecker lint tool in the Tools Guide

DERBY-3926

FIXED

Incorrect ORDER BY caused by index

DERBY-4274

FIXED

SYSCS_UPDATE_STATISTICS takes unnecessary table lock

DERBY-4333

DUPLICATE

Exception in getMaxRows() after NullPointerException in SQLClob.readExternal() during query in table with CLOB column

DERBY-4204

FIXED

Runtime statistics not collected on re-execution of statement

DERBY-4001

FIXED

Sequence comparison with "ALL" does not yield correct results

DERBY-2447

FIXED

ejbql and floattypes in org.apache.derbyTesting.functionTests.tests.lang.LangScripts intermittently fails with 'expected:<[0.0 ] > but was:<[-0.0] '

10.5.1.1 ( 28/Apr/09 | Release Notes )

Progress:
78 of 78 issues have been resolved

build: 764942, 14/Apr/09. Voted release: 28/Apr/09. Announced: 1/May/09

DERBY-3373

FIXED

SQL "distinct" and "order by" needed together

DERBY-2892

FIXED

Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks

DERBY-3043

FIXED

'Schema <schemaname> does not exist' when constraint used in table definition

DERBY-4079

FIXED

Add support for SQL:2008 <result offset clause> and <fetch first clause> to limit result set cardinality

DERBY-3932

FIXED

Add tests of generated columns when sql authorization is turned on

DERBY-4063

FIXED

Constraint causes wrong query result when using exists

DERBY-3652

FIXED

Derby does not follow the SQL Standard when trying to map SQL routines to Java methods.

DERBY-3813

FIXED

Derby tests for the existance of BigDecimal methods toPlainString and bdPrecison but does not check if they were found before using them.

DERBY-3948

FIXED

Don't allow references to generated columns in the NEW transition variables of triggered actions of BEFORE triggers

DERBY-3945

FIXED

Generation clauses which mention user-coded functions may produce different resuls depending on who performs the triggering INSERT/UPDATE

DERBY-3219

FIXED

Group by query with many aggregate columns and case statements fails with: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored

DERBY-3570

FIXED

Implement DETERMINISTIC keyword for procedures and functions

DERBY-2207

FIXED

Improve usability of Derby's client/server security by implementing ANSI Roles

DERBY-3360

FIXED

Invalid method java.lang.Integer >> void <init>(short) because java.lang.NoSuchMethodException: java.lang.Integer.<init>(short)

DERBY-3923

FIXED

Make the datatype optional when declaring columns with generation clauses

DERBY-3969

FIXED

NPE if you declare a constraint on a generated column and omit the datatype

DERBY-3904

FIXED

NPE on left join with aggregate

DERBY-3718

FIXED

NPE when firing a trigger

DERBY-3266

FIXED

Not possible for non-db-owner to create a temporary table. "Get ERROR 42507: User 'USERB' can not perform the operation in schema 'SESSION'."

DERBY-3964

FIXED

NullPointerException when re-evaluating generated column during ON DELETE SET NULL referential action

DERBY-3997

FIXED

ORDER BY causes column to be returned

DERBY-2351

FIXED

ORDER BY with expression with distinct in the select list returns incorrect result

DERBY-269

FIXED

Provide some way to update index cardinality statistics (e.g. reimplement update statistics)

DERBY-3613

FIXED

SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2

DERBY-3678

FIXED

StackOverflowException in deadlock trace

DERBY-2861

FIXED

Thread safety issue in TableDescriptor

DERBY-3764

FIXED

Union Query fail on Derby 10.4.1.3

DERBY-4048

FIXED

Update Statistics code in AlterTableConstantAction should use execute transaction rather than compile transaction

DERBY-3950

FIXED

You should get an error if you try to override a generated column via an INSERT driven by an inner ResultSet

DERBY-3649

FIXED

can't call a stored function with an aggregate argument without getting the following error: ERROR 42Y29

DERBY-481

FIXED

implement SQL generated columns

DERBY-3631

DUPLICATE

UDF used with aggregate arguments results in error 30000

DERBY-4006

FIXED

ALTER COLUMN ... WITH DEFAULT NULL does not change the default

DERBY-3673

FIXED

DERBY-3137

Add checks that a new role isn't already a user authorization id

DERBY-3722

FIXED

DERBY-3137

Add circularity check for the GRANT role statement

DERBY-4071

FIXED

AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns

DERBY-4146

FIXED

Cannot insert row when a generated column references an identity column

DERBY-1331

FIXED

Derby's "set schema" behavior is not compliant with SQL 2003 Foundation spec.

DERBY-3922

FIXED

Enable the adding of generated columns via ALTER TABLE

DERBY-3666

FIXED

DERBY-3223

Make role descriptor a dependency Provider

DERBY-4145

FIXED

NullPointerException on CREATE TABLE when generated column depends on another generated column

DERBY-3743

FIXED

Revoking EXECUTE privilege on a function if used in a CHECK constraint: implementation problem

DERBY-3736

FIXED

Revoking a column level privilege from a user, a prepared statement relying on that privilege can still be executed

DERBY-3975

FIXED

SELECT DISTINCT may return duplicates with territory-based collation

DERBY-3741

FIXED

SQL LENGTH function materializes CLOB into memory

DERBY-3327

FIXED

SQL roles: Implement authorization stack (and SQL session context to hold it)

DERBY-3667

FIXED

SQL roles: Make CURRENT_ROLE check that the role is still valid

DERBY-3137

FIXED

SQL roles: add catalog support

DERBY-3886

FIXED

SQL roles: ij show enabled and settable roles

DERBY-3223

FIXED

SQL roles: make use of privileges granted to roles in actual privilege checking

DERBY-4040

FIXED

SQLChar.getLength returns wrong length for some data values

DERBY-3897

FIXED

SQLSessionContext not correctly initialized in some non-method call nested contexts

DERBY-4116

FIXED

SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table

DERBY-3354

FIXED

Select from large lob table with embedded gives OutOfMemoryError

DERBY-4095

FIXED

Trigger fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet not open during VTIResultSet.getNextRowCore()

DERBY-4141

FIXED

XAExceptions thrown by Derby can have errorCode 0

DERBY-4126

FIXED

You can't invoke a table function which is stored in a jar file inside the database

DERBY-3310

FIXED

ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions

DERBY-4013

FIXED

Allow standard SQL syntax: ALTER TABLE ALTER [COLUMN] <col> SET DEFAULT <default>

DERBY-3338

FIXED

CancelQueryTask.forgetContext() could be simplified.

DERBY-1062

FIXED

Change the internal implemetation of SYSCS_INPLACE_COMPRESS_TABLE to share existing alter table

DERBY-3270

FIXED

Delayed (on-demand) creation of current user schema makes select from view belonging to other schema fail.

DERBY-581

FIXED

Modify SQL to skip N rows of the result and return the next M rows

DERBY-3880

FIXED

NPE on a query with having clause involving a join

DERBY-3538

FIXED

NullPointerException during execution for query with LEFT OUTER JOIN whose inner table selects all constants.

DERBY-3097

FIXED

Unnecessary if statement can be removed from BaseActivation.getColumnFromNow

DERBY-3408

FIXED

Wrong message when using SHOW in ij.

DERBY-3566

FIXED

Alter column set data type not allowed in soft upgrade with unique constraint

DERBY-961

FIXED

Error 22001 can include 'XX-RESOLVE-XX' which should be removed

DERBY-3063

FIXED

Extend the system function mechanism to support functions with multiple arguments

DERBY-3731

FIXED

Improve calculation of refSize in ClassSize.java

DERBY-3981

FIXED

Improve distribution of hash codes in SQLBinary and SQLChar

DERBY-3494

FIXED

Move the setup of NormalizeResultSetNode into the NormalizeResultSetNode

DERBY-3850

FIXED

Remove unneeded workarounds for DERBY-177 and DERBY-3693

DERBY-3732

FIXED

SQL Length function materializes BLOB into memory

DERBY-3682

FIXED

SYSCS_BULK_INSERT doesn't quote identifiers or strings properly

DERBY-2085

FIXED

Misleading error message for non-matching ORDER BY clause in queries with GROUP BY.

DERBY-3798

FIXED

Remove unnecessary call to Hashtable.get() in TableScanResultSet.getNextRowCore()

All Projects : Derby : SQL (Component)

Change Log

Preset Filters

Component Summary

Open Issues