New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

fisql: throws "Requested data conversion does not exist" for sql_variant columns #484

Open

jnahmias opened this issue Mar 2, 2023 · 0 comments

jnahmias commented Mar 2, 2023

Using freetds 1.3.17+ds-2 on Debian GNU/Linux connected to MS SQL Server 2016.
Some test cases:

$ fisql -S $DB_HOSTNAME -U $DB_USERNAME -P $DB_PASSWORD
Changed database context to 'tempdb'.
Changed language setting to us_english.
1>> SELECT CONNECTIONPROPERTY('net_transport') AS protocol;
2>> GO
protocol
--------
DB-LIBRARY error:
        Requested data conversion does not exist
Operating-system error:
        Success
--------

(1 rows affected)

$ fisql -S $DB_HOSTNAME -U $DB_USERNAME -P $DB_PASSWORD
Changed database context to 'tempdb'.
Changed language setting to us_english.
1>> SELECT CAST( 'hello' AS sql_variant ) AS test2;
2>> GO
test2
-----
DB-LIBRARY error:
        Requested data conversion does not exist
Operating-system error:
        Success
-----

(1 rows affected)

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment