Bug #11731 mysqltest in multi-statement queries ignores errors in non-1st queries

• Submitted: 4 Jul 2005 21:24
• Modified: 5 Dec 2005 10:38
• Reporter: Sergey Petrunya
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.0-bk
• Assigned to: Magnus Blaudd

[4 Jul 2005 21:24] Sergey Petrunya

Description:
mysql-test-run in multi-statement queries ignores errors in non-first statement(s). 
 

How to repeat:
Create a test file:
-------a.test-----------
--disable_ps_protocol

--disable_warnings
drop table if exists t1;
--enable_warnings

delimiter ||||;

create table t1 (a int primary key);
insert into t1 values (1);
select 'select-me';
insertz "this isnt a valid query" into t1 values(1)||||

delimiter ;||||
------a.test ends----
run ./mysql-test-run --record t/a.test
the test will succeed and in result one will find:
------a.result-----
drop table if exists t1;
create table t1 (a int primary key);
insert into t1 values (1);
select 'select-me';
insertz "this isnt a valid query" into t1 values(1)||||
select-me
select-me
------a.result ends-----
Which is very misleading.

Suggested fix:
Make mysql-test-run detect and print all errors and warnings (and make --error directive
to mask all of the errors )

[2 Dec 2005 18:29] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/32966

[5 Dec 2005 10:38] Magnus Blaudd

Test cases pushed to 5.0.17. Closing bug report now.