From 4b799725034bd5f2d7cda76d8a5bcb3b42cb88f3 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 23 May 2001 02:40:46 +0300 Subject: Don't write rows in MyISAM tables when using count(distinct) Don't read MyISAM header when running without locking include/myisam.h: Don't read header when running without locking. myisam/mi_locking.c: Don't update changed flag for temporary files. myisam/mi_open.c: Don't read header when running without locking. myisam/mi_static.c: Don't read header when running without locking. sql/item_sum.cc: Don't write rows in MyISAM tables when using count(distinct) sql/mysqld.cc: Don't read MyISAM header when running without locking. Remove -Sg option. sql/sql_analyse.h: Remove duplicate header. sql/sql_select.cc: Cleaned up prototypes. Don't write rows to count(DISTINCT) MyISAM tables. sql/sql_select.h: Cleaned up prototypes. sql/table.h: A BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted --- mysql-test/r/select_found.result | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 mysql-test/r/select_found.result (limited to 'mysql-test/r/select_found.result') diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result new file mode 100644 index 00000000000..fcbe8958748 --- /dev/null +++ b/mysql-test/r/select_found.result @@ -0,0 +1,31 @@ +a b +1 2 +2 3 +3 5 +4 5 +5 5 +6 6 +7 7 +8 9 +FOUND_ROWS() +8 +a b +1 2 +FOUND_ROWS() +8 +a b +8 9 +FOUND_ROWS() +8 +b +2 +FOUND_ROWS() +6 +b c +2 1 +FOUND_ROWS() +6 +a b a b +3 5 5 5 +FOUND_ROWS() +8 -- cgit v1.2.1