From fd61a0c08dc9398c8ca902b437b068c7a8b97934 Mon Sep 17 00:00:00 2001
From: unknown <pem@mysql.com>
Date: Tue, 31 Jan 2006 17:00:50 +0100
Subject: Added test case for BUG#15091: Sp Returns Unknown error in order
 clause....and there is                                no order by clause
 which was fixed by earlier changesets. The error message is now the more
 generic "Unknown table ... in field list".

mysql-test/r/sp-error.result:
  Updated results for new test case (BUG#15091).
mysql-test/t/sp-error.test:
  New test case for BUG#15091.
---
 mysql-test/t/sp-error.test | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

(limited to 'mysql-test/t')

diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index 22cc325f55e..e1839b4b98f 100644
--- a/mysql-test/t/sp-error.test
+++ b/mysql-test/t/sp-error.test
@@ -1672,6 +1672,37 @@ delimiter ;|
 drop table t1;
 
 
+#
+# BUG#15091: Sp Returns Unknown error in order clause....and 
+#            there is no order by clause
+#
+--disable_warnings
+drop procedure if exists bug15091;
+--enable_warnings
+
+delimiter |;
+create procedure bug15091()
+begin
+  declare selectstr varchar(6000) default ' ';
+  declare conditionstr varchar(5000)  default '';
+
+  set selectstr = concat(selectstr,
+                         ' and ',
+                         c.operatorid,
+                         'in (',conditionstr, ')');
+end|
+delimiter ;|
+
+# The error message used to be:
+#   ERROR 1109 (42S02): Unknown table 'c' in order clause
+# but is now rephrased to something less misleading:
+#   ERROR 1109 (42S02): Unknown table 'c' in field list
+--error ER_UNKNOWN_TABLE
+call bug15091();
+
+drop procedure bug15091;
+
+
 #
 # BUG#NNNN: New bug synopsis
 #
-- 
cgit v1.2.1