Hi all,

A few weeks ago I posted a question about a potential defect in Oracle 11g. Today I have more details on the error.

Please contact me if you are an Oracle Support engineer, I will like to follow up directly.

The first Query 1 returns the correct value
SELECT SUM(t.debitmst) 270
FROM
(
SELECT
SUBSTR(nls_lowe r(ledgeraccount num), 1, 21) as account_substr,...