Unsure if this is MacOS specific or just something I’m misunderstanding about globs…

SELECT * FROM file where path like "%%"

returns attributes for all files on the filesystem as expected But trying the same query on

extended_attributes

doesn’t seem to work:

SELECT * FROM extended_attributes where path like "%%"

only returns a small number of rows. If I instead do

where path like "%%" or path like "/Users/%%"

I get the much more expected result of thousands of rows. Why do these globs behave differently?