slfan1989 commented on PR #5663: URL: https://github.com/apache/hadoop/pull/5663#issuecomment-1557243630
- Mysql > Mysql 5.7 - sp_addApplicationHomeSubCluster ``` federationstatestore> CREATE PROCEDURE sp_addApplicationHomeSubCluster( IN applicationId_IN varchar(64), IN homeSubCluster_IN varchar(256), IN applicationContext_IN BLOB, OUT storedHomeSubCluster_OUT varchar(256), OUT rowCount_OUT int) BEGIN INSERT INTO applicationsHomeSubCluster (applicationId, homeSubCluster, createTime, applicationContext) (SELECT applicationId_IN, homeSubCluster_IN, NOW(), applicationContext_IN FROM applicationsHomeSubCluster WHERE applicationId = applicationId_IN HAVING COUNT(*) = 0 ); SELECT ROW_COUNT() INTO rowCount_OUT; SELECT homeSubCluster INTO storedHomeSubCluster_OUT FROM applicationsHomeSubCluster WHERE applicationId = applicationID_IN; END [2023-05-22 21:38:20] completed in 175 ms ``` - sp_updateApplicationHomeSubCluster ``` federationstatestore> CREATE PROCEDURE sp_updateApplicationHomeSubCluster( IN applicationId_IN varchar(64), IN homeSubCluster_IN varchar(256), IN applicationContext_IN BLOB, OUT rowCount_OUT int) BEGIN UPDATE applicationsHomeSubCluster SET homeSubCluster = homeSubCluster_IN, applicationContext = applicationContext_IN WHERE applicationId = applicationId_IN; SELECT ROW_COUNT() INTO rowCount_OUT; END [2023-05-22 21:38:21] completed in 205 ms ``` - sp_getApplicationHomeSubCluster ``` [2023-05-22 21:38:21] completed in 205 ms federationstatestore> CREATE PROCEDURE sp_getApplicationHomeSubCluster( IN applicationId_IN varchar(64), OUT homeSubCluster_OUT varchar(256), OUT createTime_OUT datetime, OUT applicationContext_OUT BLOB) BEGIN SELECT homeSubCluster, applicationContext, createTime INTO homeSubCluster_OUT, applicationContext_OUT, createTime_OUT FROM applicationsHomeSubCluster WHERE applicationId = applicationID_IN; END [2023-05-22 21:38:22] completed in 204 ms ``` -- 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: common-issues-unsubscr...@hadoop.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: common-issues-unsubscr...@hadoop.apache.org For additional commands, e-mail: common-issues-h...@hadoop.apache.org