dynamobi/dynamobi — Issue #148: [LDB-174] push projection below converter
Author: dynamobi-build
Created: 2011-12-30 02:16:57+00:00
State: open
Labels: LDB, Optimizer

[reporter="jvs", created="Mon, 21 Apr 2008 13:31:34 -0500 (GMT-05:00)"]
create schema z;

create table z.t(i int, j int);

explain plan for

select i,crc_value from

(select * from table(applib.generate_crc(cursor(select * from z.t))))

order by i;

'column0'

'FennelToIteratorConverter'

' FennelSortRel(key=[[0]], discardDuplicates=[false])'

' FennelReshapeRel(projection=[[0, 2]], outputRowType=[RecordType(INTEGER I, BIGINT CRC_VALUE) NOT NULL])'

' IteratorToFennelConverter'

'FarragoJavaUdxRel(invocation=[CAST(GENERATE_CRC(CAST($0):CURSOR)):RecordType(INTEGER I, INTEGER J, BIGINT CRC_VALUE) NOT NULL])'

' FennelToIteratorConverter'

' LcsRowScanRel(table=[[LOCALDB, Z, T]], projection=[*], clustered indexes=[[SYS$CLUSTERED_INDEX$T$I, SYS$CLUSTERED_INDEX$T$J]])'