mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-24 18:27:02 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
43 lines
933 B
Plaintext
43 lines
933 B
Plaintext
USE tpch1;
|
|
select rand(0) from region;
|
|
rand(0)
|
|
0.15522042769493574
|
|
0.620881741513388
|
|
0.6387474552157777
|
|
0.33109208227236947
|
|
0.7392180764481594
|
|
select rand(-2) from region order by 1;
|
|
rand(-2)
|
|
0.11941688239520125
|
|
0.12422665872073421
|
|
0.6325218050112219
|
|
0.6548542125661431
|
|
0.804358408604151
|
|
select rand(2) from region order by rand(1);
|
|
rand(2)
|
|
0.354211017819318
|
|
0.8578261098431667
|
|
0.64497318737672
|
|
0.6555866465490187
|
|
0.12234661925802624
|
|
select * from (select n_nationkey, rand(1) from nation limit 1) x;
|
|
n_nationkey rand(1)
|
|
0 0.40540353712197724
|
|
select * from (select n_nationkey from nation order by rand(1) limit 1 )a;
|
|
n_nationkey
|
|
22
|
|
select rand(r_regionkey) from region;
|
|
rand(r_regionkey)
|
|
0.15522042769493574
|
|
0.40540353712197724
|
|
0.6555866465490187
|
|
0.9057697559760601
|
|
0.15595286540310166
|
|
select rand(r_name) from region;
|
|
rand(r_name)
|
|
0.15522042769493574
|
|
0.15522042769493574
|
|
0.15522042769493574
|
|
0.15522042769493574
|
|
0.15522042769493574
|