I imported some csv data using COPY INTO to a table. The data is sorted by the first column "sym", which is of VARCHAR type. Upon importing, the COPY INTO is not recognising the sortedness of the "sym" column. On the other hand, another test I ran with a sorted DATE column gets marked as sorted as expected. I'm using MonetDB v11.25.23 (Dec2016-SP5), and the steps demonstrating this are below. Is this expected?
sql>CREATE TABLE tempquote (sym VARCHAR(3),time0 TIME,cond1 VARCHAR(1),bid INTEGER,bidqty INTEGER,ask INTEGER,askqty INTEGER,cond2 VARCHAR(1));
operation successful (2.430ms)
sql>COPY INTO tempquote from 'tempquote.csv' USING DELIMITERS ',','\n' NULL AS '';
5 affected rows (31.972ms)
sql>select * from tempquote;
+------+----------+-------+------+--------+------+--------+-------+
| sym | time0 | cond1 | bid | bidqty | ask | askqty | cond2 |
+======+==========+=======+======+========+======+========+=======+
| ABY | 09:30:03 | F | 1489 | 50 | 1872 | 44 | I |
| ACG | 09:30:00 | M | 1419 | 27 | 1542 | 43 | A |
| AHK | 09:30:00 | G | 1094 | 74 | 1808 | 56 | F |
| AXN | 09:30:01 | I | 1022 | 26 | 1541 | 88 | E |
| BEV | 09:30:00 | L | 1377 | 38 | 1353 | 77 | M |
+------+----------+-------+------+--------+------+--------+-------+
5 tuples (1.131ms)
sql>select table,column,sorted from storage() where "table"='tempquote';
+-----------+--------+--------+
| table | column | sorted |
+===========+========+========+
| tempquote | sym | null |
| tempquote | time0 | null |
| tempquote | cond1 | null |
| tempquote | bid | null |
| tempquote | bidqty | null |
| tempquote | ask | null |
| tempquote | askqty | null |
| tempquote | cond2 | null |
+-----------+--------+--------+
8 tuples (5.090ms)
sql>
Thanks,
Sridhar