dynamobi-build
commented
12 years ago [author="jvs", created="Tue, 11 Sep 2007 19:49:24 -0500 (GMT-05:00)"]
Example from FRG-292:
0: jdbc:luciddb:> explain plan for
. . . . . . . . > select cast(1472727.2732511677 as double) from t;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| column0 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| IterCalcRel(expr#0=[{inputs}], expr#1=[1472727.2732511677], expr#2=[Reinterpret($t1)], expr#3=[CAST($t2):DOUBLE NOT NULL], expr#4=[1E10], expr#5=[/INT($t3, $t4)], EXPR$0=[$t5]) |
| FennelToIteratorConverter |
| LcsRowScanRel(table=[[LOCALDB, S, T]], projection=[[LCS_RID]], clustered indexes=[[SYS$CLUSTERED_INDEX$T$C]]) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[reporter="jvs", created="Tue, 11 Sep 2007 19:48:56 -0500 (GMT-05:00)"] Needs to be special-cased to include target type in string representation, similar to user-level CAST and NEW operators.