Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Inconsistent behavior of SET SESSION binlog_format='STATEMENT';

Description

Even after PXC-1144 was marked as "Fixed", behavior of SET SESSION binlog_format='STATEMENT' is inconsistent.

How to Repeat.

Suggested Fix.

Either disallow both statements, or allow them both. Current behavior worked as a workaround in 5.7 but breaks our tools in 8.0. See also PT-1699.

Environment

None

Activity

Show:

Kamil Holubicki January 25, 2023 at 2:21 PM

Yet another interesting behavior:

ROW after reconnection is OK, as this is a session variable.

Details

Assignee

Reporter

Labels

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created January 3, 2023 at 2:42 PM
Updated last week