← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/falcon/t/falcon_bug_37343.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/falcon/t/falcon_bug_37343.test
 
1
--source include/have_falcon.inc
 
2
 
 
3
#
 
4
# Bug #37343 Crash in Falcon with limit where there are no
 
5
#            values in the limited range
 
6
#
 
7
--echo *** Bug #37343***
 
8
 
 
9
# ----------------------------------------------------- #
 
10
# --- Initialisation                                --- #
 
11
# ----------------------------------------------------- #
 
12
let $engine = 'Falcon';
 
13
eval SET @@storage_engine = $engine;
 
14
 
 
15
--disable_warnings
 
16
DROP TABLE IF EXISTS t1;
 
17
--enable_warnings
 
18
 
 
19
# ----------------------------------------------------- #
 
20
# --- Test                                          --- #
 
21
# ----------------------------------------------------- #
 
22
 
 
23
CREATE TABLE t1 (
 
24
        pk INTEGER AUTO_INCREMENT,
 
25
        int_key INTEGER,
 
26
        PRIMARY KEY (pk),
 
27
        KEY (int_key)
 
28
) ENGINE=Falcon;
 
29
 
 
30
SELECT * FROM t1 WHERE int_key < 5 ORDER BY int_key LIMIT 1;
 
31
 
 
32
# ----------------------------------------------------- #
 
33
# --- Check                                         --- #
 
34
# ----------------------------------------------------- #
 
35
SELECT count(*) FROM t1;
 
36
 
 
37
# ----------------------------------------------------- #
 
38
# --- Final cleanup                                 --- #
 
39
# ----------------------------------------------------- #
 
40
DROP TABLE t1;