MySQL Bugs: #40177: Test funcs_1.storedproc failing on Pushbuild

Bug #40177	Test funcs_1.storedproc failing on Pushbuild
Submitted:	20 Oct 2008 15:12	Modified:	21 Jan 2009 16:18
Reporter:	Patrick Crews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Patrick Crews	CPU Architecture:	Any
Tags:	funcs_1, pushbuild, StoredProc, test, test failure

Description:
Test funcs_1.storedproc is failing on Pushbuild:

Failures appear to be largely due to loss of Warning statements.  Matthias and I suspect it is due to math processing differences across platforms.

--- storedproc.result	2008-10-12 00:53:39.000000000 +0300
--- storedproc.reject	2008-10-12 16:57:58.000000000 +0300
40871: @@ -2531,15 +2531,9 @@
40872:  UPDATE t1_aux SET f1 = NULL;
40873:  SELECT f1,f1,f1,f1 INTO @v1_tab,@v1_proc,@v2_proc,@v1_func FROM t1_aux;
40874:  UPDATE t1_aux SET f1 = 0.1234567890987654321e-6;
40875: -Warnings:
40876: -Note	1265	Data truncated for column 'f1' at row 1
40877:  SELECT f1 INTO @v1_tab FROM t1_aux;
40878:  CALL sproc_1(0.1234567890987654321e-6, @v1_proc);
40879: -Warnings:
40880: -Note	1265	Data truncated for column 'f1' at row 1
40881:  SET @v1_func = func_1(0.1234567890987654321e-6);
40882: -Warnings:
40883: -Note	1265	Data truncated for column 'f1' at row 1
40884:  UPDATE t1_aux SET f1 = NULL;
40885:  SELECT f1,f1,f1,f1 INTO @v1_tab,@v1_proc,@v2_proc,@v1_func FROM t1_aux;
40886:  UPDATE t1_aux SET f1 = 0.1234567890987654321e-5;

How to repeat:
Run the test.  From the mysql-test directory:

./mtr --suite=funcs_1 storedproc

This test seems to primarily fail on 386 / 586 machines, but no decisive pattern has been seen.

Suggested fix:
Make the test more robust so it will not fail / does not depend on system-variable output.

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/commits/57646

2690 Patrick Crews	2008-11-02
      Bug#40177 Test funcs_1.storedproc failing on Pushbuild
      
      Altered param_check.inc to disable warnings for those operations that can vary based on machine specs.
      Does not alter the test itself.
      
      Re-recorded the .result file to account for the suppression of Warnings / Notes.

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/commits/60560

2727 Patrick Crews	2008-12-03
      Bug#40177: Test funcs_1.storedproc failing on Pushbuild
      
      Altered param_check to disable warnings on system-sensitive operations
      and added some notes / possible TODO
      Re-recorded.result file to account for change

Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:azundris@mysql.com-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)

Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.

Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)

Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)

Setting status back to NDI pending merge to 6.0 tree.

Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)

Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)

Test case changes. No changelog entry needed.