Back to home page

OSCL-LXR

 
 

    


0001 -- rand with the seed 0
0002 SELECT rand(0);
0003 SELECT rand(cast(3 / 7 AS int));
0004 SELECT rand(NULL);
0005 SELECT rand(cast(NULL AS int));
0006 
0007 -- rand unsupported data type
0008 SELECT rand(1.0);
0009 
0010 -- randn with the seed 0
0011 SELECT randn(0L);
0012 SELECT randn(cast(3 / 7 AS long));
0013 SELECT randn(NULL);
0014 SELECT randn(cast(NULL AS long));
0015 
0016 -- randn unsupported data type
0017 SELECT rand('1')