MonetDB: default - Add the COMMIT statement in the dump code.

[Aris Koning]

Changeset: f394bcc23e1a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f394bcc23e1a
Modified Files:
        sql/backends/monet5/sql_upgrades.c
        sql/scripts/76_dump.sql
Branch: default
Log Message:

Add the COMMIT statement in the dump code.


diffs (25 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
@@ -3396,6 +3396,8 @@ sql_update_default(Client c, mvc *sql, c
                                        "        CALL dump_table_data();\n"
                                        "    END IF;\n"
                                        "\n"
+                                       "    INSERT INTO dump_statements VALUES 
(current_size_dump_statements() + 1, 'COMMIT;');\n"
+                                       "\n"
                                        "    RETURN dump_statements;\n"
                                        "END;\n");
 
diff --git a/sql/scripts/76_dump.sql b/sql/scripts/76_dump.sql
--- a/sql/scripts/76_dump.sql
+++ b/sql/scripts/76_dump.sql
@@ -273,7 +273,8 @@ BEGIN
        --TODO Improve performance of dump_table_data.
        --TODO loaders ,procedures, window and filter sys.functions.
        --TODO look into order dependent group_concat
-       --TODO add COMMIT statement once everything is fine.
+
+       INSERT INTO dump_statements VALUES (current_size_dump_statements() + 1, 
'COMMIT;');
 
        RETURN dump_statements;
 END;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list