i have been trying to figure out a problem with some sql i dumped out a year ago and now i dont understand any of it. i finally just tried something and it worked - so im really happy about it.
this is something where mysql 8 seemed to have more sane handling of errors than MariaDB: i was using the new 'with recursive' feature - and it was getting caught in an infinite loop. mariadb would let it just go forever (cpu at 100%, freezing) and mysql stopped the shit at 1001 recursive loops and threw an error saying what was up. made debugging it much easier. thanks Oracle
here is the query:
this of course, is used with BURROW, the future of mmorpg maze chatrooms