Incorrect record summary displayed after editing a FK cell which references a non-PK cell

[seancolsen]

Steps to reproduce

1. Begin with the following sample data:

   drop table if exists products cascade;
   create table products (
     id int primary key generated always as identity,
     qr_code uuid default gen_random_uuid() unique,
     name text not null
   );
   insert into products (name) values ('table'), ('chair');
   
   drop table if exists reviews;
   create table reviews (
     id int primary key generated always as identity,
     product uuid references products (qr_code),
     notes text
   );
   insert into reviews (product, notes) values
   ((select qr_code from products where name = 'table'), 'Awesome');

2. Open the reviews table page

   

3. Edit the product cell, selecting the "chair" record

   

4. Expect to see a record summary of "chair"

   

5. Instead, observe a UUID record summary

   

6. Click the Refresh button inside Mathesar, and observe a record summary of "chair" as expected.