Fixes statement_timeout unit handling on int->bigint migration. Refs #20074

Arvados-DCO-1.1-Signed-off-by: Lucas Di Pentima <lucas.dipentima@curii.com>

diff --git a/services/api/db/migrate/20221230155924_bigint_id.rb b/services/api/db/migrate/20221230155924_bigint_id.rb
index fdac96d9adb94bf09d61f0a9e38993280a268a81..932cb025dc337c6e4bd8ddae7f23949f85ad6a21 100644 (file)
--- a/services/api/db/migrate/20221230155924_bigint_id.rb
+++ b/services/api/db/migrate/20221230155924_bigint_id.rb
@@ -6,7 +6,7 @@ class BigintId < ActiveRecord::Migration[5.2]
   disable_ddl_transaction!
   def up
     old_value = query_value('SHOW statement_timeout')
-    execute "SET statement_timeout TO '0s'"
+    execute "SET statement_timeout TO '0'"
 
     change_column :api_client_authorizations, :id, :bigint
     change_column :api_client_authorizations, :api_client_id, :bigint
@@ -34,7 +34,7 @@ class BigintId < ActiveRecord::Migration[5.2]
     change_column :virtual_machines, :id, :bigint
     change_column :workflows, :id, :bigint
 
-    execute "SET statement_timeout TO '#{quote(old_value)}s'"
+    execute "SET statement_timeout TO #{quote(old_value)}"
   end
 
   def down