| Revisión | d035be3dd62cdf795a6fa6612d7709745e3fa6e3 (tree) |
|---|---|
| Tiempo | 2021-04-28 09:53:38 |
| Autor | rdnielsen |
| Commiter | rdnielsen |
Added a semicolon to the end of all logged SQL statements.
upsert/pg_upsert.sql (diff)| @@ -157,6 +157,8 @@ | ||
| 157 | 157 | -- 2020-04-28 Explicitly rolled back the changes if 'do_commit' = "No". RDN. |
| 158 | 158 | -- 2020-05-09 Moved the assignment of 'upsert_progress_denom' out of the |
| 159 | 159 | -- 'update_console_qa' script. RDN. |
| 160 | +-- 2021-04-27 Added a semicolon to the end of all SQL statements that are | |
| 161 | +-- written to the logfile. RDN. | |
| 160 | 162 | -- ================================================================== |
| 161 | 163 | |
| 162 | 164 |
| @@ -861,7 +863,7 @@ | ||
| 861 | 863 | -- !x! andif(sub_defined(log_sql)) |
| 862 | 864 | -- !x! andif(is_true(!!log_sql!!)) |
| 863 | 865 | -- !x! write "SQL for primary key check:" to !!logfile!! |
| 864 | - -- !x! write [!!~pk_check!!] to !!logfile!! | |
| 866 | + -- !x! write [!!~pk_check!!;] to !!logfile!! | |
| 865 | 867 | -- !x! endif |
| 866 | 868 | |
| 867 | 869 | -- Run the check. |
| @@ -1119,7 +1121,7 @@ | ||
| 1119 | 1121 | -- !x! andif(sub_defined(log_sql)) |
| 1120 | 1122 | -- !x! andif(is_true(!!log_sql!!)) |
| 1121 | 1123 | -- !x! write "SQL for foreign key check:" to !!logfile!! |
| 1122 | - -- !x! write [!!~fk_check!!] to !!logfile!! | |
| 1124 | + -- !x! write [!!~fk_check!!;] to !!logfile!! | |
| 1123 | 1125 | -- !x! endif |
| 1124 | 1126 | |
| 1125 | 1127 | -- Run the check. |
| @@ -1417,7 +1419,7 @@ | ||
| 1417 | 1419 | -- !x! if(sub_defined(log_sql)) |
| 1418 | 1420 | -- !x! andif(is_true(!!log_sql!!)) |
| 1419 | 1421 | -- !x! write "UPDATE statement for !!#base_schema!!.!!#table!!:" to !!logfile!! |
| 1420 | - -- !x! write [!!~updatestmt!!] to !!logfile!! | |
| 1422 | + -- !x! write [!!~updatestmt!!;] to !!logfile!! | |
| 1421 | 1423 | -- !x! endif |
| 1422 | 1424 | -- !x! if(sub_defined(log_changes)) |
| 1423 | 1425 | -- !x! andif(is_true(!!log_changes!!)) |
| @@ -1443,7 +1445,7 @@ | ||
| 1443 | 1445 | -- !x! if(sub_defined(log_sql)) |
| 1444 | 1446 | -- !x! andif(is_true(!!log_sql!!)) |
| 1445 | 1447 | -- !x! write "INSERT statement for !!#base_schema!!.!!#table!!:" to !!logfile!! |
| 1446 | - -- !x! write [!!~insertstmt!!] to !!logfile!! | |
| 1448 | + -- !x! write [!!~insertstmt!!;] to !!logfile!! | |
| 1447 | 1449 | -- !x! endif |
| 1448 | 1450 | -- !x! if(sub_defined(log_changes)) |
| 1449 | 1451 | -- !x! andif(is_true(!!log_changes!!)) |
| @@ -2110,7 +2112,7 @@ | ||
| 2110 | 2112 | -- !x! if(sub_defined(log_sql)) |
| 2111 | 2113 | -- !x! andif(is_true(!!log_sql!!)) |
| 2112 | 2114 | -- !x! write "UPDATE statement for !!#base_schema!!.!!#table!!:" to !!logfile!! |
| 2113 | - -- !x! write [!!~updatestmt!!] to !!logfile!! | |
| 2115 | + -- !x! write [!!~updatestmt!!;] to !!logfile!! | |
| 2114 | 2116 | -- !x! endif |
| 2115 | 2117 | -- !x! if(sub_defined(log_changes)) |
| 2116 | 2118 | -- !x! andif(is_true(!!log_changes!!)) |
| @@ -2696,7 +2698,7 @@ | ||
| 2696 | 2698 | -- !x! andif(is_true(!!log_sql!!)) |
| 2697 | 2699 | -- !x! write "" to !!logfile!! |
| 2698 | 2700 | -- !x! write "SQL for checking foreign key !!@fk_constraint!! for PK update to !!@table_schema!!.!!@table_name!!:" to !!logfile!! |
| 2699 | - -- !x! write [!!~fk_check!!] to !!logfile!! | |
| 2701 | + -- !x! write [!!~fk_check!!;] to !!logfile!! | |
| 2700 | 2702 | -- !x! endif |
| 2701 | 2703 | |
| 2702 | 2704 | -- Run the check |
Fork