Closed
Milestone
Jul 1, 2023–Sep 30, 2023
2023, Q3
Goals
- Non-blocking scans in Tarantool (cancel long lasting queries)
- DDL
- DML (delete, update)
- Documentation
From Q1:
- "Not" operator
From Q2:
- Stress tests for Picodata SQL
- Cost-based join optimizations
- Tables with non-journaled metadata in Tarantool
Results
Ok:
- Non-blocking scans in Tarantool (cancel long lasting queries)
- DDL
- DML (delete, update)
- "Not" operator
Partial:
- Documentation - we failed to cover all the topics that were planned, but anyway - the situation really improved.
- Stress tests for Picodata SQL - the picostress tool is almost ready, but it seems to be finished in the Q4
Ignored:
- Cost-based join optimizations - we decided to freeze this work (we have lot's of other problems to be solved first)
- Tables with non-journaled metadata in Tarantool - the MR into the core and module was merged too late, so move it to Q4
Unstarted Issues (open and unassigned)
0
Ongoing Issues (open and assigned)
0
Completed Issues (closed)
31
- attempt to index a nil value
- ACL: drop role
- ACL: create role
- ACL: drop user
- ACL: create user
- After `insert on conflict replace` record is either missing from the table or gets duplicated
- Extend expr_tree_replace_bool() expression types
- Refactoring: migrate INSERT tests to explain
- Add options for INSERT and DELETE parameters
- Fix reference in EBNF grammar for EXCEPT
- Add DELETE to SQL documentation
- join fails with right scan without alias
- Evict IR from cache when tables were modified
- Update EBNF grammar and documentation with INSERT ON CONFLICT
- Decimal to numeric fails on INSERT
- bug: flaky test in CI: `require("vshard")` fails
- Forbid SQL queries with global spaces
- Support vinyl engine for CREATE TABLE
- Fail to create sharded table with decimal column type
- Get rid of cartridge in the Picodata documentation for SQL
- Better formatting for SQL results in Lua
- Introducing types: update query plans
- Register pico.sql as a RPC function
- Freeze rust version to 1.71 (same as Picodata has)
- Implement insert on conflict
- get rid of `Target::Value`
- Support update operator
- Support delete operator
- Support drop table
- Support create table
- Add NOT expression
Loading
Loading
Loading