ydb-platform / ydb-platform/ydb-php-sdk
bug: Query to column table (YDB_400120 PRECONDITION_FAILED): Data manipulation queries do not support column shard tables
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 39
- Forks
- 19
- Avg merge
- 1d 15h
- Merged PRs (30d)
- 2
Description
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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the query from the PHP SDK v1.12.0 example in the Docker environment, then compare its execution path with the same request in the web UI console. Trace why the SDK receives the YDB_400120 PRECONDITION_FAILED error for the column shard table, and consider the issue complete when the query executes successfully through the SDK with regression coverage.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100