Mobile GDB database view — CASE expression value shown incorrectly in attribute table

[Bud]

ArcGIS Pro 3.1.1; Mobile Geodatabase

I have a table called TEST_TBL:

I can create a view on the table like this, using the Create Database View GP tool:

select 
    text_field,
    case when text_field = 'a' then 'a' end as case_test
from 
    test_tbl

The resultset ought to look like this (DBeaver SQL Client):

But instead, the attribute table in ArcGIS Pro looks like this:

The value in the CASE_TEST field is incorrect. It should be 'a', but is being displayed as '1899-12-30'.

Why is that calculated CASE field being displayed incorrectly?

Video:

[Bud · Accepted solution]

Esri Case #03318355 - Mobile GDB database view — CASE expression value shown incorrectly in attribute table

BUG-000157736: Create Database View geoprocessing tool returns incorrect data when SQL CASE expression returns a text value in the View Definition parameter