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

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

It turns out that the funcs_1 test happens to trigger several problems under embedded.

Issues reported as Bug#39985 and Bug#39986

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.