Adapter is returning hidden columns

[rafiss]

Environment Information

CRDB Version

v24.2, v24.3, v25.1

Adapter version

7.2.0

Cluster Configuration & Hardware details (include all relevant info; multi-region, leaseholder preferences, hardware specs, etc)

Table with hidden columns in index, such as a REGIONAL BY ROW table or a hash-sharded index.

Summary

What problem has the customer reported?

A customer reported that the activerecord adapter is returning hidden columns now that they have attempted to execute against 24.2 and later versions (reporting encountering the issue on 24.2 originally, rolling back, and recently reporting it being an issue on 24.3 and 25.1).

Note that CRDB v24.2 includes this change:

The pg_catalog.pg_attribute table now has a column named attishidden, which indicates if the table column or attribute is NOT VISIBLE. #126397

#311 and #345 appear to be related PRs.

• fix(schema_statements): add unique_rowid to pk_and_sequence_for #311 appears in the v7.2.0 and v8.0.0 tags.
• fix: handle indexes with a hidden compound #345 appears in the v8.0.0 tag.

The customer provided an example to reproduce the issue: grantpaulson6/bugreproduced#1

Resolution criteria

The example should succeed.

It seems possible that we may need to backport #345 to the 7.2 branch.

[BuonOmo]

@rafiss actually #368 already includes the correct commit. So it is just a matter of merging and publishing! In the mean time, they could use the PR branch in their gemfile (backport-364-to-7-2)

[rafiss]

Thank you! I have just merged that and published the gem.