ydb-php-sdk icon indicating copy to clipboard operation
ydb-php-sdk copied to clipboard

bug: Query to column table (YDB_400120 PRECONDITION_FAILED): Data manipulation queries do not support column shard tables

Open Kemel91 opened this issue 1 year ago • 0 comments

Bug Report

YDB PHP SDK version:

v1.12.0

Environment

docker

Current behavior:

$result = $ydb->table()->session()->prepare('
DECLARE $tour_hash AS String;
SELECT hash FROM tour_variants_column WHERE tour_hash = $tour_hash;')
        ->execute(['tour_hash' => $hash]);

An error occurs when executing a request via the SDK:

YDB Table ExecuteDataQuery (YDB_400120 PRECONDITION_FAILED): Data manipulation queries do not support column shard tables.

If you execute this request through the web ui console, the request is executed without errors

Kemel91 avatar Nov 28 '23 09:11 Kemel91