dynamobi/dynamobi — Issue #474: [FNL-34] Fennel calc does not support FLOOR(INTEGER)
Author: dynamobi-build
Created: 2011-12-30 03:28:42+00:00
State: open
Labels: Calc, FNL

[reporter="jvs", created="Tue, 2 May 2006 18:23:53 -0500 (GMT-05:00)"]
Given the nature of FLOOR, this is rather understandable.

0: jdbc:farrago:> alter system set "calcVirtualMachine"='CALCVM_FENNEL';

No rows affected (0.204 seconds)

0: jdbc:farrago:> values (floor(10));

Error: java.lang.AssertionError: Internal error: node could not be implemented: Subset#1.ITERATOR (state=,code=0)

0: jdbc:farrago:> values (floor(10.0));

+---------+

| EXPR$0 |

+---------+

| 10 |

+---------+

1 row selected (2.271 seconds)

0: jdbc:farrago:> alter system set "calcVirtualMachine"='CALCVM_JAVA';

No rows affected (0.034 seconds)

0: jdbc:farrago:> values (floor(10));

+---------+

| EXPR$0 |

+---------+

| 10 |

+---------+

1 row selected (0.348 seconds)

0: jdbc:farrago:> values (floor(10.0));

+---------+

| EXPR$0 |

+---------+

| 10 |

+---------+

1 row selected (0.442 seconds)

0: jdbc:farrago:>