[#MDEV-14403] Review and fix tests from innodb_fts, innodb_zip, innodb

-please check if results are correct in tests truncate and truncate_recover. (mysql results are in /r/ .result_mysql)
-test undo_space_id has to be rewritten, it fails, so I disabled it for now.
(mysqldump_max_recordsize.test and innodb_buffer_pool_load.test from innodb suite need to be rewritten in the same way (NEW_CMD), maybe correct them all at once)

prefix_index_liftedlimit : ~~MDEV-14238~~
wl6560 : --need to be rewritten l.184
wl6470_1 : ~~MDEV-14240~~
wl6501 : fix

innodb_zip.wl6501 '16k,innodb'           [ fail ]  Found warnings/errors in server log file!

        Test ended at 2017-11-15 12:41:30

line

2017-11-15 12:41:30 140477646644992 [ERROR] Table test/t1 has a primary key in InnoDB data dictionary, but not in MariaDB! Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html

2017-11-15 12:41:30 140477646644992 [ERROR] InnoDB: Table test/t1 contains 1 indexes inside InnoDB, which is different from the number of indexes 0 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html

2017-11-15 12:41:30 140477646644992 [ERROR] InnoDB: Table `test`.`t1` is corrupt.

2017-11-15 12:41:30 140477646644992 [ERROR] mysqld: Table 't1' is marked as crashed and should be repaired

^ Found warnings in /home/alice/aliska/bb-10.2-alice/mysql-test/var/log/mysqld.1.err

ok

 - saving '/home/alice/aliska/bb-10.2-alice/mysql-test/var/log/innodb_zip.wl6501-16k,innodb/' to '/home/alice/aliska/bb-10.2-alice/mysql-test/var/log/innodb_zip.wl6501-16k,innodb/'

Merge InnoDB test cases from MySQL 5.7 (MDEV-13626) [MDEV-14403] Review and fix tests from innodb_fts, innodb_zip, innodb_undo suites, merged from mysql 5.7 Created: 2017-11-15 Updated: 2023-11-08
Status:	Open
Project:	MariaDB Server
Component/s:	Full-text Search, Storage Engine - InnoDB, Tests
Affects Version/s:	10.2, 10.3, 10.4
Fix Version/s:	10.4, 10.5, 10.6

[MDEV-14403] Review and fix tests from innodb_fts, innodb_zip, innodb_undo suites, merged from mysql 5.7 Created: 2017-11-15 Updated: 2023-11-08