Release notes

This release is mainly a bug fix release. It also includes an important security fix for users using output plugins.

Changes

Bug Fixes

• (docker) Use distroless base image instead of scratch (fix(docker): Use distroless instead of scratch #3111 )
• (generate) Ensure files are created inside output directory (fix(generate): First pass at fixing path traversal vuln #3195 )
• (mysql) BREAKING: Use int16 for MySQL SMALLINT and YEAR (fix(codegen/golang): Use int16 for MySQL SMALLINT and YEAR #3106 )
• (mysql) BREAKING: Use int8 for MySQL TINYINT (fix(codegen/golang): Use int8 for MySQL TINYINT #3298 )
• (mysql) Variables not resolving in ORDER BY statements (fix variables not resolving in mysql ORDER BY statements #3115 )
• (opts) Validate SQL package and driver options (fix(opts): Validate SQL package and driver options #3241 )
• (postgres/batch) Ignore query_parameter_limit for batches
• (scripts) Remove deprecated test output regeneration script (fix(scripts): Remove test output regeneration script #3105 )
• (sqlite) Correctly skip unknown statements (fix(sqlite): Correctly skip unknown statements #3239 )

Documentation

• (postgres) Add instructions for PostGIS/GEOS (docs: Add instructions for PostGIS/GEOS #3182 )
• Improve details on TEXT (docs(datatypes): improve details on TEXT #3247 )

Features

• (generate) Avoid generating empty Go imports (Avoid generating empty Go imports statement #3135 )
• (mysql) Add NEXTVAL() to the MySQL catalog (feat(dolphin): Add NEXTVAL() to the MySQL catalog #3147 )
• (mysql) Support json.RawMessage for LOAD DATA INFILE (feat(mysql): Support json.RawMessage for LOAD DATA INFILE #3099 )

Build

• (deps) Bump github.com/jackc/pgx/v5 to 5.5.5 (build(deps): bump github.com/jackc/pgx/v5 from 5.5.4 to 5.5.5 #3259 )
• (deps) Bump modernc.org/sqlite to 1.29.5 (build(deps): bump modernc.org/sqlite from 1.28.0 to 1.29.1 #3200 )
• (deps) Bump github.com/go-sql-driver/mysql to 1.8.0 (build(deps): bump github.com/go-sql-driver/mysql from 1.7.1 to 1.8.0 #3257 )
• (deps) Bump github.com/tetratelabs/wazero to 1.7.0 (build(deps): bump github.com/tetratelabs/wazero from 1.5.0 to 1.6.0 #3096 )
• (deps) Bump github.com/pganalyze/pg_query_go to v5 (build(deps): bump github.com/tetratelabs/wazero from 1.5.0 to 1.6.0 #3096 )