db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephan van Loendersloot (LIST)" <step...@republika.nl>
Subject Re: Error using XPLAIN style tables
Date Sat, 22 May 2010 11:18:02 GMT


On 22-05-10 12:47, 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.
>
>
>
<SNIPPED rest of the message for brevity>


Well, there seems to be more:

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),

If anyone can confirm that this is a bug as well, then perhaps it's time 
to review all the column types in the XPLAIN tables.


Regards,

Stephan.


(Full stacktrace below)

2010-05-22 10:58:01.528 GMT Thread[DRDAConnThread_14,5,main] (XID = 
47807), (SESSIONID = 5), (DATABASE = testdb), (DRDAID = 
C0A80265.E591-436566414352385159{7}), Failed Statement is: insert into 
"TESTDB"."SYSXPLAIN_SCAN_PROPS"(SCAN_RS_ID,SCAN_OBJECT_NAME,SCAN_OBJECT_TYPE,SCAN_TYPE,ISOLATION_LEVEL,NO_VISITED_PAGES,NO_VISITED_ROWS,NO_QUALIFIED_ROWS,NO_VISITED_DELETED_ROWS,NO_FETCHED_COLUMNS,BITSET_OF_FETCHED_COLUMNS,BTREE_HEIGHT,FETCH_SIZE,START_POSITION,STOP_POSITION,SCAN_QUALIFIERS,NEXT_QUALIFIERS,HASH_KEY_COLUMN_NUMBERS,HASH_TABLE_SIZE)

values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) with 19 parameters begin 
parameter #1: 421e0ff1-0128-bfa8-d39a-00001421734b :end parameter begin 
parameter #2: ORDERS :end parameter begin parameter #3: T :end parameter 
begin parameter #4: HEAP :end parameter begin parameter #5: RC :end 
parameter begin parameter #6: 1254 :end parameter begin parameter #7: 
115407 :end parameter begin parameter #8: 2 :end parameter begin 
parameter #9: null :end parameter begin parameter #10: 7 :end parameter 
begin parameter #11: {1, 13, 14, 17, 18, 19, 27} :end parameter begin 
parameter #12: null :end parameter begin parameter #13: 16 :end 
parameter begin parameter #14: NULL :end parameter begin parameter #15: 
NULL :end parameter begin parameter #16: Column[0][0] Id: 18
Operator: =
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
Column[0][1] Id: 19
Operator: =
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
Column[0][2] Id: 17
Operator: =
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
Column[0][3] Id: 14
Operator: <
Ordered nulls: false
Unknown return value: true
Negate comparison result: true
Column[0][4] Id: 14
Operator: <=
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
  :end parameter begin parameter #17: NULL :end parameter begin 
parameter #18: NULL :end parameter begin parameter #19: null :end parameter
ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 
'Column[0][0] Id: 18
Operator: =
Ordered nulls: false
Unknown&' to length 512.
     at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
     at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
     at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
     at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
     at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown 
Source)
     at 
org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown 
Source)
     at 
org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
     at 
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown 
Source)
     at 
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown 
Source)
     at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
Source)
     at 
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown 
Source)
     at 
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
     at 
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
     at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
Source)
     at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown 
Source)
     at 
org.apache.derby.impl.sql.execute.xplain.XPLAINSystemTableVisitor.addArraysToSystemCatalogs(Unknown

Source)
     at 
org.apache.derby.impl.sql.execute.xplain.XPLAINSystemTableVisitor.doXPLAIN(Unknown 
Source)
     at 
org.apache.derby.impl.sql.execute.NoPutResultSetImpl.close(Unknown Source)
     at org.apache.derby.impl.sql.execute.SortResultSet.close(Unknown 
Source)
     at org.apache.derby.impl.jdbc.EmbedResultSet.close(Unknown Source)
     at org.apache.derby.impl.drda.DRDAResultSet.close(Unknown Source)
     at org.apache.derby.impl.drda.DRDAStatement.rsClose(Unknown Source)
     at org.apache.derby.impl.drda.DRDAConnThread.doneData(Unknown Source)
     at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown 
Source)
     at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown 
Source)
     at 
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
     at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed


Mime
View raw message