can not insert more than 32270 charakters in long varchar, clob

• Key: DERBY-102
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Critical
• Assignee: Unassigned
• Reporter: rainer garbotz
• Component/s: Documentation
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.1.1.0

Description

I have created an table with

create table egal (
text long varchar
);

Now I try to insert an 38000 charakters long String.

insert into egal values ('
......
');

But there are following error message:

ERROR 54002: A string constant starting with ''
ddddddddddddddddddddddddddddddddddddddddddddddddddddddddd&' is too long.

I tryed the same with CLOB, but the same error occures.

The "Reference Manual" says to LONG VARCHAR:
"The LONG VARCHAR type allows storage of character strings of unlimited length"

Have I missunderstood this, or is this a BUG.

Thanks

Rainer