MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:MatthiasLeichmleich Date:June 3 2008 12:32pm
Subject:bzr push into mysql-5.0 tree (MatthiasLeichmleich:2636 to 2636) Bug#32656,
Bug#36788
View as plain text  
------------------------------------------------------------
revno: 2636
revision-id: mleich@stripped
parent: mleich@stripped
committer: Matthias Leich mleich@stripped
branch nick: mysql-5.0-bugteam-funcs_1
timestamp: Mon 2008-06-02 21:57:11 +0200
message:
  Bug#36788 Multiple funcs_1 'trig' tests are failing on vanilla builds
  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
added:
  mysql-test/suite/funcs_1/include/tb3.inc tb3.inc-20080530141937-mozb7mvkoh46lye9-1
  mysql-test/suite/funcs_1/r/ndb_trig_0102.result ndb_trig_0102.result-20080530150730-o6suyuevwnd21dnb-1
  mysql-test/suite/funcs_1/r/ndb_trig_03.result ndb_trig_03.result-20080530150730-o6suyuevwnd21dnb-2
  mysql-test/suite/funcs_1/r/ndb_trig_0407.result ndb_trig_0407.result-20080530150730-o6suyuevwnd21dnb-3
  mysql-test/suite/funcs_1/r/ndb_trig_08.result ndb_trig_08.result-20080530150730-o6suyuevwnd21dnb-4
  mysql-test/suite/funcs_1/r/ndb_trig_09.result ndb_trig_09.result-20080530150730-o6suyuevwnd21dnb-5
  mysql-test/suite/funcs_1/r/ndb_trig_1011ext.result ndb_trig_1011ext.res-20080530150730-o6suyuevwnd21dnb-6
  mysql-test/suite/funcs_1/t/ndb_trig_0102.test ndb_trig_0102.test-20080530150730-o6suyuevwnd21dnb-7
  mysql-test/suite/funcs_1/t/ndb_trig_03.test ndb_trig_03.test-20080530150730-o6suyuevwnd21dnb-8
  mysql-test/suite/funcs_1/t/ndb_trig_0407.test ndb_trig_0407.test-20080530150730-o6suyuevwnd21dnb-9
  mysql-test/suite/funcs_1/t/ndb_trig_08.test ndb_trig_08.test-20080530150730-o6suyuevwnd21dnb-10
  mysql-test/suite/funcs_1/t/ndb_trig_09.test ndb_trig_09.test-20080530150730-o6suyuevwnd21dnb-11
  mysql-test/suite/funcs_1/t/ndb_trig_1011ext.test ndb_trig_1011ext.tes-20080530150730-o6suyuevwnd21dnb-12
modified:
  Makefile.am                    sp1f-makefile.am-19700101030959-jbbpiygwpgybyqknlavdxxupbrjonu7h
  mysql-test/r/func_misc.result  sp1f-func_misc.result-20001228015633-4sy6dzzt7xcs4ubzcxloyguc7zhougbr
  mysql-test/suite/funcs_1/r/innodb_trig_0102.result sp1f-innodb_trig_0102.res-20070206175436-qayw77hubof3kdsbrmfmuzlhp4truay3
  mysql-test/suite/funcs_1/r/innodb_trig_03.result sp1f-innodb_trig_03.resul-20070206175436-mq45jye6dgp4ghwjmpbv2txgz7fd6vrk
  mysql-test/suite/funcs_1/r/innodb_trig_0407.result sp1f-innodb_trig_0407.res-20070206175436-lr26htv2b4kgrxtjyuwq6jgeqasuw64d
  mysql-test/suite/funcs_1/r/innodb_trig_08.result sp1f-innodb_trig_08.resul-20070206175436-z4bpcbjwcioz74mswi5ezis27jwlvba4
  mysql-test/suite/funcs_1/r/innodb_trig_09.result sp1f-innodb_trig_09.resul-20070206175436-iyvorcoemrp6r5aj4ljzyg47lafvpbme
  mysql-test/suite/funcs_1/r/innodb_trig_1011ext.result sp1f-innodb_trig_1011ext.-20070206175436-q6b3sbvrtz66gnmemlan3xwnr3h4mrf3
  mysql-test/suite/funcs_1/r/memory_trig_0102.result sp1f-memory_trig_0102.res-20070206175436-3vo6jvwyznevrpzwxagzuvd7pjnwgu32
  mysql-test/suite/funcs_1/r/memory_trig_03.result sp1f-memory_trig_03.resul-20070206175436-pxa3il3tcnaspjngarefebn7l7dqis2y
  mysql-test/suite/funcs_1/r/memory_trig_0407.result sp1f-memory_trig_0407.res-20070206175436-ami35yone2dq3k5mwehgyqkykjfqrzw6
  mysql-test/suite/funcs_1/r/memory_trig_08.result sp1f-memory_trig_08.resul-20070206175436-l6timuowetepntkcpq24cfaxnqbaukeb
  mysql-test/suite/funcs_1/r/memory_trig_09.result sp1f-memory_trig_09.resul-20070206175436-wpykodzbwjreeqwlkrcdgq2spuiwcdk4
  mysql-test/suite/funcs_1/r/memory_trig_1011ext.result sp1f-memory_trig_1011ext.-20070206175436-lk6rwxzv6hisbya5l5jurcn2hxde56pt
  mysql-test/suite/funcs_1/r/myisam_trig_0102.result sp1f-myisam_trig_0102.res-20070206175437-lsgr75qs52skqoxhdrmgrfykhylpj22u
  mysql-test/suite/funcs_1/r/myisam_trig_03.result sp1f-myisam_trig_03.resul-20070206175437-zfqieq3khktj2e5eulyiu2wu2bdmd6zh
  mysql-test/suite/funcs_1/r/myisam_trig_0407.result sp1f-myisam_trig_0407.res-20070206175437-cnomsj2jcwpfpfoop2cran2lszr33ig2
  mysql-test/suite/funcs_1/r/myisam_trig_08.result sp1f-myisam_trig_08.resul-20070206175437-ckwl4sej56qizaff5gcl27iv2bipcv6l
  mysql-test/suite/funcs_1/r/myisam_trig_09.result sp1f-myisam_trig_09.resul-20070206175437-o5nt24kekznzixwwetwhvxd3qsfrdbdl
  mysql-test/suite/funcs_1/r/myisam_trig_1011ext.result sp1f-myisam_trig_1011ext.-20070206175437-wm77dmka5iagttd7vctzxk42xhnc46vv
  mysql-test/suite/funcs_1/t/disabled.def sp1f-disabled.def-20070206175437-omhbgzpxfjoru23leqkxfztodlmdl4af
  mysql-test/suite/funcs_1/t/innodb_trig_0102.test sp1f-innodb_trig_0102.tes-20070206175438-wnq54hui2ahzx5f366dyuzycw5nfuzcg
  mysql-test/suite/funcs_1/t/innodb_trig_03.test sp1f-innodb_trig_03.test-20070206175438-nwbzlq76xom5o6lxrkgsorchvqb7wb7l
  mysql-test/suite/funcs_1/t/innodb_trig_0407.test sp1f-innodb_trig_0407.tes-20070206175438-ncy4f2524qanf6mbjzibt7p6pskljp5n
  mysql-test/suite/funcs_1/t/innodb_trig_08.test sp1f-innodb_trig_08.test-20070206175438-3ahrmdhq7vh46vsv6ovks65k2sgi2xo3
  mysql-test/suite/funcs_1/t/innodb_trig_09.test sp1f-innodb_trig_09.test-20070206175438-wemacblooxgqlqwnk3gx44jcdrjhylrq
  mysql-test/suite/funcs_1/t/innodb_trig_1011ext.test sp1f-innodb_trig_1011ext.-20070206175438-ubrfdfvnpappcetkv6quhwn5cmr2vcer
  mysql-test/suite/funcs_1/t/memory_trig_0102.test sp1f-memory_trig_0102.tes-20070206175438-kt7imrplki3vnguoz7ev3xqvi676voem
  mysql-test/suite/funcs_1/t/memory_trig_03.test sp1f-memory_trig_03.test-20070206175438-kjpgh7awqdqdewgdxejebdmpv56bhxkp
  mysql-test/suite/funcs_1/t/memory_trig_0407.test sp1f-memory_trig_0407.tes-20070206175438-3fmfr5e4arp267rsnstbescawqjqkg3o
  mysql-test/suite/funcs_1/t/memory_trig_08.test sp1f-memory_trig_08.test-20070206175438-hhpy43xf5fsggoh52jtvmd5rb7iqvndk
  mysql-test/suite/funcs_1/t/memory_trig_09.test sp1f-memory_trig_09.test-20070206175438-tzcisjxtp7zl45h57rqofw7mmyl2zvxn
  mysql-test/suite/funcs_1/t/memory_trig_1011ext.test sp1f-memory_trig_1011ext.-20070206175438-zdhfamx7oygpnsl3rsyd7wj2sc2c2n7p
  mysql-test/suite/funcs_1/t/myisam_trig_0102.test sp1f-myisam_trig_0102.tes-20070206175439-xyiyxciujeuuvnoeaozzk2sbrpwz44bi
  mysql-test/suite/funcs_1/t/myisam_trig_03.test sp1f-myisam_trig_03.test-20070206175439-beaflheb5rzzxcui5c33xjit7g6kjhsm
  mysql-test/suite/funcs_1/t/myisam_trig_0407.test sp1f-myisam_trig_0407.tes-20070206175439-ipgr5agogavxuirtrodvkkhbgw3raqga
  mysql-test/suite/funcs_1/t/myisam_trig_08.test sp1f-myisam_trig_08.test-20070206175439-56e2mu6bevfc5jbltrg3uqmfjwqqxmfl
  mysql-test/suite/funcs_1/t/myisam_trig_09.test sp1f-myisam_trig_09.test-20070206175439-2bzvyx6ouwy3kb27e4umfvvjyti4qu6j
  mysql-test/suite/funcs_1/t/myisam_trig_1011ext.test sp1f-myisam_trig_1011ext.-20070206175439-iprx5iw6vmrk2vn6xn7qhpdobrm2ozp3
  mysql-test/suite/funcs_1/triggers/triggers_0102.inc sp1f-triggers_0102.inc-20070206175439-7gcmfnamt4jktnn5ksfrh2zdylfvqtvg
  mysql-test/suite/funcs_1/triggers/triggers_03.inc sp1f-triggers_03.inc-20070206175439-xg3hkddw3jqmctyrsxwrxp5rutis24zo
  mysql-test/suite/funcs_1/triggers/triggers_0407.inc sp1f-triggers_0407.inc-20070206175439-7nivnderbsg2gcbk6n7ru36sw4vdzpdl
  mysql-test/suite/funcs_1/triggers/triggers_08.inc sp1f-triggers_08.inc-20070206175439-odr5mhhamlpsqbh5gf4qg6mflxb7ibzj
  mysql-test/suite/funcs_1/triggers/triggers_09.inc sp1f-triggers_09.inc-20070206175439-fuwb4lyxepp2si3iyd4ldh7w7us57t6b
  mysql-test/suite/funcs_1/triggers/triggers_1011ext.inc sp1f-triggers_1011ext.inc-20070206175439-jw5xjerrcfevxockml4n45jj7dwjjumw
  mysql-test/t/func_misc.test    sp1f-func_misc.test-20001228015635-kayguwcdgtjnekzavvdzbsnqcdwfm36c

Attachment: [text/text/x-diff] patch-2636.diff
Thread
bzr push into mysql-5.0 tree (MatthiasLeichmleich:2636 to 2636) Bug#32656,Bug#36788MatthiasLeichmleich3 Jun