[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@3.148.108.244: ~ $ 
# This is the basic function tests for innodb FTS savepoint

-- source include/have_innodb.inc


CREATE TABLE articles (
	id INT UNSIGNED NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	FULLTEXT (title)
	) ENGINE= InnoDB;

# Test Part 1: ROLLBACK TO SAVEPOINT
# Test rollback to savepoint 1(S1,RB1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback to savepoint 2(S1,RB1,S2,RB2)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

ROLLBACK TO SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback to savepoint 3(S1,S2,RB1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback to savepoint 4(S1,S2,RB2,RB1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK TO SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test Part 2: RELEASE SAVEPOINT
# Test release savepoint 1(S1,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release savepoint 2(S1,RL1,S2,RL2)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

RELEASE SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release savepoint 3(S1,S2,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release savepoint 4(S1,S2,RL2,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

RELEASE SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test Part 3: RELEASE & ROLLBACK TO SAVEPOINT
# Test release & rollback to savepoint 1(S1,RB1,S2,RL2)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

RELEASE SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release & rollback to savepoint 2(S1,RL1,S2,RB2)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

ROLLBACK TO SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release & rollback to savepoint 3(S1,S2,RL2,RB1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

RELEASE SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test release & rollback to savepoint 4(S1,S2,RB2,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK TO SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

COMMIT;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test Part 4: ROLLBACK & SAVEPOINT
# Test rollback 1
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

ROLLBACK;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback 2(S1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

ROLLBACK;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback 3(S1,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback 4(S1,RB1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

ROLLBACK TO SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

# Test rollback 5(S1,S2,RB2,RL1)
TRUNCATE TABLE articles;

INSERT INTO articles(id, title) VALUES(1, 'mysql');

BEGIN;

INSERT INTO articles(id, title) VALUES(2, 'mysql');

SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(3, 'mysql');

SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(4, 'mysql');

ROLLBACK TO SAVEPOINT sp2;

INSERT INTO articles(id, title) VALUES(5, 'mysql');

RELEASE SAVEPOINT sp1;

INSERT INTO articles(id, title) VALUES(6, 'mysql');

ROLLBACK;

INSERT INTO articles(id, title) VALUES(7, 'mysql');

SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');

DROP TABLE articles;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ innodb_fts/ t/
Name Type Size Permission Actions
disabled.def File 404 B 0644
fts_compatibility.test File 9.74 KB 0644
fts_compatibility_win.test File 9.58 KB 0644
fulltext.test File 22.1 KB 0644
fulltext2.test File 8.27 KB 0644
fulltext3.test File 988 B 0644
fulltext_cache.test File 1.55 KB 0644
fulltext_distinct.test File 1.18 KB 0644
fulltext_left_join.test File 4.54 KB 0644
fulltext_misc.test File 7.75 KB 0644
fulltext_multi.test File 919 B 0644
fulltext_order_by.test File 5.57 KB 0644
fulltext_plugin-master.opt File 19 B 0644
fulltext_update.test File 1.02 KB 0644
fulltext_var.test File 1.36 KB 0644
innobase_drop_fts_index_table.test File 407 B 0644
innodb-fts-basic.test File 8.74 KB 0644
innodb-fts-ddl.test File 9.15 KB 0644
innodb-fts-fic.test File 7.12 KB 0644
innodb-fts-stopword.test File 30.48 KB 0644
innodb_fts_index_table.test File 3.32 KB 0644
innodb_fts_large_records.test File 12.15 KB 0644
innodb_fts_misc.test File 55.24 KB 0644
innodb_fts_misc_1.test File 33.01 KB 0644
innodb_fts_misc_debug.test File 6.81 KB 0644
innodb_fts_multiple_index.test File 6.34 KB 0644
innodb_fts_opt.test File 14.02 KB 0644
innodb_fts_plugin.test File 1.35 KB 0644
innodb_fts_proximity.test File 7.98 KB 0644
innodb_fts_result_cache_limit.test File 1.76 KB 0644
innodb_fts_savepoint.test File 9.09 KB 0644
innodb_fts_stopword_charset.test File 13.79 KB 0644
innodb_fts_transaction.test File 31.11 KB 0644
phrase.test File 1.01 KB 0644
subexpr.test File 2.09 KB 0644
sync.test File 5.33 KB 0644
sync_block.test File 3.48 KB 0644