summaryrefslogtreecommitdiff
path: root/mysql-test/r/select_found.result
diff options
context:
space:
mode:
authormonty@tik.mysql.fi <>2001-05-23 02:40:46 +0300
committermonty@tik.mysql.fi <>2001-05-23 02:40:46 +0300
commit8685094e159f29f2b00642f579be4ca681a10247 (patch)
tree22a09c551394dd62383433e28ef919ca86f669b7 /mysql-test/r/select_found.result
parenta3be64bfa519ff04d5b6a9be8dfb2e255ee3862b (diff)
downloadmariadb-git-8685094e159f29f2b00642f579be4ca681a10247.tar.gz
Don't write rows in MyISAM tables when using count(distinct)
Don't read MyISAM header when running without locking
Diffstat (limited to 'mysql-test/r/select_found.result')
-rw-r--r--mysql-test/r/select_found.result31
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