File: gh-4111-format-in-sysview.test.lua

package info (click to toggle)
tarantool 2.6.0-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 85,364 kB
  • sloc: ansic: 513,760; cpp: 69,489; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,173; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (13 lines) | stat: -rw-r--r-- 458 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- 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

box.execute([[CREATE VIEW t AS SELECT "name" FROM "_vspace" y]])
box.execute([[SELECT * from t WHERE "name" = 'T']])
box.execute([[DROP VIEW t]])