flowable-examples icon indicating copy to clipboard operation
flowable-examples copied to clipboard

Does not support mysql 8

Open iqolome opened this issue 4 years ago • 2 comments

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'; 

iqolome avatar Jun 06 '21 09:06 iqolome

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

filiphr avatar Jun 07 '21 06:06 filiphr

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.

iqolome avatar Jun 07 '21 06:06 iqolome