[RoR] mssql adapter and set_primary_key problem

ruby-talk
1

For mssql adapter I cannot change primary key. The following code does not
work :frowning:

class Demo < ActiveRecord::Base
  set_table_name "MojaTabela"
  set_primary_key "IdMojejTabeli"
end

Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      Invalid column name 'id'.
    HRESULT error code:0x80020009
      Exception.: SELECT * FROM ( SELECT TOP 9 * FROM ( SELECT TOP 9 * FROM
MojaTabela ) AS tmp1 ORDER BY id DESC ) AS tmp2 ORDER BY id ASC

The error exception appears for mode ADO and for mode ODBC. Something wrong
is here. I tried to ask on irc rubyonrails channel but nobody said any
word. Mysql adapter works fine. Only mssql adapter has problem.

···

--
JZ