ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near '0'

[aet08]

Issue

irb(main):001:0> UserT.count
SQL (4.9ms) USE [GenDB]
(5.5ms) SELECT COUNT(*) FROM [UserT]
=> 2

irb(main):003:0> UserT.first
UserT Load (9.6ms) EXEC sp_executesql N'SELECT [UserT].* FROM [UserT] OFFSET 0 ROWS FETCH NEXT @0 ROWS ONLY', N'@0 int', @0 = 1 [["LIMIT", nil]]
ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near '0'.: EXEC sp_executesql N'SELECT [UserT].* FROM [UserT] OFFSET 0 ROWS FETCH NEXT @0 ROWS ONLY', N'@0 int', @0 = 1
from (irb):3

Expected behavior

Should return first record for UserT

Actual behavior

UserT Load (9.6ms) EXEC sp_executesql N'SELECT [UserT].* FROM [UserT] WHERE [UserT].[id] = @0', N'@0 int', @0 = 1 [["id", nil]]
ActiveRecord::StatementInvalid: TinyTds::Error: Invalid column name 'id'.: EXEC sp_executesql N'SELECT [UserT].* FROM [UserT] WHERE [UserT].[id] = @0', N'@0 int', @0 = 1
from (irb):3

How to reproduce

Details

• Rails version: 5.2.4.3

• SQL Server adapter version: x.x.x

• TinyTDS version: x.x.x

• FreeTDS details:

Compile-time settings (established with the "configure" script)
Version: freetds v1.00.82
freetds.conf directory: /etc/freetds
MS db-lib source compatibility: no
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: 4.2
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: yes
OpenSSL: no
GnuTLS: yes
MARS: no

[aidanharan]

Unable to recreate the issue. Could you provide a test case (https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/tree/main/test/cases) or more information on the issue?