alloc icon indicating copy to clipboard operation
alloc copied to clipboard

In MariaDB 10.11, "empty" is a reserved word? [ATTN: cjb]

Open trentbuck opened this issue 2 years ago • 0 comments

After upgrading from MariaDB 10.5 to 10.11,

FAILS: SELECT empty('fart'); WORKS: SELECT alloc.empty('fart'); WORKS: SELECT neq(1, 1); WORKS: SELECT alloc.new(1, 1);

Therefore I speculate that "empty" now has special meaning. Therefore let's try simply renaming it from "empty" to "emptyXXX". As this stored function is only used in this one file, that should be easy?

https://github.com/cyberitsolutions/alloc/blob/1.9.0/installation/db_triggers.sql#L31

This seems to fix my immediate issue on alloc.cyber.com.au.

trentbuck avatar Jul 01 '23 05:07 trentbuck