#At file:///work2/5.0/mysql-5.0-bugteam-funcs_1/
------------------------------------------------------------
revno: 2636
revision-id: mleich@stripped
parent: mleich@stripped
committer: Matthias Leich mleich@stripped
branch nick: mysql-5.0-bugteam-funcs_1
timestamp: Fr 2008-05-30 17:12:06 +0200
message:
Bug#36788 Multiple funcs_1 'trig' tests are failing on vanilla builds
Fix for this bug and additional improvements
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 of tmpfs (one attempt only):
with reorder 132 seconds
without reorder 183 seconds
- 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/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
Attachment: [text/text/x-diff] patch-2636.diff
| Thread |
|---|
| • bzr commit into mysql-5.0 tree (MatthiasLeichmleich:2636) Bug#32656,Bug#36788 | MatthiasLeichmleich | 30 May |
