{"issue":{"milestone":null,"title":"[FRG-204] cast from nullable DOUBLE to INT truncates instead of rounding","created_at":"2011-12-30T03:42:18Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"FRG","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/FRG","color":"1f8f0d"},{"name":"Java Calc Codegen","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/Java+Calc+Codegen","color":"4e8b6b"}],"updated_at":"2011-12-30T03:42:18Z","state":"open","id":2686198,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"closed_at":null,"html_url":"https://github.com/dynamobi/dynamobi/issues/668","body":"<b><i>[reporter=\"jvs\", created=\"Tue, 12 Sep 2006 13:18:01 -0500 (GMT-05:00)\"]</i></b>\n0: jdbc:farrago:> !run test.sql<br/>\n1/13 create schema anil;<br/>\nNo rows affected (0.076 seconds)<br/>\n2/13<br/>\n3/13 create table anil.t3(<br/>\ni int not null primary key,<br/>\nd1 double,<br/>\nd2 double not null,<br/>\nn1 numeric(10,2),<br/>\nn2 numeric(10,2) not null<br/>\n);<br/>\nNo rows affected (0.556 seconds)<br/>\n4/13<br/>\n5/13 insert into anil.t3 values (1, 9.6, 9.6, 9.6, 9.6);<br/>\n1 row affected (0.722 seconds)<br/>\n6/13<br/>\n7/13 alter system set \"calcVirtualMachine\"='CALCVM_JAVA';<br/>\nNo rows affected (0.018 seconds)<br/>\n8/13<br/>\n9/13 select cast(d1 as int), cast(d2 as int), cast(n1 as int), cast(n2 as int)<br/>\nfrom anil.t3;<br/>\n+---------+---------+---------+---------+<br/>\n| EXPR$0  | EXPR$1  | EXPR$2  | EXPR$3  |<br/>\n+---------+---------+---------+---------+<br/>\n| 9       | 10      | 10      | 10      |<br/>\n+---------+---------+---------+---------+<br/>\n1 row selected (0.322 seconds)<br/>\n10/13<br/>\n11/13alter system set \"calcVirtualMachine\"='CALCVM_FENNEL';<br/>\nNo rows affected (0.036 seconds)<br/>\n12/13<br/>\n13/13select cast(d1 as int), cast(d2 as int), cast(n1 as int), cast(n2 as int)<br/>\nfrom anil.t3;<br/>\n+---------+---------+---------+---------+<br/>\n| EXPR$0  | EXPR$1  | EXPR$2  | EXPR$3  |<br/>\n+---------+---------+---------+---------+<br/>\n| 10      | 10      | 10      | 10      |<br/>\n+---------+---------+---------+---------+<br/>\n1 row selected (0.199 seconds)<br/>\n","number":668,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/668","comments":0,"assignee":null},"action":"opened"}