dbal-clickhouse icon indicating copy to clipboard operation
dbal-clickhouse copied to clipboard

Support request: SELECT * WHERE foo IN :bar

Open politsin opened this issue 5 years ago • 1 comments

Не могу понять как работь с IN Пробовал разные варианты отсюда https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/data-retrieval-and-manipulation.html получаю всегда Notice: Array to string conversion in FOD\DBALClickHouse\ClickHouseStatement->getTypedParam() (line 390 of vendor/friendsofdoctrine/dbal-clickhouse/src/ClickHouseStatement.php).

FOD\DBALClickHouse\ClickHouseStatement->getTypedParam('bar') (Line: 296)
FOD\DBALClickHouse\ClickHouseStatement->execute(NULL) (Line: 153)
Doctrine\DBAL\Statement->execute() (Line: 75)

Приме кода:

<?php
$bar = [1, 2, 3];
$query = $conn->prepare('SELECT **** WHERE foo IN :bar');
$query->bindValue('bar', $bar);

politsin avatar Apr 01 '19 10:04 politsin

@politsin $bar = [1, 2, 3]; $result = $conn->fetchAll('SELECT **** WHERE foo IN (:bar)', ['bar' => $bar], ['bar' => \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);

koderoff avatar Apr 14 '19 18:04 koderoff