Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Does not support mysql 8 #33

Open
iqolome opened this issue Jun 6, 2021 · 2 comments
Open

Does not support mysql 8 #33

iqolome opened this issue Jun 6, 2021 · 2 comments

Comments

@iqolome
Copy link

iqolome commented Jun 6, 2021

Need to convert and verify sql

 UPDATE FLW_EV_DATABASECHANGELOG SET '8:1b0c48c9cf7945be799d868a2626d687' WHERE MD5SUM='7:0aaa7b01343f4cdaf1019cd2de3f98f3';

 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:c8701f1c71018b55029f450b2e9a10a1' WHERE MD5SUM='7:d878c2672ead57b5801578fd39c423af';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:47f94b27feb7df8a30d4e338c7bd5fb8' WHERE MD5SUM='7:15a6bda1fce898a58e04fe6ac2d89f54';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:ac17eae89fbdccb6e08daf3c7797b579' WHERE MD5SUM='7:eed5dec2f94778b62d0b0b4beebc191d';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:f73aabc4529e7292c2942073d1cff6f9' WHERE MD5SUM='7:b8d3d5a3efb71aef7578e1130a38fde2';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:3e03528582dd4eeb4eb41f9b9539140d' WHERE MD5SUM='7:ae890f8d7f13a83bebd35c0749fd0a58';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:646c6a061e0b6e8a62e69844ff96abb0' WHERE MD5SUM='7:c44cb06af8977c776a4e93aebe96c568';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:215a499ff7ae77685b55355245b8b708' WHERE MD5SUM='7:4b6469565b1b00b428ffca7eab1ef253';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:5355bee389318afed91a11702f2df032' WHERE MD5SUM='7:f83b7b3228be2c4bbb554d6de45307d7';

UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:033ebf9380889aed7c453927ecc3250d' WHERE MD5SUM='7:252bd5cb28cf86685ed67eb15d910118'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:986365ceb40445ce3b27a8e6b40f159b' WHERE MD5SUM='7:4850f9311e7503d7ea30a372e79b4ea2'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:abf482518ceb09830ef674e52c06bf15' WHERE MD5SUM='7:6d80a1fd28201ae354e73bd7c5cf8595'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:2087829f22a4b2298dbf530681c74854' WHERE MD5SUM='7:fe396622b05965c516c1bedb14789be8'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:b4be732b89e5ca028bdd520c6ad4d446' WHERE MD5SUM='7:80b47424c1d564a692fc8923633f78e4'; 

UPDATE ACT_CO_DATABASECHANGELOG SET MD5SUM='8:7644d7165cfe799200a2abdd3419e8b6' WHERE MD5SUM='7:a17df43ed0c96adfef5271e1781aaed2'; 
UPDATE ACT_CO_DATABASECHANGELOG SET MD5SUM='8:fe7b11ac7dbbf9c43006b23bbab60bab' WHERE MD5SUM='7:5aa445d140a638ee432a00c23134dd98'; 

UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:8b4b922d90b05ff27483abefc9597aa6' WHERE MD5SUM='7:1ed01100eeb9bb6054c28320b6c5fb22'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:65e39b3d385706bb261cbeffe7533cbe' WHERE MD5SUM='7:72a1f3f4767524ec0e22288a1621ebb9'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:c01f6e802b49436b4489040da3012359' WHERE MD5SUM='7:1c0c14847bb4a891aaf91668d14240c1'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:e40d29cb79345b7fb5afd38a7f0ba8fc' WHERE MD5SUM='7:894e6e444f72422bf34e4ade89dc8451'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:70349de472f87368dcdec971a10311a0' WHERE MD5SUM='7:08d50990ca7c5669a8dfb6cdc0bbb7e0'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:10e82e26a7fee94c32a92099c059c18c' WHERE MD5SUM='7:2b33c819a1ef81d793f7ef82bed8b1ac'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:530bc81a1e30618ccf4a2da1f7c6c043' WHERE MD5SUM='7:ff6d918908599427d849c1f3b109cf1c'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:e8c2eb1ce28bc301efe07e0e29757781' WHERE MD5SUM='7:d168de628476556968549f4a355baacb'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:4cb4782b9bdec5ced2a64c525aa7b3a0' WHERE MD5SUM='7:20048a5d52039eaabb32dbb30240fc08'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:341c16be247f5d17badc9809da8691f9' WHERE MD5SUM='7:e20ea59573dc2a33bbf72043ea09ea4d'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:d7c4da9276bcfffbfb0ebfb25e3f7b05' WHERE MD5SUM='7:21c7a61ad7fb26abc675dff7ac54e43e'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:adf4ecc45f2aa9a44a5626b02e1d6f98' WHERE MD5SUM='7:e77f0eb21b221f823d6a0e198144cefc'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:7550626f964ab5518464709408333ec1' WHERE MD5SUM='7:c5ddabeb0c9fb8db6371c249097d78a3'; 


UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:496fc778bdf2ab13f2e1926d0e63e0a2' WHERE MD5SUM='7:ec9776f6c57a3953c7d27499108df3d1'; 
UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:ccea9ebfb6c1f8367ca4dd473fcbb7db' WHERE MD5SUM='7:f6ea483119569f0fe50aae8d64ba392d'; 
UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:f1f8aff320aade831944ebad24355f3d' WHERE MD5SUM='7:4ef4a0a9e9cfb636c22126d540cdd38e'; 
@filiphr
Copy link
Contributor

filiphr commented Jun 7, 2021

Can you be more precise about what isn't working?

@iqolome
Copy link
Author

iqolome commented Jun 7, 2021

Can you be more precise about what isn't working?

When starting, verify the scheme information of the database. The value of the scheme MD5SUM used in SQL is mysql7. When mysql8 is used, the verification fails.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants