Rails 7 insert data in table in different schema fails about activerecord-sqlserver-adapter HOT 7 CLOSED

looking at database_statements.rb :

       def query_requires_identity_insert?(sql)
          if insert_sql?(sql)
            table_name = get_table_name(sql)
            id_column = identity_columns(table_name).first

get_table_name() will return the table name WITHOUT database/schema
so schema_cache will look for the table in the default schema 'dbo' where this not exist

from activerecord-sqlserver-adapter.

Possible fix: In database_statements.rb:query_requires_identity_insert?

change

table_name = get_table_name(sql)

to

table_name = get_raw_table_name(sql)

but then a test is failing:

Failure:
AdapterTestSQLServer::identity inserts#test_0001_return quoted table_name to #query_requires_identity_insert? when INSERT sql contains id column [/home/klaus/Projekte/activerecord-sqlserver-adapter/test/cases/adapter_test_sqlserver.rb:202]:
Expected: "funny_jokes"
  Actual: "[funny_jokes]"

Strange: the test is named return_QUOTED_table_name but is testing for the unquoted name...

from activerecord-sqlserver-adapter.

I have run into the exact same issue,
Inserts into a different database fail.

my current workaround is to create a table in the main database with the same name.

from activerecord-sqlserver-adapter.

I have also run into this issue using gem 'activerecord-sqlserver-adapter', '7.0.1.0' with ruby 3.2.1 and rails 7.0.4.2.
Is there anyone looking into a permanent fix ?
Thanks

from activerecord-sqlserver-adapter.

I just ran into this on activerecord-sqlserver-adapter 7.0.1.0

from activerecord-sqlserver-adapter.

I patched as suggested by KDGundermann, Im quite surprised this has been sitting around for so long.

from activerecord-sqlserver-adapter.

Issue has been fixed in release v7.0.2.0

from activerecord-sqlserver-adapter.