• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..10-Feb-2022-

funcs/H10-Feb-2022-644,263642,117

iuds/H10-Feb-2022-199,895174,547

rr_trx/H03-May-2022-3,2132,622

READMEH A D10-Feb-20223.2 KiB6854

README

1This directory includes a set of three test suites aimed as testing
2functionality in an engine independent way, that is - the tests should
3work identically against different engines.
4
5The following suites are included:
6
71) 'funcs' suite
8   -------------
9   A collection of functional tests covering basic engine and server
10   functionality that can be run against any engine.
11
12   To run the test suite:
13      cd INSTALL_DIR/mysql-test
14      run: perl ./mysql-test-run.pl --suite=engines/funcs --mysqld=--default-storage-engine=<engine>
15
162) 'iuds' suite
17   ------------
18   Similar to the above focused on insert/update/delete operations of different data types.
19
20   To run the test suite:
21      cd INSTALL_DIR/mysql-test
22      run: perl ./mysql-test-run.pl --suite=engines/iuds --mysqld=--default-storage-engine=<engine>
23
243) 'rr_trx' suite (transactional engines only)
25   --------------
26   A scenario of multiple client connections verifying transactions with repeatable read isolation level
27
28   To run the test suite with innodb:
29      cd INSTALL_DIR/mysql-test
30      run: perl ./suite/engines/rr_trx/run_stress_tx_rr.pl --engine=<engine> [--duration=<nn>]
31                                                          [--threads=<nn>] [--try] [--help]
32
33   This test is can be run against any transactional engine. However scripts need to be modified in order
34   to support such engines (current scripts support only InnoDB).
35   In order to add support for a new engine, you will need to modify scripts as follows:
36   1) cd to INSTALL_DIR/mysql-test/suite/engines/rr_trx
37   2) Modify the 'run_stress_rr.pl' file by adding an 'elsif' section for your engine and have it
38      include specific values required to be passed as startup parameters to the MySQL server by
39      specifying them using "--mysqld" options (see InnoDB example).
40   3) Copy the 'init_innodb.txt' file to 'init_<engine>.txt file and change its content to be "init_<engine>".
41   4) In the 't' directory copy the "init_innodb.test" file to "init_<engine>.test" and change the value of
42      the '$engine' variable to <engine>.
43   5) In the 'r' directory copy "the init_innodb.result" file to "init_<engine>.result" and change references
44      to 'InnoDB' to <engine>.
45
46
47Known Issues
48------------
491) The following tests in the 'iuds' suite:
50     - delete_decimal
51     - insert_decimal
52     - update_decimal
53   will return a 'Warning 1264 - Out of range value...' warning if run in a 32-bit environment.
54   Add the '--force' option to prevent the test run from aborting.
55
562) The following tests in the 'funcs' suite will fail when run against the innodb_plugin:
57   - crash_manycolumns_string (bug 50495)
58   - ix_unique_lob (bug 52056, masked by an 'Out of memory error' on some 32-bit platforms)
59   - ix_unique_string_length (bug 52056, masked by an 'Out of memory error' on some 32-bit platforms)
60   Add the '--force' option to prevent the test run from aborting.
61
623) Some of the rpl_xxx tests in the 'funcs' suite require a specific
63   binlog_format setting and will be skipped otherwise.
64
654) Some of the rpl_xxx tests in the 'funcs' suite will report a
66   'Statement unsafe for replication' warning when run against a
67   server configured to use statement based replication.
68