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
|
-- Make sure, that it is possible to create a VIEW which
-- refers to "_v" space, i.e. to sysview engine.
-- Before gh-4111 was fixed, attempt to create such a view
-- failed due to lack of format in a space with sysview
-- engine.
test_run = require('test_run').new()
---
...
box.space._vspace.index[1]:count(1) > 0
---
- true
...
box.execute([[CREATE VIEW t AS SELECT "name" FROM "_vspace" y]])
---
- row_count: 1
...
box.execute([[SELECT * from t WHERE "name" = 'T']])
---
- metadata:
- name: name
type: string
rows:
- ['T']
...
box.execute([[DROP VIEW t]])
---
- row_count: 1
...
|
