← Back to branch summary

~mdcallag/mysql-patch/5.0-map

« back to all changes in this revision

Viewing changes to mysql-test/t/sp.test

  • Committer: Mark Callaghan
  • Date: 2009-03-08 23:10:48 UTC
  • mfrom: (2676.15.35 merge-5.0-bugteam)
  • Revision ID: mdcallag@gmail.com-20090308231048-98m2y0h6lck93gn1
merge from 5.0

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/sp.test
7793
7793
drop function func30787;
7794
7794
drop table t1;
7795
7795
 
 
7796
#
 
7797
# Bug #33811: Call to stored procedure with SELECT * / RIGHT JOIN fails
 
7798
# after the first time
 
7799
#
 
7800
CREATE TABLE t1 (id INT);
 
7801
INSERT INTO t1 VALUES (1),(2),(3),(4);
 
7802
 
 
7803
CREATE PROCEDURE test_sp()
 
7804
  SELECT t1.* FROM t1 RIGHT JOIN t1 t2 ON t1.id=t2.id;
 
7805
 
 
7806
CALL test_sp();
 
7807
CALL test_sp();
 
7808
 
 
7809
DROP PROCEDURE test_sp;
 
7810
DROP TABLE t1;
7796
7811
 
7797
7812
#
7798
7813
# Bug#38291 memory corruption and server crash with view/sp/function