MariaDB [test]> create table cs1 (a int)engine=columnstore;

Query OK, 0 rows affected (0.650 sec)

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                    |

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

| Part#     Min                           Max                           Status

  0.0.1     Enabled |

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

1 row in set (0.048 sec)

MariaDB [test]> insert into cs1 values (123), (234);

Query OK, 2 rows affected (0.407 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                                                                                |

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

| Part#     Min                           Max                           Status

  0.0.1     N/A                           N/A                           Enabled |

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

1 row in set (0.001 sec)

MariaDB [test]> select * from cs1;

+------+

| a    |

+------+

|  123 |

|  234 |

+------+

2 rows in set (0.097 sec)

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                    |

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

| Part#     Min                           Max                           Status

  0.0.1     Enabled |

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

1 row in set (0.001 sec)

MariaDB [test]> create table cs1 (a int)engine=columnstore;

Query OK, 0 rows affected (0.472 sec)

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                                                                                |

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

| Part#     Min                           Max                           Status

  0.0.1     Empty/Null                    Empty/Null                    Enabled |

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

1 row in set (0.048 sec)

MariaDB [test]> insert into cs1 values (123), (234);

Query OK, 2 rows affected (0.357 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                                                                                |

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

| Part#     Min                           Max                           Status

  0.0.1     N/A                           N/A                           Enabled |

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

1 row in set (0.001 sec)

MariaDB [test]> select * from cs1;

+------+

| a    |

+------+

|  123 |

|  234 |

+------+

2 rows in set (0.080 sec)

MariaDB [test]> select calshowpartitions('cs1', 'a');

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

| calshowpartitions('cs1', 'a')                                                                                                                                |

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

| Part#     Min                           Max                           Status

  0.0.1     123                           234                           Enabled |

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

1 row in set (0.001 sec)

        for (partIt = partMap.begin(); partIt != partMap.end(); ++partIt)

        {

            ostringstream oss;

            oss << partIt->first;        for (partIt = partMap.begin(); partIt != partMap.end(); ++partIt)

        {

            ostringstream oss;

            oss << partIt->first;

            output << "\n  " << setw(10) << oss.str();

            if (partIt->second.is_invalid())

            {

                output << setw(valueCharLength) << "N/A"

                       << setw(valueCharLength) << "N/A";

            }

            else

            {

                const datatypes::TypeHandler *h= ct.typeHandler();

                oss << h->formatPartitionInfo(ct, partIt->second);

                output << h->formatPartitionInfo(ct, partIt->second);