-- Run only in a fresh bhylu_mysql_lab seeded from repair-seed.sql.
SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET SESSION time_zone = '+00:00';
SET SESSION lc_time_names = 'en_US';
SET @details = '[{"code":"patch","pieces":2},{"code":"hinge","pieces":1}]';
SELECT code,pieces
FROM JSON_TABLE(@details, '$[*]' COLUMNS (
  code VARCHAR(20) PATH '$.code',
  pieces INT PATH '$.pieces'
)) AS rows_from_json
ORDER BY code;
SELECT JSON_VALID('{bad') AS valid_document;