File: gh-3613-idx-alter-update.test.lua

package info (click to toggle)
tarantool 2.6.0-1.2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 85,396 kB
  • sloc: ansic: 513,775; cpp: 69,493; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,176; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (26 lines) | stat: -rw-r--r-- 725 bytes parent folder | download | duplicates (3)
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
test_run = require('test_run').new()
engine = test_run:get_cfg('engine')
_ = box.space._session_settings:update('sql_default_engine', {{'=', 2, engine}})

box.execute('CREATE TABLE t (s1 INT PRIMARY KEY)')
box.execute('CREATE INDEX i ON t (s1)')
box.execute('ALTER TABLE t RENAME TO j3')

-- Due to gh-3613, next stmt caused segfault
box.execute('DROP INDEX i ON j3')

-- Make sure that no artifacts remain after restart.
box.snapshot()
test_run:cmd('restart server default')
box.execute('DROP INDEX i ON j3')

box.execute('CREATE INDEX i ON j3 (s1)')

-- Check that _index was altered properly
box.snapshot()
test_run:cmd('restart server default')

box.execute('DROP INDEX i ON j3')

-- Cleanup
box.execute('DROP TABLE j3')