Bug #29 Two huge bugs found
Submitted: 13 Jan 2003 18:40 Modified: 28 Jan 2003 16:44
Reporter: Sinisa Milivojevic Email Updates:
Status: Not a Bug Impact on me:
None 
Category: Severity:S3 (Non-critical)
Version: OS:
Assigned to: Heikki Tuuri CPU Architecture:Any

[13 Jan 2003 18:40] Sinisa Milivojevic
Description:
Two bugs found in 4.0.x branch. 

First bug causes mysql either  to crash or return nothing when doind 
  select something from table where blob like '%something%';

the column is trivial - just a not-null blob column. However, everything
is 
fine on 3.23.54a. 

The second bug causes MySQL to fail start upon upgrade from 4.0.7 if
InnoDB  
is not used yet not disabled by skip-innodb. 

Both testcases are uploaded to the secret url named
ensita-egor-bug?.tar.bz2 
Both archives has "case.txt" file in it, describing the problem
and 
how-to-repeat. 

OS is RH Linux 7.3, MySQL is the official binary from RPM. 

How to repeat:
Two bugs found in 4.0.x branch. 

First bug causes mysql either  to crash or return nothing when doind 
  select something from table where blob like '%something%';

the column is trivial - just a not-null blob column. However, everything
is 
fine on 3.23.54a. 

The second bug causes MySQL to fail start upon upgrade from 4.0.7 if
InnoDB  
is not used yet not disabled by skip-innodb. 

Both testcases are uploaded to the secret url named
ensita-egor-bug?.tar.bz2 
Both archives has "case.txt" file in it, describing the problem
and 
how-to-repeat. 

OS is RH Linux 7.3, MySQL is the official binary from RPM. 

Suggested fix:
> What happened below was probably that you had old ib_logfiles left in
the
> datadir. Below InnoDB complains about that and instructs you to
delete
those
> obsolete ib_logfiles. When you the next time start mysqld, InnoDB
assumes
> that it should do a recovery using those wrong ib_logfiles. Of
course,
that
> does not work, and a crash follows.
>
> I can think of an improvement: InnoDB could always after a successful
> startup stamp ibdatas and Ib_logfiles so that it could warn if
someone
tries
> to use incompatible files together.
>
> Regards,
>
> Heikki
[28 Jan 2003 16:43] MySQL Developer
First cases is fixed, second can't be verified.

This bug report is also not done correctly, so I will just delete it.
[28 Jan 2003 16:44] MySQL Developer
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in PHP.