calcjob test failure with sqlite backend about aiida-core HOT 4 CLOSED

This is due to the fact that not all querybuilder syntax is supported by the sqlite implementation. In this case particularly, the has_key filter does not work properly. The test that fails relies on the following query not returning anything (aiida.orm.utils.remote:get_calcjob_remote_paths):

    if only_not_cleaned is True:
        filters_remote['or'] = [
            {f'extras.{RemoteData.KEY_EXTRA_CLEANED}': {'!==': True}},
            {'extras': {'!has_key': RemoteData.KEY_EXTRA_CLEANED}},
        ]

not returning anything. But for the sqlite implementation it ignores that statement.

I am not sure if the implementation could in principle support this filtering key. Haven't looked into it in too much detail either, so might still be worth a shot.

from aiida-core.

Closing as duplicate of #6256

from aiida-core.

One thing that makes me worried here: This seems to be a silent error? Should we raise explicitly if user tries to use code that uses this unsupported feature?

from aiida-core.

That would perhaps be a necessary stop-gap solution until it can be implemented for sqlite, if ever. Let's discuss that in #6256

from aiida-core.