diff options
| author | gkodinov/kgeorge@magare.gmz <> | 2007-09-19 18:02:59 +0300 |
|---|---|---|
| committer | gkodinov/kgeorge@magare.gmz <> | 2007-09-19 18:02:59 +0300 |
| commit | 3dd2ed30ae99ff3d9c2c0c27eba7f7d6b4d3b280 (patch) | |
| tree | bf1411b693049fac521a2ff38b77a72c6a8ab188 /mysql-test/t/select.test | |
| parent | 7c87dc6e52a96825727a7f7da6fe9c074757ad52 (diff) | |
| parent | c2abf960f917184084fb0143aaa07d707dc5ff6d (diff) | |
| download | mariadb-git-3dd2ed30ae99ff3d9c2c0c27eba7f7d6b4d3b280.tar.gz | |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt
into magare.gmz:/home/kgeorge/mysql/autopush/B30639-5.1-opt
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 91f68fd4057..76a66cc4783 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -3474,3 +3474,13 @@ DROP VIEW v1, v2, v3; --enable_ps_protocol --echo End of 5.0 tests + +# +# Bug #30639: limit offset,rowcount wraps when rowcount >= 2^32 in windows +# +create table t1(a INT, KEY (a)); +INSERT INTO t1 VALUES (1),(2),(3),(4),(5); +SELECT a FROM t1 ORDER BY a LIMIT 2; +SELECT a FROM t1 ORDER BY a LIMIT 2,4294967296; +SELECT a FROM t1 ORDER BY a LIMIT 2,4294967297; +DROP TABLE t1; |