[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: cleanup_types - Update type_digits column in sys._colum...
From:       Sjoerd Mullender via checkin-list <checkin-list () monetdb ! org>
Date:       2024-01-29 9:44:52
Message-ID: hg.d3245dbd4a0c.1706521492.-253288324882532370 () dev ! monetdb ! org
[Download RAW message or body]

Changeset: d3245dbd4a0c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d3245dbd4a0c
Modified Files:
	sql/backends/monet5/sql_upgrades.c
Branch: cleanup_types
Log Message:

Update type_digits column in sys._columns for integer types.


diffs (31 lines):

diff --git a/sql/backends/monet5/sql_upgrades.c b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -166,6 +166,18 @@ check_sys_tables(Client c, mvc *m, sql_s
 		{ "isnull",            "isnil",         "void", F_FUNC, },
 		{0},
 	};
+	char *err;
+
+	/* cleanup_types: change introduced post Dec2023 */
+	err = SQLstatementIntern(c,
+							 "update sys._columns set type_digits = 7 where type = 'tinyint' and type_digits <> 7;\n"
+							 "update sys._columns set type_digits = 15 where type = 'smallint' and type_digits <> 15;\n"
+							 "update sys._columns set type_digits = 31 where type = 'int' and type_digits <> 31;\n"
+							 "update sys._columns set type_digits = 63 where type = 'bigint' and type_digits <> 63;\n"
+							 "update sys._columns set type_digits = 127 where type = 'hugeint' and type_digits <> 127;\n",
+							 "update", true, false, NULL);
+	if (err)
+		return err;
 
 	/* if any of the tested function's internal ID does not match the ID
 	 * in the sys.functions table, we recreate the internal part of the
@@ -188,7 +200,7 @@ check_sys_tables(Client c, mvc *m, sql_s
 				 "select id from sys.functions where name = '%s' and func = '%s' and schema_id = 2000;\n",
 				 tests[i].name, tests[i].func);
 		res_table *output = NULL;
-		char *err = SQLstatementIntern(c, buf, "update", true, false, &output);
+		err = SQLstatementIntern(c, buf, "update", true, false, &output);
 		if (err)
 			return err;
 		BAT *b;
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-leave@monetdb.org
[prev in list] [next in list] [prev in thread] [next in thread]