Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24092

support oracle syntax: sample

    XMLWordPrintable

Details

    Description

      It is recommended to implement oracle's sample clause in MariaDB of sql_mode=oracle

      SAMPLE [ BLOCK ]
      (sample_percent)
      [ SEED (seed_value) ]

      The sample_clause lets you instruct the database to select from a random sample of data from the table, rather than from the entire table.

      • BLOCK instructs the database to attempt to perform random block sampling instead of random row sampling.
      • For sample_percent, specify the percentage of the total row or block count to be included in the sample.
      • SEED seed_value Specify this to instruct the database to attempt to return the same sample from one execution to the next.

      oracle sample clause and example: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6

      Attachments

        Activity

          People

            ralf.gebhardt Ralf Gebhardt
            woqutech woqutech
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.