Gallardot commented on code in PR #14991: URL: https://github.com/apache/dolphinscheduler/pull/14991#discussion_r1372685347
########## dolphinscheduler-dao/src/main/resources/sql/upgrade/3.3.0_schema/mysql/dolphinscheduler_ddl.sql: ########## @@ -14,3 +14,90 @@ * See the License for the specific language governing permissions and * limitations under the License. */ + +-- t_ds_k8s_namespace +-- ALTER TABLE t_ds_k8s_namespace DROP COLUMN IF EXISTS limits_cpu; +drop PROCEDURE if EXISTS drop_t_ds_k8s_namespace_col_code; +delimiter d// +CREATE PROCEDURE drop_t_ds_k8s_namespace_col_code() +BEGIN + IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS + WHERE TABLE_NAME='t_ds_k8s_namespace' + AND TABLE_SCHEMA=(SELECT DATABASE()) + AND COLUMN_NAME='limits_cpu') + THEN +ALTER TABLE t_ds_k8s_namespace DROP COLUMN limits_cpu; +END IF; +END; +d// +delimiter ; +CALL drop_t_ds_k8s_namespace_col_code; +DROP PROCEDURE drop_t_ds_k8s_namespace_col_code; +-- ALTER TABLE t_ds_k8s_namespace DROP COLUMN IF EXISTS limits_memory; +drop PROCEDURE if EXISTS drop_t_ds_k8s_namespace_col_code; Review Comment: Done. PTAL. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
