From 94c634a7878c0a82503f272a497e09bfe465aca3 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 27 May 2021 23:49:56 +0100 Subject: Fix part of the create_outputs migration It was completely broken, since it would just delete all entries from the unbuilt outputs table. --- sqitch/sqlite/deploy/create_outputs.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/sqitch/sqlite/deploy/create_outputs.sql b/sqitch/sqlite/deploy/create_outputs.sql index 03f0b42..082e1ab 100644 --- a/sqitch/sqlite/deploy/create_outputs.sql +++ b/sqitch/sqlite/deploy/create_outputs.sql @@ -42,12 +42,11 @@ CREATE TABLE unbuilt_outputs_new ( output_id INTEGER PRIMARY KEY REFERENCES outputs (id) ); -UPDATE unbuilt_outputs_new SET output_id = ( - SELECT id +INSERT INTO unbuilt_outputs_new + SELECT outputs.id FROM unbuilt_outputs INNER JOIN outputs - ON unbuilt_outputs.output = outputs.output -); + ON unbuilt_outputs.output = outputs.output; DROP TABLE unbuilt_outputs; ALTER TABLE unbuilt_outputs_new RENAME TO unbuilt_outputs; -- cgit v1.2.3