Tianqi-Dotes commented on code in PR #12276: URL: https://github.com/apache/dolphinscheduler/pull/12276#discussion_r1002962944
########## dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.1_schema/mysql/dolphinscheduler_ddl.sql: ########## @@ -14,3 +14,19 @@ * See the License for the specific language governing permissions and * limitations under the License. */ +--- rename t_ds_fav_task task_name to task_type +delimiter d// +CREATE PROCEDURE modify_t_ds_fav_task_task_name() +BEGIN + IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS + WHERE TABLE_NAME='t_ds_fav_task' + AND TABLE_SCHEMA=(SELECT DATABASE()) + AND COLUMN_NAME='task_name') + THEN +SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); +ALTER TABLE `t_ds_fav_task` change `task_name` `task_type` varchar(64) NOT NULL COMMENT 'favorite task type name'; +END IF; +END; +d// +delimiter ; + Review Comment: done,thanx dear Jiajie -- 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]
