1. Use branch 'sql'
2. Build tarantool by
   cmake .
   make
   

python test-run.py tcl/select1 //run select1.test.lua
python test-run.py select1 select3 where3 //run select1.test.lua, select3.test.lua, where3.test.lua
python test-run.py tcl/select* //run all tcl/select tests

Run "./prepare_tcltest my_test" where my_test is in "third_party/sqlite/test
Run your test: python test-run.py tcl/my_test

1. Run TARANTOOL_HOME/src/tarantool
2. In console:
   box.cfg{log_level=7}
   //or any log level that you want r = require('sql')
   c = r.connect('my_table') //here you can write any name, it is not using now
   c:execute('create table t1(a int primary key, b int, c int, d int);')
   c:execute('INSERT INTO t1 VALUES(1,2,3,4);')
   c:execute('INSERT INTO t1 VALUES(2,3,4,5);')
   c:execute('INSERT INTO t1 VALUES(3,4,5,6);')
   c:execute('INSERT INTO t1 VALUES(4,5,6,7);')
   c:execute('INSERT INTO t1 VALUES(5,6,7,8);')
   c:execute('CREATE INDEX t1b ON t1(b); CREATE INDEX t1c ON t1(c);')
   c:execute('SELECT a FROM t1 WHERE b=3 OR c=6')
   

That is in c:execute(...) method you can execute sql queries.
For explicit access to any index in sql query (for example in 'indexed by' expression) you must use name in following format:
<space_id><index_id><index_name>
For example:
c:execute('create table t1 (a primary key, b)')
c:execute('create index idx1 on t1(b)')
c:execute('drop index "527_1_idx1"') //it is working if id of space 't1' is 527 and id of index 'idx1' is one. You can check this in spaces _space and _index.

Must be okay at all: ~5357
Okay at all: ~19762
Useful coverage: ~78%

8_3_names

affinity2

aggerror, aggnested

alias

alter1 - alter4, altermalloc

amatch1

analyze1 - analyzeF

async1 - async5

atof1

2    |      0       |      0

attach1 - attach4, attachmalloc

0  |      0       |      207

auth1 - auth3

0  |      0       |      365

autoinc

autoindex1 - autoindex5

9  |      15      |      5

autovacuum, autovacuum_ioerr, avtrans

0  |      0       |      190

backcompat

0  |      0       |      52

backup1 - backup5, backup_ioerr, backup_malloc

0  |      0       |      149

badutf1, badutf2

between

bigfile1, bigfile2

bigrow1

bigsort1

bind, bindxfer

bitvec

blob

boundary1 - boundary4

btree01, btree02, btreefaultsim

busy

cache

capi1 - capi3

cast

check

close

closure01

coalesce

collate1 - collateA, colmeta

colname

conflict, conflict2, conflict3

contrib01

corrupt, corrupt2 - corruptJ

cost

count

coveridxscan

crash, crash2 - crash8, crashM

createtab

0  |      0       |      19

cse

ctime

0  |      0       |      28

date

dbstatus, dbstatus2

0  |      0       |      30

default

0  |      13      |      0

delete, delete2 - delete4

descidx1 - descidx3

0  |      93       |      0

diskfull

0  |      0       |      5

distinct, distinctagg

e_blobbytes, e_blobclose, e_blobopen, e_blobwrite

0  |      0       |      138

e_changes

e_createtable

e_delete

e_droptrigger

e_dropview

e_expr

e_fkey

e_fts3

e_insert

e_reindex

e_resolve

e_select1, e_select2

e_totalchanges

e_update

e_uri

e_vacuum

e_wal, e_walauto, e_walckpt, e_walhook

enc1 - enc4

eqp

errmsg

eval

exclusive, exclusive2

exec

exists

expr

extension01

extraquick

fallocate

filectrl, filefmt

fkey1 - fkey8, fkeymalloc

format4

fts*

full

func - func5

fuzz1 - fuzz3, fuzz-oss1, fuzzer1, fuzzerfault

hexlit

hook

icu

in1 - in5

incrblob - incrblob4, incrblob_err,fault,vacuum_ioerr,corrupt,vacuum,vacuum2,vacuum3

index1 - index7, indexedby, indexexpr, indexfault

init

insert1 - insert5

instr

intarray

interrupt

intpkey

io

ioerr - ioerr6

join - join6

journal1 - journal3, jrnlmode - jrnl3

json101, json102

keyword1

lastinsert, laststmtchanges

like - like3

limit

loadext - loadext2

lock - lock7

lookaside

main

malloc, malloc3 - mallocL, mallocAll

manydb

mem5

memdb

memleak, memsubsys1, memsubsys2

minmax - minmax4

misc - misc8

misuse

mmap1 - mmap3, mmapfault

multiplex - multiplex4

mutex1, mutex2

nan

nolock

notify1 - notify3

notnull

null

numcast

offset1

openv2

oserror

ovfl

pager1 - pager4, pagerfault - pagerfault3, pageropt, pagesize

parser1

pcache, pcache2

percentile

permutations

pragma - pragma3

printf, printf2

progress

ptrchng

queryonly

quick

quota-glob

quota, quota2

quote

randexpr1

rbu

rdonly

regexp

reindex

resolver01

rollback, rollback2, rollbackfault

rowalloc

rowhash

rowid

rtree

savepoint - savepoint7

scanstatus

schema - schema5

securedel, securedel2

select1 - selectG

server1

shared - shared4, shared6 - sharedB, shared_err, sharedlock

shell1 - shell5

shortread1

shrink

sidedelete

skipscan1 - skipscan3

soak

softheap1

sort - sort5, sortfault

speed1 - speed4, speed4p, speed4pexplain

spellfix, spellfix2

sqldiff1

sqllimits1

stat, statfault

stmt

subquery, subquery2

subselect

substr

subtype1

superlock

sync

syscall, sysfault

tabfunc01

table

tableapi

tableopts

tclsqlite

tempdb

temptable

temptrigger

thread001 - thread005, thread1, thread2

tkt*

tokenize

tpch01

trace, trace2

trans - trans3

transitive1

trigger1 - triggerE

types - types3

unique, unique2

unixexcl

unordered

update

uri

userauth01

utf16align

vacuum - vacuum4

varint

veryquick

vtab1 - vtabF, vtab_alter, vtab_err, vtab_shared

wal - wal9, wal64k, walback, walbig, walblock, walcksum, walcrash - walcrash3, walfault, walhook, walmode, walnoshm, walpersist, walro, walshared, walslow, walthread

where - whereK, wherelimit, where8m

wild001

win32heap, win32lock, win32longpath

with1, with2, withM

without_rowid1 - without_rowid6

zeroblob, zerodamage

view

1. create table as select is not supported. Need to edit parser for allowing to set primary key at the end of create table as select.
2. segfault on very long "select union select union select union ..." in function sqlite3Select.
3. tarantool can't save COLLATE.
4. CONSTRAINT not supported
5. Incorrect view column names (view-3.3.3)
6. Check count of column on select (view-3.3.6)
7. No query solution on select (view 3.4)
8. Nocase don't (view-11.1)
9. Do not work temp views (view-14.1)
10. Smth do not clear with DROP TABLE and DROP VIEW (view-18.1)
11. Inserting in tables with names 'tbooking' and 'parent1' sometimes fails and only not in lldb.
12. OR optimization is not applied for 'WHERE ..=.. OR ..=..' where all columns are indexed.
13. Very strange error in whereB.sqlite.test - segfault on third CREATE INDEX t2b .... Debug shows that its SIndex->pTable is corrupted.
14. integrity_check - segfaults
15. BEGIN, COMMIT, ROLLBACK are not supported
16. ALTER is not supported
17. DEFAULT values is not supported
18. CHECK is not supported
19. INSERT OR IGNORE/REPLACE/FAIL/ABORT/ROLLBACK/BEGIN/COMMIT are not supported
20. sqlite3_changes not working
21. "PRAGMA threads" is not supported
22. NULL in PRIMARY KEY
23. REPLACE is not supported
24. 'no query solution' on some views
25. NULL op NULL must be always NULL
26. FOREIGN KEY is not supported