Upgrading to 1.0.0-dev.83 cause previously working queries to fail

[gmarizy]

Expected Behavior

Same behavior between 1.0.0-dev.82 and 1.0.0-dev.83

Actual Behavior

Some requests fail with error like "You cannot use '!=' filters more than once", even in request where there is only isEqualTo where clauses, after updating to 1.0.0-dev.83.

Steps to Reproduce the Problem

1. Update cloud_firestore_odm from 1.0.0-dev.82 to 1.0.0-dev.83
2. flutter pub run build_runner build --delete-conflicting-outputs
3. run app

Specifications

• Version: 1.0.0-dev.83 (and cloud_firestore either 4.14.0 or 4.15.4)
• Platform: Android

[becjit]

+1
for me it does not return any results

[dorklein]

All my where queries return no result

[becjit]

Yep. I replaced all the queries with direct queries. The only dependency I have is now on model objects.

…

On Wed, Feb 21, 2024 at 4:56 PM Dor Klein ***@***.***> wrote: All my where queries return no result — Reply to this email directly, view it on GitHub <#7 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAQ4MLQBIPSUUMFNXPG7YH3YUXKXFAVCNFSM6AAAAABDCV466OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJWGQ2DKMJUGA> . You are receiving this because you commented.Message ID: ***@***.***>

[FXschwartz]

Same here. All get queries using any kind of .where now return 0 results with no error.

final configs = await configurationRef
          .whereCreatedBy(isEqualTo: userId)
          .wherePartNumber(isEqualTo: partNumber)
          .whereDeleted(isEqualTo: false)
          .get();

Switching to direct queries works

[FXschwartz]

@rrousselGit This looks to be a pretty nasty bug. Do you have some free time to take a look? It might be related to the recent isEqual change.

[mmatook]

I can confirm this behavior.
Turning on debug logging for cloud_firestore shows why the odm queries dont return results.

In my case the generated query with where clause is containing duplicated query fields with each a valid value and a null value using the AND operator. This is not limited to only to isEqual.

Duplicated query fields with null in bold below.

(24.10.1) [QueryEngine]: Using full collection scan to execute query: Query(target=Query(test_collection where created_by==X3xty1MuGBhb951AQ27p54WIU9p2 and created_by==null and is_completed==true and is_completed==null and expires_date>=time(1708821339,589398000) and expires_date!=null order by expires_date, name);limitType=LIMIT_TO_FIRST)

@rrousselGit My best guess is the _WhereMapper is doing double duty with broken logic.

[urbanmania]

I have created a sample project you can use to reproduce this, if that helps.

https://github.com/urbanmania/test_project

If you run it as is you will get the error.

If you comment out this line the error is gone (but also the access control) https://github.com/urbanmania/test_project/blob/0931902c0feb202212a792f9cffe33d74363cd85/lib/main_list_view.dart#L15

It is not the first time I've seen this error, previously it broke and then magically got fixed but broke again with the latest update.

[mmatook]

It appears no maintainer is actively watching this project anymore since the transfer ...
While beeing under firebase/flutterfire there was at least some kind of action.

To me it looks like an abandoned project.

[rrousselGit]

It isn't abandoned by any means. It's not receiving any more or less updates than before.
The previous "weekly release" was just an automatic one made when Firebase was released – bumping side-packages alongside it.
Now that it's in a separate repo, the automatic release doesn't happen anymore, that's all.

There's no real bug here. It's because your ODM version is higher than your Firestore version. You use firestore <4.15.0, but the latest ODM.

I'll bump the minimum Firestore version necessary to fix – and fix a bug specific to arrayContains. But otherwise, it's working well.

[gmarizy]

@rrousselGit my ODM version is not higher than my firestore version; as written in the initial issue, I produce the bug with cloud_firestore version 4.15.4.

I tested again with:
cloud_firestore_odm: 1.0.0-dev.83
cloud_firestore: 4.15.6
and:
cloud_firestore_odm: 1.0.0-dev.84
cloud_firestore: 4.15.6

The bug is still there.

[rrousselGit]

You're right, there is a separate issue specifically with how the ODM passes isNull. I'll fix it