�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2F'>storage</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fsequence%2F'>sequence</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fsequence%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fsequence%2Fmysql-test%2Fsequence%2F'>sequence</a>/</p><hr><h3>✏️ Editing: group_by.test</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>--source inc.inc

# Check that group by handler forks for the sequence engine.
# The sequence engine can only optimize queries with COUNT(primary_key) or
# SUM(primary_key) when there is no GROUP BY.

show create table seq_1_to_15_step_2;

# Get the correct results
select count(seq),sum(seq),1 from seq_1_to_15_step_2;

--echo #
--echo # The engine should be able to optimize the following requests
--echo #
select count(*) from seq_1_to_15_step_2;
explain select count(*) from seq_1_to_15_step_2;
select count(seq) from seq_1_to_15_step_2;
explain select count(seq) from seq_1_to_15_step_2;
select sum(seq) from seq_1_to_15_step_2;
explain select sum(seq) from seq_1_to_15_step_2;
select count(seq),sum(seq) from seq_1_to_15_step_2;
explain select count(seq),sum(seq) from seq_1_to_15_step_2;
select count(seq) as c from seq_1_to_15_step_2 having c &gt; 5;
explain select count(seq) as c from seq_1_to_15_step_2 having c &gt; 5;
select count(seq) as c from seq_1_to_15_step_2 having c &gt; 1000;
explain select count(seq) as c from seq_1_to_15_step_2 having c &gt; 1000;
select distinct count(*) from seq_1_to_15_step_2;
explain select distinct count(*) from seq_1_to_15_step_2;
select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1;
--replace_column 9 #
explain select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1;

create view v1 as select count(*) from seq_1_to_15_step_2;
select * from v1;
drop view v1;

--echo #
--echo # The engine can&#039;t optimize the following queries
--echo #
select count(seq),sum(seq),1 from seq_1_to_15_step_2;
explain select count(seq),sum(seq),1 from seq_1_to_15_step_2;
explain select count(*) from seq_1_to_15_step_2, seq_1_to_15_step_2 as t2;
explain select count(*) from seq_1_to_15_step_2 where seq &gt; 0;
explain select count(*) from seq_1_to_15_step_2 group by mod(seq,2);

#
# MDEV-9550 COUNT(NULL) returns incorrect result with sequence storage engine
#
create temporary table t1 select * from seq_1_to_3;
select count(NULL) from t1;
select count(NULL) from seq_1_to_3;

--echo #
--echo # MDEV-20753: Sequence with limit 0 crashes server
--echo #
select count(NULL) from seq_1_to_3 limit 0;

--echo # End of 10.3 tests

--echo #
--echo # MDEV-16327: Server doesn&#039;t account for engines that supports
--echo # OFFSET on their own.
--echo #

select count(NULL) from seq_1_to_3 limit 1;
explain format=json select count(NULL) from seq_1_to_3 limit 1;
select count(NULL) from seq_1_to_3 limit 1 offset 1;
explain format=json select count(NULL) from seq_1_to_3 limit 1 offset 1;

--echo # End of 10.5 tests
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fsequence%2Fmysql-test%2Fsequence'>🔙 Back</a></p>