dynamobi/dynamobi — Issue #589: [FRG-283] Calc cannot cast VARBINARY values
Author: dynamobi-build
Created: 2011-12-30 03:37:14+00:00
State: open
Labels: FRG

[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)))].

Search for Bug.FrgFixed.