db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Error using XPLAIN style tables
Date Sat, 22 May 2010 12:31:42 GMT
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


Mime
View raw message