You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
returns correct results in MSSQL, but returns empty results in Babelfish.
This query is likely originates from mssql-jdbc implementation of JDBC getTables method. Empty result from sp_tables call does not allow table introspection to work.
Note, that @table_type parameter to sp_tables in this case is quote-escaped twice by the client app. Normal single quote-escaping works correctly in Babelfish:
The following query (taken from real-life application):
returns correct results in MSSQL, but returns empty results in Babelfish.
This query is likely originates from mssql-jdbc implementation of JDBC getTables method. Empty result from
sp_tables
call does not allow table introspection to work.Note, that
@table_type
parameter to sp_tables in this case is quote-escaped twice by the client app. Normal single quote-escaping works correctly in Babelfish:The text was updated successfully, but these errors were encountered: