Re: SQL question - bugs?

Interesting - I got it to work with a seed, too. Without a seed, it's
supposed to use machine time or something. It ought to work, IMO.

With a seed, the sequence is the same all the time, but the calling app
could probably use some substitution variable to modify this from run to run.

Are there other functions with optional arguments?

Looks like a bug to me. When I have time I'll report it.

Thanks

Vern

At 02:12 PM 11/21/2002 -0500, you wrote:

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
This worked:
CREATE VIEW ROB/AAAKEYL01
AS SELECT minute(current time) minut, aaakey.*
from rob/aaakey

and this worked:
CREATE VIEW ROB/AAAKEYL01
AS SELECT rand(1) rndnbr, aaakey.*
from rob/aaakey

but without a seed it doesn't work.

Is it a problem with any other function in which the expression is
optional?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

Vern Hamberg <vhamberg@centerfieldtechnology.com>
Sent by: midrange-l-admin@midrange.com
11/21/2002 01:52 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        SQL question - bugs?

--
[ Picked text/plain from multipart/alternative ]
I am running into some weirdness. I am creating a view that includes a
column that uses the rand() function.

      create view vern/fetchrand as select rand() rndnbr, orders.* from
tpch/orders

When I try to run SELECT against the view

      select * from vern/fetchrand order by rndnbr

I get

Message ID . . . . . . :   CPF426A       Severity . . . . . . . :   50
Message type . . . . . :   Escape
Date sent  . . . . . . :   11/21/02      Time sent  . . . . . . : 12:35:53

Message . . . . :   User-defined function RAND cannot be invoked.