Assert failure when concatenating strings with total size greater than 32K
--------------------------------------------------------------------------

                 Key: DERBY-4793
                 URL: https://issues.apache.org/jira/browse/DERBY-4793
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.6.1.0
            Reporter: Knut Anders Hatlen
         Attachments: concat.sql

When concatenating two strings whose total length exceeds the maximum length 
for a VARCHAR, an assert is triggered in the debug jars:

ij> values length('0123456789.....' || '0123456789.....');
ERROR XJ001: Java exception: 'ASSERT FAILED The maximum length 35000 for the 
result type VARCHAR can't be greater than it's maximum width of result's 
typeid32672: org.apache.derby.shared.common.sanity.AssertFailure'.

With non-debug jars, the same query completes successfully:

ij> values length('0123456789.....' || '0123456789.....');
1          
-----------
35000      

1 row selected

I think this query is supposed to fail, also with non-debug jars, but in any 
even it shouldn't be raising assert failures.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to