First, a big thank you for this fantastic project and all the work that has clearly been put into it. It is very much appreciated.
Describe the bug
Running certain queries does not behave the same in local-data-api as in a real AWS Aurora Serverless environment via the data-api.
local-data-api sets the postgres JDBC connection parameter stringtype
to unspecified
here, however AWS data-api simply uses the default of VARCHAR
. The postgres docs describe the operation of the stringtype
parameter here.
To Reproduce
Steps to reproduce the behavior:
It works.
BadRequestException: Database error code: 0. Message: ERROR: column "id" is of type uuid but expression is of type character varying
I can try to generate some http requests you can quickly run directly as a test / proof if that would be helpful.
Expected behavior
To the extent possible local-data-api should behave the same as the real AWS data-api
Additional context
This divergence was introduced in PR#108, which seems to have been done at least in part as a fix for #106. @koxudaxi references this exact problem in this comment where they note that local-data-api behaves differently than the real AWS data-api.
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
You're funding impactful open source efforts
You want to contribute to this effort
You want to get funding like this too