EC
3173
MariaDBWARNINGCriticalWindow FunctionsMEDIUM confidence

Window function details available in EXPLAIN FORMAT=JSON

Production Risk

Low — informational only; no query impact.

What this means

This informational message indicates that EXPLAIN output for a query with window functions is best viewed in JSON format, which provides more detailed window execution information than the traditional tabular format.

Why it happens
  1. 1Running EXPLAIN on a query that uses window functions.
How to reproduce
trigger — this will error
trigger — this will error
EXPLAIN SELECT ROW_NUMBER() OVER (ORDER BY id) FROM t1;

expected output

Warning (Code 3173): Window function details available in EXPLAIN FORMAT=JSON.

Fix

Use EXPLAIN FORMAT=JSON for window function queries

Use EXPLAIN FORMAT=JSON for window function queries
EXPLAIN FORMAT=JSON SELECT ROW_NUMBER() OVER (ORDER BY id) FROM t1;

Why this works

JSON format exposes window sorting, framing, and buffer details.

Sources
Official documentation ↗

MySQL 8.0 — 3173 ER_WINDOW_EXPLAIN_JSON

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors