diff options
| author | unknown <monty@tik.mysql.fi> | 2001-05-23 02:40:46 +0300 |
|---|---|---|
| committer | unknown <monty@tik.mysql.fi> | 2001-05-23 02:40:46 +0300 |
| commit | 4b799725034bd5f2d7cda76d8a5bcb3b42cb88f3 (patch) | |
| tree | 22a09c551394dd62383433e28ef919ca86f669b7 /mysql-test/r/select_found.result | |
| parent | 8ec67661b4327060a12f9888a1179d5161e4b9c4 (diff) | |
| download | mariadb-git-4b799725034bd5f2d7cda76d8a5bcb3b42cb88f3.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 31 |
1 files changed, 31 insertions, 0 deletions
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 |