Redisql 0.1.2 base functionality test (clients MUST support this functionality)

intro.sh

#!/bin/bash

./redisql-cli DROP TABLE test
./redisql-cli CREATE TABLE test "("id INT, value TEST")"
./redisql-cli DESC test
./redisql-cli CREATE INDEX test_ind ON test "(value)"
./redisql-cli DESC test

./redisql-cli INSERT INTO test VALUES "(1,ONE)"
./redisql-cli INSERT INTO test VALUES "(2,TWO)"
./redisql-cli INSERT INTO test VALUES "(3,THREE)"
./redisql-cli INSERT INTO test VALUES "(4,FOUR)"
./redisql-cli INSERT INTO test VALUES "(5,FIVE)"
./redisql-cli DUMP test

./redisql-cli SELECT "*" FROM test WHERE id = 1
./redisql-cli SELECT id, value FROM test WHERE id BETWEEN 2 AND 4 ORDER BY value LIMIT 2
./redisql-cli SELECT "*" FROM test WHERE value BETWEEN S and U

./redisql-cli SCANSELECT "*" FROM test
./redisql-cli UPDATE test SET value=two WHERE id = 2
./redisql-cli SCANSELECT "*" FROM test
./redisql-cli DELETE FROM test WHERE id BETWEEN 3 AND 4
./redisql-cli SCANSELECT "*" FROM test

./redisql-cli DESC test
./redisql-cli DROP INDEX test_ind
./redisql-cli DESC test

#NORM
./redisql-cli SET user:1:name bill
./redisql-cli SET user:1:job programmer
./redisql-cli SET user:2:name jane
./redisql-cli SET user:2:job manager
./redisql-cli NORM user
./redisql-cli DUMP user TO MYSQL

#DENORM 
./redisql-cli DENORM user "user:*"
./redisql-cli HGETALL user:1
./redisql-cli HGETALL user:2
#LUA
./redisql-cli LUA "return 'test lua';"
./redisql-cli CONFIG SET luafilename helper.lua # load lua functions file
./redisql-cli LUA "return type('test');"
./redisql-cli LUA "x=select('value', 'test', 'id=5'); return 'VAL: ' .. x .. ' LEN: ' ..string.len(x);
"

#CREATE TABLE AS
./redisql-cli DEL ZZZ 
./redisql-cli ZADD ZZZ 1 ONE
./redisql-cli ZADD ZZZ 2 TWO 
./redisql-cli ZADD ZZZ 3 THREE 
./redisql-cli DROP TABLE copy_ZZZ
./redisql-cli CREATE TABLE copy_ZZZ "AS DUMP ZZZ"
./redisql-cli DESC copy_ZZZ
./redisql-cli DUMP copy_ZZZ
./redisql-cli DROP TABLE copy_part_ZZZ
./redisql-cli CREATE TABLE copy_part_ZZZ "AS ZRANGE ZZZ 0 1"
./redisql-cli DUMP copy_part_ZZZ

#SELECT STORE
./redisql-cli DEL Zxxx
./redisql-cli SELECT zvalue,zkey FROM copy_ZZZ WHERE pk BETWEEN 1 AND 3 STORE ZADD Zxxx
./redisql-cli ZRANGE Zxxx 0 -1 WITHSCORES