History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FRG-283
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: John V. Sichi
Reporter: Julian Hyde
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Farrago

Calc cannot cast VARBINARY values

Created: 15/Jul/07 02:45 PM   Updated: 15/Jul/07 02:45 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
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.Frg<this issue>Fixed.

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.