Levenshtein-MySQL-UDF icon indicating copy to clipboard operation
Levenshtein-MySQL-UDF copied to clipboard

Published 20 hours ago • verified publisher icon juanmirocks

Does not build (MySQL 8 issue maybe?)

Open kingIZZZY opened this issue 5 years ago • 3 comments

This seems like a nice levenshtein plugin to have I successfully built & installed on my local windows WSL ubuntu 18 However i cannot seem to build it on my online VPS CentOS 7 (cpanel/WHM) with MySQL 8 and mysql-community-devel-8.0.21-1.el7.x86_64

  • STANDARD is not defined
  • my_global.h and my_sys.h do not exist anymore in the mysql includes directory
  • my_bool is not defined etc. (looks like it's been removed from mysql?)

Any hope to update the header dependencies so it can still build?

kingIZZZY avatar Aug 28 '20 10:08 kingIZZZY

Workaround

  • Use TrustYard's version
  • Comment out #ifdef HAVE_DLOPEN / #endif /* HAVE_DLOPEN */

Then it successfully built & installed/created those CREATE FUNCTION commands successfully and passed the unittest.sql tests as well

kingIZZZY avatar Aug 28 '20 10:08 kingIZZZY

Thanks @kingIZZZY -- if I have time I will consolidate the build instructions.

juanmirocks avatar Sep 07 '20 09:09 juanmirocks

Just sent pull request for this: https://github.com/juanmirocks/Levenshtein-MySQL-UDF/pull/19

svetasmirnova avatar Mar 21 '22 00:03 svetasmirnova