Microsoft ODBC bug

[Dom Latter]

On 21/06/2019 15:29, Herwin Weststrate wrote:
> 
> Out of curiosity, does -999 work, and does -1000 fail?

Yes:


(9)       Executing select query: SELECT -999
(9)       EXPAND %{sql:SELECT -999 }
(9)          --> -999
(9)       My-Int := 4294966297

(9)       Executing select query: SELECT -1000
rlm_sql_unixodbc: 22003 [Microsoft][ODBC Driver 17 for SQL 
Server]Numeric value out of range
(9)       ERROR: Error fetching row
(9)       ERROR: Unknown error
(9)       ERROR: SQL query failed: <INVALID>
(9)       EXPAND %{sql:SELECT -1000 }
(9)          -->
(9)       My-Int := 0