From 7e92336b1da07c6424f3bdffcc5d3edf268268fa Mon Sep 17 00:00:00 2001
From: "monty@mysql.com" <>
Date: Thu, 11 Dec 2003 06:24:08 +0200
Subject: Fixed a possible memory leak on MacOSX when using the shared
 libmysql.so library (Bug #2061) mysql_server_init() now returns error code if
 something went wrong (Bug #2062) Don't use my_fopen() when reading symlink
 information as this may cause problems when a lot of files are opened. Free
 thread keys with pthread_key_delete() instead of relying on automatic free.
 (Bug #2062) Fixed bug in UNION statement with alias '*'. (Bug #1249) Fixed a
 bug in DELETE ... ORDER BY ... LIMIT where the rows where not deleted in the
 proper order. (Bug #1024). FOUND_ROWS() could return incorrect number of rows
 after a query with an impossible WHERE condition. HOW DATABASES doesn't
 anymore show .sym files (on windows) that doesn't point to a valid directory.
 (Bug #1385)

---
 mysql-test/r/select_found.result | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

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

diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result
index 0a7f464cf7b..419ffb73d59 100644
--- a/mysql-test/r/select_found.result
+++ b/mysql-test/r/select_found.result
@@ -169,3 +169,22 @@ SELECT FOUND_ROWS();
 FOUND_ROWS()
 2
 drop table t1;
+create table t1 (id int, primary key (id));
+insert into t1 values (1), (2), (3), (4), (5);
+select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
+id
+4
+select FOUND_ROWS();
+FOUND_ROWS()
+2
+select SQL_CALC_FOUND_ROWS * from t1 where id > 3 AND 1=2 limit 0, 1;
+id
+select FOUND_ROWS();
+FOUND_ROWS()
+0
+select SQL_CALC_FOUND_ROWS * from t1 where id > 6 limit 0, 1;
+id
+select FOUND_ROWS();
+FOUND_ROWS()
+0
+drop table t1;
-- 
cgit v1.2.1