On 05/22/10 12:47 PM, Stephan van Loendersloot (LIST) wrote:
> Hello everyone,
>
>
> While trying the new Derby release (10.6.1.0), I ran into the following
> error using XPLAIN style tables:
>
> ERROR 22001: A truncation error was encountered trying to shrink CHAR
> 'C0A80265.A193-436003464463927241{25}' to length 32.
>
> (Full stack trace is at the end of this message)
>
> The culprit seems to be that the table SYSXPLAIN_STATEMENTS is created
> with a column 'DRDA_ID CHAR(32)'.
>
[...]
> Can anyone confirm that this is a bug? If so, I'll open up a JIRA issue.
>
Hi Stephan,
I see this problem too:
ij> connect 'jdbc:derby://localhost/db;create=true';
ij> call syscs_util.syscs_set_runtimestatistics(1);
Statement executed.
ij> call syscs_util.syscs_set_xplain_schema('MY_STATS');
Statement executed.
ij> select count(*) from sys.systables;
ERROR 22001: A truncation error was encountered trying to shrink {0} '{1}' to
length {2}.
Looks like a bug to me, so please open a JIRA issue so that we can track it.
Thanks,
--
Knut Anders
