
|
If you were logged in you would be able to see more operations.
|
|
|
Farrago
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
|
|
|
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.
|
|
Description
|
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. |
Show » |
| There are no comments yet on this issue.
|
|