[jira] Closed: (DERBY-4673) Error using XPLAIN style tables

["Kristian Waagan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan closed DERBY-4673.
----------------------------------


Closing issue.

> 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.1
>            Reporter: Stephan van Loendersloot
>            Assignee: Kristian Waagan
>            Priority: Minor
>             Fix For: 10.6.2.3, 10.7.1.1
>
>
> 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.