MariaDB [mytest]> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.208 sec)

MariaDB [mytest]> CREATE TABLE t1 (a DECIMAL(17,1)) ENGINE=ColumnStore;

Query OK, 0 rows affected (0.142 sec)

MariaDB [mytest]> INSERT INTO t1 VALUES (-8999999999999999.9);

Query OK, 1 row affected (0.103 sec)

MariaDB [mytest]> SELECT * FROM t1 WHERE a=0;

Empty set (0.058 sec)

MariaDB [mytest]> SELECT calShowPartitions('t1','a');

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

| calShowPartitions('t1','a')                                                                                                                                  |

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

| Part#     Min                           Max                           Status

  0.0.1     N/A                           N/A                           Enabled |

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

1 row in set (0.002 sec)

...there was a CREATE TABLE statement...

MariaDB [test]> INSERT INTO t1 VALUES (-8999999999999999.9),(-899999999999999.9);

Query OK, 2 rows affected (0.211 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> select * from information_schema.columnstore_extents;

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

| OBJECT_ID | OBJECT_TYPE | LOGICAL_BLOCK_START | LOGICAL_BLOCK_END | MIN_VALUE          | MAX_VALUE         | WIDTH | DBROOT | PARTITION_ID | SEGMENT_ID | BLOCK_OFFSET | MAX_BLOCKS | HIGH_WATER_MARK | STATE | STATUS    | DATA_SIZE |

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

|      3005 | Column      |              234496 |            242687 | -90000000000000000 | -8999999999999999 |     8 |      1 |            0 |          0 |            0 |       8192 |               0 | Valid | Available |         0 |

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

1 row in set (0.028 sec)

MariaDB [test]> SELECT calShowPartitions('t1','a');

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

| calShowPartitions('t1','a')                                                                                                                                  |

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

| Part#     Min                           Max                           Status

  0.0.1     -8999999999999999.9           -899999999999999.9            Enabled |

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

1 row in set (0.024 sec)

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DECIMAL(17,1)) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (-8999999999999999.9);

SELECT * FROM information_schema.columnstore_extents; -- should show invalid range for extent with the value.

SELECT * FROM t1 WHERE a=0;

SELECT * FROM information_schema.columnstore_extents; -- should show valid range (scanned during previous select) but it does not.