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

support dropping extents in addition to partitions

    XMLWordPrintable

Details

    Description

      CalShowPartitions is not working properly to show partitions

      {{MariaDB [lkqd_stats]> select theDate,count(theDate) from lkqd_daily group by 1 order by 1;
      --------------------------+

      theDate count(theDate)

      --------------------------+

      2017-04-13 30646909
      2017-04-14 25754602

      --------------------------+
      2 rows in set (1.02 sec)

      MariaDB [lkqd_stats]> select calShowPartitionsByValue('lkqd_daily','theDate','2017-04-13','2017-04-13');
      ERROR 1815 (HY000): Internal error: IDB-2040: No partition found for the given value range.
      MariaDB [lkqd_stats]> select calShowPartitionsByValue('lkqd_daily','theDate','2017-04-14','2017-04-14');
      ERROR 1815 (HY000): Internal error: IDB-2040: No partition found for the given value range.
      MariaDB [lkqd_stats]> select calShowPartitions('lkqd_daily','theDate');
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      calShowPartitions('lkqd_daily','theDate')

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Part# Min Max Status
      0.0.1 2017-04-13 2017-04-14 Enabled
      0.1.2 2017-04-13 2017-04-14 Enabled
      0.2.1 2017-04-13 2017-04-14 Enabled
      0.3.2 2017-04-13 2017-04-14 Enabled

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 row in set (0.00 sec)}}

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              allan.wax Allan
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.