Skip to content

Unable to parse multi-statements command with SET statement #5233

@W1zzardTPU

Description

@W1zzardTPU

ProxySQL 3.0.3 + .NET 9 + EF Core + Pomelo MySQL (+ Group Replication if that matters)

I'm getting "Unable to parse multi-statements command with SET statement"

The reported queries all have SELECT ROW_COUNT() at the end:

UPDATE setting SET value = '3.5' WHERE setting_id = 'foo'; SELECT ROW_COUNT();

I tried setting mysql-multiplexing=false, but the warning still appears.

Not sure if that's a reasonable ask: but can't proxsql detect this query combination and disable multiplexing + routing for the query, which it probably already does? so no need to log a warning?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions