Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1552

Add RAND function, returning DOUBLE values in the range 0..1

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.11.0
    • None
    • None

    Description

      Add RAND function, returning DOUBLE values in the range 0..1. It has variants RAND() and RAND(seed).

      Also, add RAND_INTEGER(seed, bound), support for a seed when generating random integers.

      To support seeds, the random function needs to have state. The random number generator is initialized, using the seed, on first use, and subsequent calls use the same random number generator. So, we are building on CALCITE-1548.

      Attachments

        Issue Links

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: