From: Date: January 31 2006 5:00pm
Subject: bk commit into 5.0 tree (pem:1.2020) BUG#15091
List-Archive: http://lists.mysql.com/commits/1951
X-Bug: 15091
Message-Id: <200601311600.k0VG0FQL014913@mail.mysql.com>

Below is the list of changes that have just been committed into a local
5.0 repository of pem. When pem does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.2020 06/01/31 17:00:50 pem@stripped +2 -0
  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/t/sp-error.test
    1.103 06/01/31 17:00:35 pem@stripped +31 -0
    New test case for BUG#15091.

  mysql-test/r/sp-error.result
    1.102 06/01/31 17:00:34 pem@stripped +13 -0
    Updated results for new test case (BUG#15091).

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	pem
# Host:	pem.mysql.com
# Root:	/extern/mysql/work/cantrepeat/mysql-5.0

--- 1.101/mysql-test/r/sp-error.result	2006-01-31 16:27:43 +01:00
+++ 1.102/mysql-test/r/sp-error.result	2006-01-31 17:00:34 +01:00
@@ -1163,3 +1163,16 @@
 end|
 ERROR 0A000: Not allowed to return a result set from a function
 drop table t1;
+drop procedure if exists bug15091;
+create procedure bug15091()
+begin
+declare selectstr varchar(6000) default ' ';
+declare conditionstr varchar(5000)  default '';
+set selectstr = concat(selectstr,
+' and ',
+c.operatorid,
+'in (',conditionstr, ')');
+end|
+call bug15091();
+ERROR 42S02: Unknown table 'c' in field list
+drop procedure bug15091;

--- 1.102/mysql-test/t/sp-error.test	2006-01-31 16:27:43 +01:00
+++ 1.103/mysql-test/t/sp-error.test	2006-01-31 17:00:35 +01:00
@@ -1673,6 +1673,37 @@
 
 
 #
+# 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
 #
 #--disable_warnings