Repository navigation
Feature: Support Optimizer Hints in generated queries #4353
Description
What do you want to change?
Add support for MySQL Optimizer Hints.
When a query contains Optimizer Hints, the generated code should preserve them as-is. For example, the following query:
SELECT /*+ MAX_EXECUTION_TIME(1000) */ * FROM t1 INNER JOIN t2 WHERE ...should produce generated code that retains the /*+ ... */ hint comment in the query string, rather than stripping it out.
What database engines need to be changed?
MySQL
What programming language backends need to be changed?
No response
Activity
replu commentedon Apr 7, 2026
Apologies for the misleading description in the original issue.
After further investigation, the inline form is already supported and works correctly:
The actual problem is with multi-line hints, where the hint comment appears on its own line:
This is valid MySQL syntax, but sqlc's treats any line that starts with /* and ends with */ as a regular block comment and removes it — which inadvertently strips optimizer hints written in this style.
Preserve MySQL optimizer hints in stripped query text
Preserve MySQL optimizer hints in generated query text (sqlc-dev#4382)