On Thu, May 06, 2021 at 07:10:58PM +0000, John Rouillard wrote:
> 
> I am starting to plan the next roundup release. I would like to get a 
> beta out end of may (no alpha this time). That way I can get the 20
> year anniversary edition on in July. I'll probably release it on the 
> 13th again a few days later then the first release: 0.1.0 2001-07-11.

Cool!

> This is one of the few active bugs, do you think you can get it
> sorted (with or without docs) by end May or July?

I'll try my best. Unfortunately the multilink expression feature is in
worse shape than I anticipated: The very first test (the one suggested
by Bernhard) fails for mysql.
When a '-1' id (meaning "empty multilink") is involved, at least the
tests I came up with fail for *all* backends.

I'll commit what I have later today (when I'm reasonably sure I didn't
break other tests, I've introduced a new class "keyword" in the tests)

Once I have this in place the idea is
- to get mysql working
- to get the feature working with '-1' in a query
- to allow '-1' mixed with other ids as an implicit "or" (my memory says
  that this used to work before the multilink-expression feature was
  introduced but I may be wrong and it may well be that this never
  worked for multilinks)
- To ensure that if only '-1' (and no other boolean operator with lower
  negative id) is part of the query we do not materialize the whole
  multilink table in a subquery (that would be fine for 'keyword' but I
  have some tables where this would materialize *large* datasets)
- Finally try to reproduce the bug for which the issue was originally
  created by writing a test for it
- and fix it :-)

Ralf
-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: office@runtux.com