let $message=
      ... to reproduce a bug ... seen on Suse 9.3 with 5.0.23-bk
      .
      ChangeSet@1.2211, 2006-06-28 10:11:43-07:00, patg@govinda.patg.net
      .;
--source include/show_msg80.inc

let $engine_type= innodb;
use test;

# ... copied from: --source suite/funcs_1/storedproc/load_sp_tb.inc;

CREATE TABLE t1( f1 CHAR(20) );
CREATE TABLE t2( f1 CHAR(20), f2 CHAR(25) );
CREATE TABLE t3( f1 CHAR(20), f2 CHAR(25), f3 DATE );

INSERT INTO t1 VALUES ( 'a`' );
INSERT INTO t2 VALUES ( 'a`', 'a`' );
INSERT INTO t3 VALUES ( 'a`', 'a`', '1000-01-1' );

SELECT * FROM t1;
SELECT * FROM t2;
SELECT * FROM t3;


--echo ... check a strange warning message content, seen in *_storedproc:
--disable_warnings
DROP PROCEDURE IF EXISTS sp1;
DROP PROCEDURE IF EXISTS sp2;
DROP PROCEDURE IF EXISTS sp3;
--enable_warnings
delimiter //;
CREATE PROCEDURE sp1()
BEGIN
   DECLARE x NUMERIC ZEROFILL;
   SELECT f1 INTO x FROM t1 LIMIT 1;
END//
CREATE PROCEDURE sp2()
BEGIN
   DECLARE x NUMERIC ZEROFILL;
   SELECT f1 INTO x FROM t2 LIMIT 1;
END//
CREATE PROCEDURE sp3()
BEGIN
   DECLARE x NUMERIC ZEROFILL;
   SELECT f1 INTO x FROM t3 LIMIT 1;
END//
delimiter ;//
CALL sp1();
CALL sp2();
CALL sp3();

--echo ... check a strange warning message content, seen in *_storedproc:
--disable_warnings
DROP PROCEDURE IF EXISTS sp1;
--enable_warnings
delimiter //;
CREATE PROCEDURE sp1()
BEGIN
declare x numeric unsigned zerofill;
SELECT f1 into x from t2 limit 1;
END//
delimiter ;//
CALL sp1();
#Warnings:
#Warning        1366    Incorrect decimal value: 'a`                  a`                       !?x???a`                       x???ar/tmp' for column 'x' at row 1

DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP PROCEDURE sp1;
DROP PROCEDURE sp2;
DROP PROCEDURE sp3;