Having a note type with over 127 fields and the "Exclude from unqualified searches (slower)" option enabled causes regular expression browser searches to fail

I am using anki-24.04-linux-qt6. If I have a note type that has over 127 fields and the “Exclude from unqualified searches (slower)” option enabled on one of those fields, then a browser search that uses the w: prefix or the re: prefix will produce a popup. On a small test collection the following message was produced:

DbError { info: “SqlInputError { error: Error { code: Unknown, extended_code: 1 }, msg: "too many arguments on function regexp_fields", sql: "select c.id from cards c, notes n where c.nid=n.id and (((n.mid = 1712616038666 and regexp_fields(?1, n.flds, 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131)) or (n.mid = 1712957410517 and n.flds regexp ?1) or (n.mid = 1712957838650 and n.flds regexp ?1) or (n.mid = 1712957410518 and n.flds regexp ?1) or (n.mid = 1712957410519 and n.flds regexp ?1) or (n.mid = 1712957410520 and n.flds regexp ?1) or (n.mid = 1712957410521 and n.flds regexp ?1) or (n.mid = 1712957410522 and n.flds regexp ?1))) order by n.sfld collate nocase asc, c.ord asc", offset: 84 }”, kind: Other }

On my main collection it produces a longer message. The workaround I’m using is to simply have the option disabled on all fields of the related note type.

Appreciate you letting us know, but I’m afraid this is unlikely to be fixed in the near future, as few users are going to hit it.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.