8350
8350
DROP PROCEDURE p2;
8351
8351
DROP PROCEDURE p5;
8355
--echo # Bug#11840395 (formerly known as bug#60347):
8356
--echo # The string "versiondata" seems
8357
--echo # to be 'leaking' into the schema name space
8360
DROP DATABASE IF EXISTS mixedCaseDbName;
8362
CREATE DATABASE mixedCaseDbName;
8364
CREATE PROCEDURE mixedCaseDbName.tryMyProc() begin end|
8365
CREATE FUNCTION mixedCaseDbName.tryMyFunc() returns text begin return 'IT WORKS'; end
8368
call mixedCaseDbName.tryMyProc();
8369
select mixedCaseDbName.tryMyFunc();
8370
DROP DATABASE mixedCaseDbName;
8374
--echo # Bug#11766594 59736: SELECT DISTINCT.. INCORRECT RESULT WITH DETERMINISTIC FUNCTION IN WHERE C
8377
CREATE TABLE t1 (a INT, b INT, KEY(b));
8378
CREATE TABLE t2 (c INT, d INT, KEY(c));
8379
INSERT INTO t1 VALUES (1,1),(1,1),(1,2);
8380
INSERT INTO t2 VALUES (1,1),(1,2);
8384
CREATE FUNCTION f1() RETURNS INT DETERMINISTIC
8387
-- SQL statement inside
8394
SELECT COUNT(DISTINCT d) FROM t1, t2 WHERE a = c AND b = f1();
8353
8400
--echo # ------------------------------------------------------------------
8354
8401
--echo # -- End of 5.1 tests
8355
8402
--echo # ------------------------------------------------------------------