1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# name: test/sql/order/test_limit_percent_large.test_slow
# description: Test LIMIT keyword {% | PERCENT}
# group: [order]
statement ok
PRAGMA enable_verification
query I
SELECT COUNT(*) FROM (SELECT * FROM (SELECT * FROM (SELECT * FROM range(1000000) LIMIT 10%) LIMIT 10%) LIMIT 10%)
----
1000
query I
SELECT * FROM range(10) UNION ALL SELECT * FROM range(10, 20) LIMIT 10%;
----
0
1
#boundary values
# big value
query I
SELECT * FROM range(1000000) LIMIT 0.0001%
----
0
|
