In MysqlConnection, this is how you check the amou...

# jasync-sql

[dave08]

In MysqlConnection, this is how you check the amount of params

val totalParameters = params.query.count { it == '?' }

I guess it's the same in postgres, where really it should be a regex to make sure that the ? is not surrounded by quotes.

[oshai]

yes, it's pretty simplistic. we dont really parse the request

[oshai]

can you open an issue for that?

[dave08]

Sure

[dave08]

https://github.com/jasync-sql/jasync-sql/issues/217

[dave08]

I guess there isn't really any workarounds for this 🙈?

[dave08]

At least until it gets fixed...

[oshai]

the workaround is to use query instead of prepared statement

[oshai]

the fix will probably be a simpler check. I don't want to compile the expression

[dave08]

I don't know how much you'll save from a simpler check... compiling the expression is only once per connection creation.

[dave08]

You might want to benchmark the difference between the "simpler" algorithm (using a biggish/complex sql statement) and the regex version

[oshai]

do you know how to compile it?

[oshai]

can you try double question marks?
https://github.com/jasync-sql/jasync-sql/issues/196

[dave08]

It does't really make sense that ?? should help, but we can try...

[dave08]

params.query.count { it == '?' } should report two extra ? instead of one...

[dave08]

It does work though 🤔...

[dave08]

Oh... the implementation of Mysql's PreparedStatementHolder is different.