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

   ### 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
   
   for 
[V3.2.2](https://www.apache.org/dyn/closer.lua/dolphinscheduler/3.2.2/apache-dolphinscheduler-3.2.2-bin.tar.gz),
 when execute 
   ``` shell
   cd tools/sql/sql/upgrade/3.2.0_schema/mysql
   mysql < dolphinscheduler_ddl.sql
   mysql < dolphinscheduler_dml.sql
   ```
   
   got error
   ```
   ERROR 1064 (42000) at line 34: You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right syntax 
to use near 'delimiter ;CALL dolphin_t_ds_tenant_insert_default();
   DROP PROCEDURE dolphin_t_d' at line 1
   ```
   
   ### What you expected to happen
   
   no error happen when execute upgrade sql file
   
   ### How to reproduce
   
   1、deploy V3.1.5, and then shutdown  
   2、download V3.2.2 binary file,config database info at 
`bin/env/dolphinscheduler_env.sh`  
   3、execute upgrade sql file  
   ```
   cd tools/sql/sql/upgrade/3.2.0_schema/mysql
   mysql < dolphinscheduler_ddl.sql
   mysql < dolphinscheduler_dml.sq
   ```
    
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   3.2.x
   
   ### Are you willing to submit PR?
   
   - [x] 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