Bug #37456 funcs_1: Several tests crash when used with embedded server
Submitted: 17 Jun 2008 19:03 Modified: 1 Oct 2008 19:54
Reporter: Matthias Leich Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S2 (Serious)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D1 (Critical)

[17 Jun 2008 19:03] Matthias Leich
Description:
Several funcs_1 tests crash when applied to the embedded
server. All these tests try to insert rows into a
information_schema table via
   INSERT INTO ... SELECT ....

INSERT INTO ... VALUES does not crash and gets the
expected server error.

Example:
========
ml002.test
----------
INSERT INTO information_schema.schemata
SELECT * FROM information_schema.schemata;
SELECT 1;

TEST         RESULT         TIME (ms)
-------------------------------------------------------
main.ml002   [ fail ]
ERROR: mysqltest returned unexpected code 134, it has probably crashed

Content of master.log:
----------------------
mysql_embedded, Version: 5.1.26-rc-embedded-debug-log (Source distribution). embedded library
Time                 Id Command    Argument
080617 20:38:56    1 Query      SELECT VERSION() NOT LIKE '%embedded%'
                    1 Query     INSERT INTO information_schema.schemata
SELECT * FROM information_schema.schemata

Content of mysqltest.log
------------------------
CURRENT_TEST: main.ml002
mysqltest_embedded: handler.cc:4508: int handler::ha_reset(): Assertion `(uchar*) table->def_read_set.bitmap + table->s->column_bitmap_size == (uchar*) table->def_write_set.bitmap' failed.

My environment:
- Intel Core2Duo (64Bit), OpenSuSE 10.3 64Bit
- MySQL compiled from source
  BUILD/compile-pentium-debug-max
- bugteam trees last changeset ~ 2008-06-10
  6.0 crash
  5.1 crash
  5.0 no crash, works perfect
- main tree last changeset ~ 2008-05-18
  5.1 crash
  5.0 no crash

The current bug is most probably no duplicate of
Bug#37003 Tests sporadically crashes with embedded server
because we get here unexpected code 134 and not 139.

How to repeat:
Please see above
[4 Aug 2008 14:27] Davi Arnaut
It turns out that the funcs_1 test happens to trigger several problems under embedded.
[11 Oct 2008 19:52] Davi Arnaut
Issues reported as Bug#39985 and Bug#39986