[reporter="jhyde", created="Sun, 15 Jul 2007 14:45:30 -0500 (GMT-05:00)"]
Fennel calc cannot cast VARBINARY values. For example,
VALUES (CAST(x'ABCDEF12' AS VARBINARY(2)))
should return the VARBINARY string 'ABCD', but gives
Optimizer failed to find a valid physical implementation for relational expression rel#104:CalcRel.NONE(child=HepRelVertex#107,expr#0={inputs},expr#1=X'ABCDEF12',expr#2=CAST($t1):VARBINARY(2) NOT NULL,EXPR$0=$t2); see trace for partially optimized plan. Details: reason is [Node's traits (NONE) do not match required traits (ITERATOR)]; while preparing statement [values (CAST(x'ABCDEF12' AS VARBINARY(2)))].
[reporter="jhyde", created="Sun, 15 Jul 2007 14:45:30 -0500 (GMT-05:00)"] Fennel calc cannot cast VARBINARY values. For example,
Fixed.
VALUES (CAST(x'ABCDEF12' AS VARBINARY(2)))
should return the VARBINARY string 'ABCD', but gives
Optimizer failed to find a valid physical implementation for relational expression rel#104:CalcRel.NONE(child=HepRelVertex#107,expr#0={inputs},expr#1=X'ABCDEF12',expr#2=CAST($t1):VARBINARY(2) NOT NULL,EXPR$0=$t2); see trace for partially optimized plan. Details: reason is [Node's traits (NONE) do not match required traits (ITERATOR)]; while preparing statement [values (CAST(x'ABCDEF12' AS VARBINARY(2)))].
Search for Bug.Frg