Confirmed MySQL API bug

Schema & Data
1

image
image1140×621 59 KB

One of the booleans is flipped in the returned JSON. “yes” field is virtual. Screenshot shows the API tester in the DreamFactory admin panel and phpMyAdmin for the same table opened at the same time.
This is a simple table for a COVID-19 screening questionnaire. Naturally, having negative symptoms become positive as a result of a bug is a concern.

Not sure what I can post to narrow down this bug in the DreamFactory framework

2

I have found that if I rename the table to something else the flipped boolean problem goes away. Same table, different name. “screening” is the table name DreamFactory API has the trouble with.