Re: mysql view changes during upgrade

2020-07-08 Thread Rohit Yadav
-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

mysql view changes during upgrade

2020-07-07 Thread Marcus
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