db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DERBY-4673) Error using XPLAIN style tables
Date Fri, 12 Nov 2010 13:27:15 GMT

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

Kristian Waagan resolved DERBY-4673.
------------------------------------

    Resolution: Duplicate

Marking as duplicate.

> 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.


Mime
View raw message