MOON

Server: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4

System: Linux csr818.wilogic.com 2.6.18-419.el5xen #1 SMP Fri Feb 24 22:50:37 UTC 2017 x86_64

User: obrechts (544)

PHP: 5.4.45

Disabled: NONE

Upload Files

File: //usr/share/mysql-test/suite/engines/rr_trx/r/rr_c_count_not_zero.result

SET autocommit = 0;
START TRANSACTION;
*** Running query: SELECT COUNT(*) FROM t1
SELECT COUNT(*) FROM t1 WHERE `pk` MOD 5 = 0 AND `pk` BETWEEN 1 AND 1000;
COUNT(*)
200
SELECT COUNT(*) FROM t1 WHERE `pk` MOD 5 = 0 AND `pk` BETWEEN 1 AND 1000;
COUNT(*)
200
COMMIT;