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

Bud — Mon, 17 Apr 2023 14:48:08 GMT

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:

(view in My Videos)

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

Bud — Fri, 21 Apr 2023 20:37:33 GMT

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

topic Re: Mobile GDB database view — CASE expression value shown incorrectly in attribute table in ArcGIS Pro Questions

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

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