Microsoft ODBC bug

[Arran Cudbard-Bell]

> On Jul 25, 2019, at 9:04 PM, Dom Latter <freeradius-users at latter.org> wrote:
> 
> On 21/06/2019 13:30, Dom Latter wrote:
>> Executing select query: SELECT 10000
>> rlm_sql_unixodbc: 22003 [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range
> 
> To recap - using rlm_sql_unixodbc to connect to SQL Server had the
> weird bug that any number more than four digits long was "out of
> range".
> 
> Now I have used rlm_sql_unixodbc to connect to freetds and thence
> to SQL Server.  It works (having had to rename my radius database
> to "Sample" because that is what it was looking for despite me
> not having "Sample" anywhere in the configuration) but this time
> numbers more than four digits long are simply truncated:
> 
> 
> (24)       EXPAND %{sql:SELECT 123456 }
> (24)          --> 1234
> 
> (24)       EXPAND %{sql:SELECT '123456' }
> (24)          --> 123456
> 
> (24)       EXPAND %{sql:SELECT CAST(123456 as varchar) }
> (24)          --> 123456
> 
> All very strange.

Seems like a legitimate issue.  Could you open something on GitHub so it gets tracked.

Thanks,
-Arran

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190726/49d098c0/attachment.sig>