MonetDB: Aug2024 - fall back to type STRING on only NULL's

[Niels Nes via checkin-list]

Changeset: 6b8fe0152645 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6b8fe0152645
Modified Files:
        sql/backends/monet5/vaults/csv/csv.c
Branch: Aug2024
Log Message:

fall back to type STRING on only NULL's


diffs (16 lines):

diff --git a/sql/backends/monet5/vaults/csv/csv.c 
b/sql/backends/monet5/vaults/csv/csv.c
--- a/sql/backends/monet5/vaults/csv/csv.c
+++ b/sql/backends/monet5/vaults/csv/csv.c
@@ -344,6 +344,12 @@ detect_types(const char *buf, char delim
                        types = ntypes;
                nr_lines++;
        }
+       if (types) { /* NULL -> STRING */
+               for(int i = 0; i<nr_fields; i++) {
+                       if (types[i].type == CSV_NULL)
+                               types[i].type = CSV_STRING;
+               }
+       }
        return types;
 }
 
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org