Postgresql returning java class (not string) for uuids in query results

+1

Thanks for helping test . I’ve never actually used an Inet column, I took the information for that from this unit test in the Postgres JDBC source code in which it appeared to operate the same as UUID

It’s possible the JDBC result object only gives back a proper UUID when you call getObject() like so:

I’m just not sure of the Postgres specifics.

That said, I do think testing should be paused on this ticket because IMO it shouldn’t have even been merged yet! There was an in progress discussion between , myself, and others about whether this pull even had the logic in the proper place, or if it should actually be part of the caster. came in and hit “merge”, apparently without seeing the in-progress discussion.

After thinking on it and taking into account Igal’s input plus some new findings on how Adobe ColdFusion operates, I’m not convinced the pull was the proper way to do it anyway. I really think that discussion should be resolved before we get way ahead of ourselves testing a fix that was still being discussed!

I've checked this ticket with the lucee latest build 6.0.0.141-SNAPSHOT. The UUID type value comes as strings in the query. But inet type values still come as java object( org.postgresql.util.PGobject ) instead of a string.