[
https://issues.apache.org/jira/browse/DERBY-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12870304#action_12870304
]
Stephan van Loendersloot commented on DERBY-4673:
-------------------------------------------------
Steps to reproduce:
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}.
> Error using XPLAIN style tables
> -------------------------------
>
> Key: DERBY-4673
> URL: https://issues.apache.org/jira/browse/DERBY-4673
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.6.1.0
> Reporter: Stephan van Loendersloot
> Priority: Minor
>
> 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)'.
> After digging in the Derby code I found the following in
> org.apache.derby.diag.ErrorLogReader
> EmbedResultSetMetaData.getResultColumnDescriptor("DRDAID", Types.VARCHAR,
> true, 50),
> However, I also found the following in
> org.apache.derby.impl.sql.catalog.XPLAINStatementDescriptor
> SystemColumnImpl.getColumn("DRDA_ID", Types.CHAR, true, 32),
> Another error in the XPLAIN tables is the following:
> ERROR 22001: A truncation error was encountered trying to shrink VARCHAR
> 'Column[0][0] Id: 18
> Operator: =
> Ordered nulls: false
> Unknown&' to length 512.
> This time, it's the SYSXPLAIN_SCAN_PROPS table
> (org.apache.derby.impl.sql.catalog.XPLAINScanPropsDescriptor):
> SystemColumnImpl.getColumn("SCAN_QUALIFIERS", Types.VARCHAR, true, 512),
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
