From 02d3c022814a524a7af8cb2abe0573bb1613ff5d Mon Sep 17 00:00:00 2001
From: unknown <sergefp@mysql.com>
Date: Sun, 29 Aug 2004 19:44:28 +0400
Subject: Fix for BUG#5242: Made SQL Syntax Prepared Statement names
 case-insensitive.

mysql-test/r/ps.result:
  Testcase for BUG#5242
mysql-test/t/ps.test:
  Testcase for BUG#5242
---
 mysql-test/r/ps.result | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'mysql-test/r/ps.result')

diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result
index 98095930669..e161904cd6f 100644
--- a/mysql-test/r/ps.result
+++ b/mysql-test/r/ps.result
@@ -241,3 +241,21 @@ prepare stmt1 from "select * from t1 into outfile 'f1.txt'";
 execute stmt1;
 deallocate prepare stmt1;
 drop table t1;
+prepare stmt1 from 'select 1';
+prepare STMT1 from 'select 2';
+execute sTmT1;
+2
+2
+deallocate prepare StMt1;
+deallocate prepare Stmt1;
+ERROR HY000: Unknown prepared statement handler (Stmt1) given to DEALLOCATE PREPARE
+set names utf8;
+prepare `ü` from 'select 1234';
+execute `ü` ;
+1234
+1234
+set names latin1;
+execute `ü`;
+1234
+1234
+set names default;
-- 
cgit v1.2.1