php - 在 yii2 查询中在哪里设置 SQL_BIG_SELECTS？

Question

我在执行查询时遇到错误。

SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows

我必须SET SQL_BIG_SELECTS=1。

我正在使用 YII2，不知道在哪里设置 .

请帮忙。

Answer 1

来自 docs

If you need to execute a SQL query right after establishing a connection (e.g., to set the timezone or character set), you can do so in the [[yii\db\Connection::EVENT_AFTER_OPEN]] event handler.

return [
    // ...
    'components' => [
        // ...
        'db' => [
            'class' => 'yii\db\Connection',
            // ...
            'on afterOpen' => function($event) {
                // $event->sender refers to the DB connection
                $event->sender->createCommand("SET SQL_BIG_SELECTS = 1")->execute();
            }
        ],
    ],
    // ...
];

或者在查询之前运行一次 SQL 查询:

$connection = \Yii::$app->getDb();
$res = $connection->createCommand("SET SQL_BIG_SELECTS = 1")->execute();