[EXTERNAL] Re: Microsoft ODBC bug

[Winfield, Alister]

Last time I saw this kind of behaviour it was down the 'SQL' err great decisions on how to assign a type to literals. Normally it can use the type of a field in a table to get it right but here.... not so much. I suspect the ODBC library might have an API to define what that default type is and that is something daft unless otherwise told.


On 25/06/2019, 14:14, "Freeradius-Users on behalf of Dom Latter" <freeradius-users-bounces+alister.winfield=sky.uk at lists.freeradius.org on behalf of freeradius-users at latter.org> wrote:

    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


    -
    List info/subscribe/unsubscribe? See https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeradius.org%2Flist%2Fusers.html&data=02%7C01%7Calister.winfield%40sky.uk%7C591e8afef22e4842cbd908d6f96f0339%7C68b865d5cf184b2b82a4a4eddb9c5237%7C0%7C1%7C636970652526764199&sdata=GsvKBvLsM6vLUXu%2Buzoqu%2BDfvlwdrqhYQp6fXzxWSWc%3D&reserved=0
    --------------------------------------------------------------------
    This email is from an external source. Please do not open attachments or click links from an unknown or suspicious origin. Phishing attempts can be reported by sending them to phishing at sky.uk as attachments. Thank you
    --------------------------------------------------------------------



Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky Limited and Sky International AG and are used under licence.

Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075), Sky Subscribers Services Limited (Registration No. 2340150) and Sky CP Limited (Registration No. 9513259) are direct or indirect subsidiaries of Sky Limited (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD