Closed
Milestone
Apr 1, 2023–Jun 30, 2023
2023, Q2
Goals
- Picodata support (from Q1)
- Left join
- PostgreSQL protocol
- Stress tests in CI
- Cost-based join optimizations
- Tables with non-journaled metadata in Tarantool
- DISTINCT and HAVING
- "Not" operator (from Q1)
Results
Ok:
- Picodata support (from Q1)
- Left join
- DISTINCT and HAVING
Partial:
- PostgreSQL protocol (almost done)
- Stress tests in CI (added a single stress test to CI, then delegated stress test framework to Georgi Lomakin)
Ignored:
- "Not" operator (from Q1)
- Tables with non-journaled metadata in Tarantool
Failed:
- Cost-based join optimizations (a very poor progress on the way to join reorder problem).
- Documentation
Unstarted Issues (open and unassigned)
0
Ongoing Issues (open and assigned)
0
Completed Issues (closed)
33
- Derive types in the plan
- Research: allow_filtering analogue
- Single quoted strings containing whitespace are parsed as empty strings
- Add types to the distribution key
- Migrate to non-SQL INSERT
- unsupported boolean operator in join condition: `is not null and bool`
- SubQuery with selection from VALUES in projection expression results in NotFound(Column) Err
- Confusing error when trying to insert values into space with a string field using pico.sql
- Lowercase names don't work in pico.sql
- Research: use tuple's key_def to calculate sharding hash
- Migrate to picodata schema (_pico_space)
- Fast path for a single row insert
- Explain plan for SELECT
- Add to query examples its result
- Prepare explain command section of documentation.
- Clarify SELECT description
- Make railroad diagrams interactive on the site
- Invalid reference (sql_index -> sql_review)
- suppport NOT EXISTS operator
- Integrate sbroad into picodata binary
- Implement Picodata engine for sbroad
- Refactor the engine traits in sbroad
- Research: SQL documentation for picodata.io
- POC: implement TCP server on C
- Research: clarify the list of the authentication methods.
- Update Rust to 1.67 in CI
- Implement DISTINCT and HAVING for GROUP BY
- Implement AVG DISTINCT for GROUP BY
- Implement AVG for GROUP BY
- Do not dispatch VALUES in INSERT VALUES to storages
- Integrate stress test benchmarks into CI
- Left join support
- Добавление новой политики перераспределения данных - single
Loading
Loading
Loading