1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
netbox = require('net.box')
test_run = require('test_run').new()
box.execute("CREATE TABLE t (id INT PRIMARY KEY AUTOINCREMENT, a INT NOT NULL, c TEXT COLLATE \"unicode_ci\");")
box.execute("INSERT INTO t VALUES (1, 1, 'aSd');")
remote = test_run:get_cfg('remote') == 'true'
execute = nil
test_run:cmd("setopt delimiter ';'")
if remote then
box.schema.user.grant('guest','read, write, execute', 'universe')
box.schema.user.grant('guest', 'create', 'space')
cn = netbox.connect(box.cfg.listen)
execute = function(...) return cn:execute(...) end
else
execute = function(...)
local res, err = box.execute(...)
if err ~= nil then
error(err)
end
return res
end
end;
test_run:cmd("setopt delimiter ''");
execute([[UPDATE "_session_settings" SET "value" = true WHERE "name" = 'sql_full_metadata';]])
-- Make sure collation is presented in extended metadata.
--
execute("SELECT 'aSd' COLLATE \"unicode_ci\";")
execute("SELECT c FROM t;")
execute("SELECT c COLLATE \"unicode\" FROM t;")
-- Make sure that nullability/autoincrement are presented.
--
execute("SELECT id, a, c FROM t;")
execute("SELECT * FROM t;")
-- Span is always set in extended metadata. Span is an original
-- expression forming result set column.
--
execute("SELECT 1 AS x;")
execute("SELECT *, id + 1 AS x, a AS y, c || 'abc' FROM t;")
box.execute("CREATE VIEW v AS SELECT id + 1 AS x, a AS y, c || 'abc' FROM t;")
execute("SELECT * FROM v;")
execute("SELECT x, y FROM v;")
execute([[UPDATE "_session_settings" SET "value" = false WHERE "name" = 'sql_full_metadata';]])
test_run:cmd("setopt delimiter ';'")
if remote then
cn:close()
box.schema.user.revoke('guest', 'read, write, execute', 'universe')
box.schema.user.revoke('guest', 'create', 'space')
end;
test_run:cmd("setopt delimiter ''");
box.space.V:drop()
box.space.T:drop()
|
