jieguangzhou opened a new issue, #13256:
URL: https://github.com/apache/dolphinscheduler/issues/13256

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### What happened
   
   ```sql
   -- uc_dolphin_T_t_ds_command_R_test_flag
   delimiter ;
   DROP FUNCTION IF EXISTS uc_dolphin_T_t_ds_command_R_test_flag();
   delimiter d//
   CREATE FUNCTION uc_dolphin_T_t_ds_command_R_test_flag() RETURNS void AS $$
   BEGIN
          IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS
             WHERE TABLE_CATALOG=current_database()
             AND TABLE_SCHEMA=current_schema()
             AND TABLE_NAME='t_ds_command'
             AND COLUMN_NAME ='test_flag')
         THEN
   ALTER TABLE t_ds_command alter column test_flag type int DEFAULT NULL;
   END IF;
   END;
   $$ LANGUAGE plpgsql;
   d//
   delimiter ;
   select uc_dolphin_T_t_ds_command_R_test_flag();
   DROP FUNCTION uc_dolphin_T_t_ds_command_R_test_flag();
   ```
   
   we can not use the MySQL syntax here
   
   ### What you expected to happen
   
   empty
   
   ### How to reproduce
   
   empty
   
   ### Anything else
   
   empty
   
   ### Version
   
   dev
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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]

Reply via email to