Aleksei Pleshakov

Results 26 comments of Aleksei Pleshakov

I minimized query to this: ``` --!syntax_pg set dq.EnableDqReplicate="1"; select avg(sum(cs_sales_price)) over (partition by i_category, i_brand, cc_name) avg_monthly_sales, avg(sum(cs_sales_price)) over (partition by i_category, i_brand, cc_name order by i_brand) rn from...

``` #0 errmsg (fmt=0x72195ba "division by zero") at /home/ee8jsmrbc5d1utc9advj/ydb/ydb/library/yql/parser/pg_wrapper/postgresql/src/backend/utils/error/elog.c:912 #1 0x000000001c609a65 in div_var (var1=var1@entry=0x7ffe37a3a2f0, var2=var2@entry=0x7ffe37a3a2d0, result=result@entry=0x7ffe37a3a310, rscale=, round=) at /home/ee8jsmrbc5d1utc9advj/ydb/ydb/library/yql/parser/pg_wrapper/postgresql/src/backend/utils/adt/numeric.c:8439 #2 0x000000001c6092c6 in numeric_div_opt_error (num1=, num2=, have_error=0x0) at /home/ee8jsmrbc5d1utc9advj/ydb/ydb/library/yql/parser/pg_wrapper/postgresql/src/backend/utils/adt/numeric.c:3098 #3...

minimized further. ``` --!syntax_pg set dq.EnableDqReplicate="1"; select avg(sum(cs_sales_price)) over (partition by i_brand) avg_sales from bindings.item, bindings.catalog_sales, bindings.date_dim where cs_item_sk = i_item_sk and cs_sold_date_sk = d_date_sk and ( d_year = 1999...

Error occurs in this stage: ``` ( (return (lambda '($1) (block '( (let $2 '"_yql_partition_key_0_0") (let $3 (NarrowSqueezeToDict (ToFlow $1) (lambda '($5 $6 $7) $6) (lambda '($8 $9 $10) (AsStruct...

In the future we could force a query to execute as single stage. In such cases, we can execute ` SELECT set_config(\'bytea_output\',\'hex\',false) FROM pg_settings WHERE name = \'bytea_output\';`

The main reason of this change is to ease using YDB python SDK in YDB functional tests. The pip package name clashes with [ydb](https://github.com/ydb-platform/ydb/tree/c47907f8860ffaedc98b4f39a15adf71dfa88895/ydb) module from the repo, so we...

Because YDB tests will have two modules in syspath: ydb and ydb.public.sdk.python3.ydb, and all the imports wouldn't work because it is impossible to distinguish between those symbols in native Python.

I will invest more time in searching for alternative solutions to my problem and notify you if I can prove that relative imports is the least harmful way to fulfill...

I would like to have FP exressions in KLEE. I have synced the klee-float with mainline [here](https://github.com/qrort/klee) and am looking forward to discussing further changes needed to be done.

![IMG_9813](https://github.com/ydb-platform/ydb/assets/31865255/754d0b59-3a57-4baa-b7aa-4d3c7fbffb8e) At the moment, test canonization works as follows: When `ya make -Z` is called inside `yandex-team` intratet, `ya` tool writes new canondata in internal storage via MDS protocol and...