search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
53 stars 24 forks source link

[FRG-12] JDBC and SQL data type conversions are inconsistent #858

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="angel", created="Tue, 27 Dec 2005 20:06:26 -0500 (GMT-05:00)"] The conversion routines are inconsistent in the JDBC and SQL implementations.
For instance, when converting double/real types to the integral types:
In SQL: cast from double to integer is done using rounding
               (rounding away from 0 when the value is at the midpoint, i.e 1.5->2, -1.5->-2)
in JDBC: conversion routines truncate

There may be other inconsistencies as well.

For consistency, the JDBC conversion routines (getXXX, setXXX) should be fixed to have the same behavior as casting in SQL. See IteratorResultSet's toLong, etc. FarragoJdbcTest should be updated accordingly.

dynamobi-build commented 12 years ago

[author="angel", created="Tue, 16 May 2006 21:28:24 -0500 (GMT-05:00)"] JDBC get and set functions also does rounding now