ruanwenjun commented on issue #6431: URL: https://github.com/apache/dolphinscheduler/issues/6431#issuecomment-950252535
> > Good job, in addition to this, we may also need to check the table scheme is sync between mysql, postgresql, h2. I find there are a lot of issue is related to the scheme change, most of them are bug. > > One possible solution is to create three database and execute these three database create sql or database upgrade sql. There is a tool can help to create a test container in UT. https://www.testcontainers.org/ > > That doesn't help much actually, cases are when you add a new field in mysql schema file but forgot to add it in h2 / postgresql, the server starts successfully but fail only when users do some operations. Can we avoid the column lost by compare the columns in three databases? -- 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]
