fisql issue with float datatype [overflow error]

[glennc83]

Anyone have this issue with fisql and selecting data from a 'float' datatype?

With the float data types we get an ‘overflow’ error with some values unless we convert the column value to a decimal;

            create table RECEIPTS
  …
        unit_cost   float not null,
  …

tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds v1.5.4
freetds.conf directory: /usr/local/etc
MS db-lib source compatibility: no
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: auto
iODBC: no
unixodbc: no
SSPI "trusted" logins: no
Kerberos: no
OpenSSL: no
GnuTLS: no
MARS: yes
fisql…
Changed database context to 'TESTDB'
Changed language setting to us_english.
1>> select unit_cost from RECEIPTS where receipt_id=62873
2>> go
unit_cost

DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success

(1 rows affected)
1>> select convert(decimal(20,6), unit_cost) from RECEIPTS where receipt_id=62873
2>> go

---

2.317500

(1 rows affected)

Any thoughts on what would cause that or how to address it without the convert?

[freddy77]

It appears there's a similar issue for fisql. It looks like the computed output buffer is too small.

[glennc83]

Thanks - does this mean there will be a fix for this sometime in a future release?

[freddy77]

Yes

[freddy77]

This should fix

diff --git a/src/dblib/dblib.c b/src/dblib/dblib.c
index 1d890bdbe..da7f1ea63 100644
--- a/src/dblib/dblib.c
+++ b/src/dblib/dblib.c
@@ -3825,9 +3825,10 @@ _get_printable_size(TDSCOLUMN * colinfo)
        case SYBLONGBINARY:
        case SYBVARBINARY:
                return colinfo->column_size * 2u;
-       case SYBFLT8:
        case SYBREAL:
-               return 11;      /* FIX ME -- we do not track precision */
+               return 14;      /* FIX ME -- we do not track precision */
+       case SYBFLT8:
+               return 24;      /* FIX ME -- we do not track precision */
        case SYBMONEY4:
                return 12;
        case SYBMONEY: