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

Add RAND_INTEGER function, which returns a random integer modulo N

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

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

    Description

      Add a RANDOM function.
      It is not standard SQL, but most DBMSs have one, and it be useful.

      It will also allow us to better test non-deterministic expressions.

      I propose that:

      • RANDOM(n) returns an integer between 0 and n - 1 inclusive.
      • There is no facility to specify a seed at this time.
      • The random number generator is randomly seeded at query start time based on (say) the method used by Java's new Random(); if you run the query twice, you will (probably) not get the same results.
      • If you call the function twice in the same row, it will (probably) return different results.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            julian.feinauer Julian Feinauer
            julianhyde Julian Hyde
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment