Changeset: 56b2a2fd3b79 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/56b2a2fd3b79
Modified Files:
sql/backends/monet5/sql_upgrades.c
Branch: ts_and_tz_to_str_fix
Log Message:
timestamp_to_str upgrade code from sql_update_jun2023. sql_update_jun2023_sp3
is sufficient.
diffs (32 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
@@ -5760,28 +5760,6 @@ sql_update_jun2023(Client c, mvc *sql, s
BBPunfix(rt_deleted->batCacheid);
}
- sql_find_subtype(&t1, "timestamp", 0, 0);
- sql_find_subtype(&t2, "varchar", 0, 0);
-
- if (!sql_bind_func(sql, "sys", "timestamp_to_str", &t1, &t2, F_FUNC,
true)) {
- sql->session->status = 0;
- sql->errstr[0] = '\0';
-
- char *query = GDKmalloc(512);
- if (query == NULL)
- throw(SQL, __func__, SQLSTATE(HY013) MAL_MALLOC_FAIL);
-
- snprintf(query, 512, "CREATE FUNCTION timestamp_to_str(d
TIMESTAMP, format STRING) RETURNS STRING "
- "EXTERNAL NAME mtime.\"timestamp_to_str\";\n"
- "GRANT EXECUTE ON FUNCTION
timestamp_to_str(TIMESTAMP, STRING) TO PUBLIC;\n"
- "UPDATE sys.functions SET system = true WHERE
system <> true AND name = 'timestamp_to_str' "
- "AND schema_id = 2000 and type = %d;\n",
F_FUNC);
-
- printf("Running database upgrade commands:\n%s\n", query);
- err = SQLstatementIntern(c, query, "update", true, false, NULL);
- GDKfree(query);
- }
-
GDKfree(buf);
return err; /* usually MAL_SUCCEED */
}
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
