Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-606

select * without order by return non deterministics (random) results

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.7
    • Icebox
    • MariaDB Server
    • None
    • Ubuntu 16.04.1 LTS, single node install

    Description

      {{select * from table give random results

      MariaDB [wikistat]> select * from wikistat limit 1\G
      date: 2008-01-18
      time: 2008-01-18 06:00:00
      project: en
      subproject: NULL
      path: Doctor_Who:_Original_Television_Soundtrack
      hits: 2
      size: 2
      1 row in set (1.63 sec)

      MariaDB [wikistat]> select * from wikistat limit 1\G
      date: 2008-01-31
      time: 2008-01-31 10:00:00
      project: de
      subproject: NULL
      path: Haramaki
      hits: 1
      size: 1
      1 row in set (1.58 sec)

      MariaDB [wikistat]> select * from wikistat limit 1\G
      date: 2008-01-31
      time: 2008-01-31 10:00:00
      project: de
      subproject: NULL
      path: Haramaki
      hits: 1
      size: 1
      1 row in set (1.70 sec)

      MariaDB [wikistat]> select * from wikistat limit 1\G
      date: 2008-01-18
      time: 2008-01-18 22:00:00
      project: en
      subproject: NULL
      path: Doctor_of_Professional_Studies
      hits: 1
      size: 1
      1 row in set (1.69 sec)

      MariaDB [wikistat]> select * from wikistat limit 1\G
      date: 2008-01-11
      time: 2008-01-11 05:00:00
      project: en
      subproject: NULL
      path: Doesn\'t_Really_Matter
      hits: 2
      size: 2
      1 row in set (1.71 sec)}}

      Attachments

        Activity

          People

            Unassigned Unassigned
            arubin Alexander Rubin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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