-4930to41000.sql:-- Alter
view storage_pool_view
engine/schema/src/main/resources/META-INF/db/schema-4930to41000.sql:-- Alter
view image_store_view
Regards.
From: Marcus
Sent: Tuesday, July 7, 2020 20:58
To: dev@cloudstack.apache.org
Subject: mysql view changes
I just wanted to drop a line to the community - perhaps this has been
addressed already and I'm just disorganized.
I see that in the 4.12 SQL upgrade scripts we use "ALTER VIEW" rather than
the previous pattern of "DROP VIEW IF EXISTS" + "CREATE".
The problem I've seen with ALTER VIEW is that in