You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2010/11/12 14:23:14 UTC
[jira] Updated: (DERBY-4673) Error using XPLAIN style tables
[ https://issues.apache.org/jira/browse/DERBY-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristian Waagan updated DERBY-4673:
-----------------------------------
Affects Version/s: 10.7.1.0
Fix Version/s: 10.7.1.0
10.6.2.3
Assignee: Kristian Waagan
> Error using XPLAIN style tables
> -------------------------------
>
> Key: DERBY-4673
> URL: https://issues.apache.org/jira/browse/DERBY-4673
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0, 10.7.1.0
> Reporter: Stephan van Loendersloot
> Assignee: Kristian Waagan
> Priority: Minor
> Fix For: 10.6.2.3, 10.7.1.0
>
>
> 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.