FGDB — Join from table to database view: Join fields are null

[Bud]

ArcGIS Pro 3.1.1; file geodatabase

I have a FGDB table called TEST_TABLE.

I've created a database view on the table called TEST_TABLE_NT_FLAG_VW:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table 

I've opened the table in the map and created a join via the OBJECTID.

Result:

The join didn't work. The join fields are null in the attribute table:

Video:

Question:

Why are the join fields blank in the FGDB join?

I don't have that problem in mobile or enterprise geodatabases.

[Bud · Accepted solution]

Esri Case #03335352 - FGDB — Join from table to database view: Join fields are null

BUG-000158140: ArcGIS Pro: Join from table to database view generate Join fields with null values