Mihnea Iancu

Results 6 comments of Mihnea Iancu

[YSQL] Inequality is shown to be getting pushed down to docDB when yb_enable_optimizer_statistics is set to true

To add more context, this works as expected unless _both_ ANALYZE is ran _and_ `yb_enable_optimizer_statistics` is set to true. ``` CREATE TABLE test(k int, v int, primary key (k HASH))...

[YSQL] CREATE DATABASE command timeouts in geo distributed/geo partitioned cluster

@shamanthchandra-yb @sanketkedia Is there a significant difference in timing if we run the CREATE DATABASE command on the node/region where the master leader is vs on a node/region where the...

[YSQL] CREATE DATABASE command timeouts in geo distributed/geo partitioned cluster

Thanks @shamanthchandra-yb -- since those times are quite similar, It seems most of the time are due to `yb-master-leader` and `yb_master-followers` latency. The difference between calling it on LEADER and...

[YCQL] Full table counts using token ranges do not match data in table

@kmuthukk @aravind-nallan-yb This behavior for INT64_MIN (`token(gtin13,location_id)

[YCQL] Full table counts using token ranges do not match data in table

So I think the 4 statements above (in the original message) are technically _almost_ correct. I believe the miss is that on the 4th statement the: ``` select count(*) from...

[YSQL] ysql_dump omits SPLIT INTO/SPLIT AT clause for an index after ALTER TABLE ADD UNIQUE constraint using the index

Just a note, this was likely introduced on the ALTER .. ADD UNIQUE side when adding HASH column option (in addition to ASC and DESC). In vanilla PG, only the...