Will this driver trigger the seng long data protocol

[deskau]

Will this driver trigger the seng long data protocol. If possible, could you provide an example code to take a look at?

[sidorares]

Are you referring to https://dev.mysql.com/doc/dev/mysql-server/9.1.0/page_protocol_com_stmt_send_long_data.html ?

This driver currently does not support it, relatively easy to implement though.

Example golang driver with this feature: https://github.com/bketelsen/GoMySQL/blob/9d271105c498f4513ae6e85ea1b36ec4b835d50a/mysql_statement.go#L126-L160

If somebody wants to add support, some steps as I see it:

• add COM_STMT_SEND_LONG_DATA packet serialisation/deserealisation
• figure out limits for a "standard" COM_STMT_EXECUTE parameters maximum size
• add a field to statement object to track bound parameters.
• update connection.execute() to check the size of supplied parameters array, for all parameters that are too big for a "regular" com_stmt_execute send them using COM_STMT_SEND_LONG_DATA packets and mark as bound, then send com_execute as per usual except using NULL values for long parameters sent earlier
• potentially add public api form manual stmt = await connection.prepare() / stmt.sendLongData(paramId, value) / stmt.execute(params)

( maybe add a field to statement object to track bound parameters. actually is not needed )

[deskau]

Thank you for your reply and guidance