shipmonk/doctrine-mysql-index-hints

Imrovements

• Allow MariaDB (#120)
• Support doctrine/dbal 4 (#125)

Fixes

• Exclude useless folders (e.g. /tests) in package archive (#119)

New features

• Support subselects (#103, #105)

Dependencies

• requires php 8.1 (was 7.4)
• requires doctrine/orm 3.0 (was 2.14)

Major changes

• Depends on hint-driven-sql-walker which allows combination of multiple hint handlers
• To migrate to this version, simply change your usages like this:
  • Custom output walker is now HintDrivenSqlWalker::class
  • UseIndexSqlWalker got renamed to UseIndexHintHandler

     ->from(User::class, 'u')
     ->andWhere('u.id = 1')
     ->getQuery()
-    ->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, UseIndexSqlWalker::class)
-    ->setHint(UseIndexSqlWalker::class, [IndexHint::force(User::IDX_FOO, User::TABLE_NAME)])
+    ->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, HintDrivenSqlWalker::class)
+    ->setHint(UseIndexHintHandler::class, [IndexHint::force(User::IDX_FOO, User::TABLE_NAME)])
     ->getResult();

Dependencies:

• requires doctrine/orm 2.14.0 (was 2.7.0)

Changes:

• major dependency cleanup, the only needed is now doctrine/orm ^2.7.0 (#22)

Changes:

• drop support for php < 7.4 (#1)

Changes:

• initial release with support of php >= 7.1