Drizzle Team•11mo ago

Issue with AWS RDS Data API + magic sql operator + db.execute

Hi there! I am trying to use drizzle's magic sql operator + db.execute() for a fairly complex query (using WITH RECURSIVE, etc.) with the AWS Data API and am running into an issue where it seems like the parameterized query being sent in to the DATA API is not being consumed correctly. I have a WHERE clause that's matching on a uuid and the error I'm getting make it seem like the Data API isn't even trying to use the parameters:

"errorType":"DatabaseErrorException","errorMessage":"ERROR: invalid input syntax for type uuid: \":1\"; Position: 103; SQLState: 22P02"

"errorType":"DatabaseErrorException","errorMessage":"ERROR: invalid input syntax for type uuid: \":1\"; Position: 103; SQLState: 22P02"

Has anyone run into a similar issue with the Data API?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Issue with AWS RDS Data API + magic sql operator + db.execute