citext Postgres extension columns display as [Object object] in SQL Runner

[cole_elliott]

We’re now on Looker 7.8.19, and are now noticing that when querying columns of the citext Postgres extension type in SQL Runner, that the default table visualization in SQL Runner displays those values as [Object object], rather than their correct, textual values.

This only happens in SQL Runner; querying the same columns in their respective Explores displays the values correctly as you’d expect.

The citext Postgres extension is definitely enabled (as evidenced, too, by the fact the Explores display those citext values correctly), so that isn’t the culprit.

While we haven’t reverted our Looker version to prove this, we are fairly confident that this is a new bug as we are pretty confident we’ve queried these citext columns in SQL Runner successfully before without this behavior.

I’ve categorized this is as a bug, but if it isn’t and there’s some updated configuration or something that we’re missing on our end, then just let us know 👍