travishaby
travishaby
PostsComments
DTDrizzle Team
Created by travishaby on 2/13/2024 in #help
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?
1 replies