Prepared statement error on varchar array columns

[shaunma]

Version 7.2 of the adapter seems to reject ? = ANY(array_column) queries.

Steps to Reproduce:

Install and run CockroachDB v25.1.2 locally.
Create a Rails application using the following packages.

gem 'activerecord-cockroachdb-adapter', '~> 7.2'
gem 'rails', '~> 7.2.2'

Create a table containing a column containing a string array using the following script:

class AddUsers < ActiveRecord::Migration[7.2]
  def change
    create_table :users do |t|
      t.string :languages, array: true
    end
  end
end

Complete the migration. Open Rails console and run: User.where('? = ANY(languages)', 'en').

This error is raised:
#<ActiveRecord::StatementInvalid:"PG::IndeterminateDatatype: ERROR: could not determine data type of placeholder $1\nHINT: consider adding explicit type casts to the placeholder arguments\n">

I am able to run select * from users where 'en' = ANY (languages) directly in CockroachDB, so I think that the error is caused by the driver.

The same statement runs without issues on Postgres 12.

[BuonOmo]

Hi @shaunma, thanks for reporting!

We don't have yet any coverage for CRDB 25.1, especially with rails 7.2. I've opened a PR (#372) for CRDB 25 + rails 8 to see if there are errors. If so I think we'll fix this and then consider backporting. WDYT @dikshant?

[dikshant]

Thanks @BuonOmo, your approach sounds good to me!

[shaunma]

Hi @BuonOmo and @dikshant, for what it's worth, I was able to reproduce this error using the most recent Rails and adapter versions (8.0.2 and 8.0.1 respectively) on CockroachDB v24.3.8.

EDIT: it looks like the underlying cause is cockroachdb/cockroach#41558. For now, I can work around it by typing the placeholder (i.e., User.where('?::text = ANY(languages)', 'en')). Feel free to close this issue.