question

Luciano Cavallero avatar image
0 Likes"
Luciano Cavallero asked Serge A edited

SQL RAND() keyword

Hi,

do anyone know if the SQL RAND() keyword can be configured to use a specific seed or stream?
Or, otherwise, is known which seed use this keyword?

Thanks.

Luciano Cavallero

Flexcon s.r.l.
Strada del Drosso, 33/8 I–10135 TORINO - Italy
ph +39-011-19471502; fax +39-011-19471503; mobile + 39-328-3512568

www.flexcon.it

FlexSim 19.0.9
flexsim 19.0.9sql querysql random
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Serge A avatar image
2 Likes"
Serge A answered Serge A edited

I noticed that RAND() behaves like `uniform(0, 1)`:

(FlexSim 20.0.10)

FlexSim 21.0.2 results are similar, but the seed seems to be different:



So apparently RAND() uses stream 0.


1612369520800.png (12.4 KiB)
1612369578400.png (12.1 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.