• Matthias Leich mleich@mysql.com's avatar
    Bug#36788 Multiple funcs_1 'trig' tests are failing on vanilla builds · 15440264
    Matthias Leich mleich@mysql.com authored
    Fix for this bug and additional improvements/fixes
    In detail:
    - Remove unicode attribute from several columns
      (unicode properties were nowhere needed/tested)
      of the table tb3
      -> The runnability of these tests depends no more on
         the availibility of some optional collations.
    - Use a table tb3 with the same layout for all
      engines to be tested and unify the engine name
      within the protocols.
      -> <engine>_trig_<abc>.result have the same content
    - Do not load data into tb3 if these rows have no
      impact on result sets
    - Add tests for NDB (they exist already in 5.1)
    - "--replace_result" at various places because
      NDB variants of tests failed with "random" row
      order in results
      This fixes a till now unknown weakness within the
      funcs_1 NDB tests existing in 5.1 and 6.0
    - Fix the expected result of ndb_trig_1011ext
      which suffered from Bug 32656
      + disable this test
    - funcs_1 could be executed with the mysql-test-run.pl
      option "--reorder", which saves some runtime by
      optimizing server restarts.
      Runtimes on tmpfs (one attempt only):
      with    reorder 132 seconds
      without reorder 183 seconds
    - Adjust two "check" statements within func_misc.test
      which were incorrect (We had one run with result set
      difference though the server worked good.)
    - minor fixes in comments
    15440264
memory_trig_0102.result 14.6 KB