cfml

what do you expect this to return?

qry = queryNew( 'col', 'varchar', [['foo'],['bar']] );
				var actual = QueryExecute(
					sql = "
						SELECT  rand(3) rand, rand() rand2, rand() rand3
            			FROM qry",
					options = { dbtype: 'query' }
				);

As I didn't think `rand()` was an ANSI function, I would expect an error. (I know it's supported in a large number of database though.)

But given the way SQL works, I'd expect 3 columns with random values and one row for each row in the `qry` recordset.

<https://trycf.com/gist/97a6bb0afa05409cce6d555f8775db23/lucee6-beta?theme=monokai>

<@U0AEFTKRV> That was slightly a trick question.  The first rand() call has a seed passed to it :slightly_smiling_face: