MonetDB: Aug2018 - Don't add a NULL to the sys.comments column.

[Sjoerd Mullender]

Changeset: cc317847d696 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cc317847d696
Modified Files:
        sql/backends/monet5/sql_cat.c
Branch: Aug2018
Log Message:

Don't add a NULL to the sys.comments column.
This fixes bug 6639.


diffs (12 lines):

diff --git a/sql/backends/monet5/sql_cat.c b/sql/backends/monet5/sql_cat.c
--- a/sql/backends/monet5/sql_cat.c
+++ b/sql/backends/monet5/sql_cat.c
@@ -1269,7 +1269,7 @@ SQLcomment_on(Client cntxt, MalBlkPtr mb
        if (!id_col || !remark_col)
                throw(SQL, "sql.comment_on", SQLSTATE(3F000) "no table 
sys.comments");
        rid = table_funcs.column_find_row(tx, id_col, &objid, NULL);
-       if (remark != NULL && *remark) {
+       if (remark != NULL && *remark && strcmp(remark, str_nil) != 0) {
                if (!is_oid_nil(rid)) {
                        // have new remark and found old one, so update field
                        /* UPDATE sys.comments SET remark = %s WHERE id = %d */
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list