gerold103 / rna Goto Github PK

This is a meta-task for expressions available outside GROUP BY context

Make Rule Based Optimization. It must reduce AST tree to more optimum kind

SELECT ... FROM one_table WHERE (a = 1) AND (b = 2) AND ...

Make STAT daemon, that helps CB Optimizator to choose strategy. It must keep up all actions with tarantool and store information about it

This is a meta-task for SELECT support

• single-table FULL SCAN
• single-table EQUALITY predicate
• basic nested loop EQUI-JOIN
• nested-loop EQUI-JOIN using index

Embed http://github.comt/tarantool/test-run and implement SQL based tests.

Implement INSERT statement:
INSERT [INTO] table-name (columns) (expr-list)

Implement DROP TABLE statement, syntax:

DROP TABLE <table-name>

Support CREATE TABLE statement, clauses:

• PRIMARY KEY
• INT data type
• STRING data type
• UNIQUE
• INDEX (column-list)
• DOUBLE data type

Make Cost Based Optimization. Optimizer must select best strategy of request executing

SELECT ... FROM table1 t1 JOIN table2 t2 ON (t1.a = t2.a ...) JOIN table3 t3 ...