[🐛] 🔥 Query validation may be overly restrictive for inequality filters

[moorea]

Issue

I believe there may be a discrepancy between the firestore query validation logic in FirestoreQueryModifiers.js and Firebase's official documentation regarding inequality filters and orderBy requirements.

The current validation logic in _validateOrderByCheck() enforces that when using an inequality operator (>, <, >=, <=), the first orderBy() must be on the same field as the inequality filter. If not, the query is rejected with the error:

Invalid query. Initial Query.orderBy() parameter: ${orderFieldPath} has to be the same as the Query.where() fieldPath parameter(s): ${filterFieldPath} when an inequality operator is invoked

However, I do not see this specified anywhere in the official Firestore documentation about query limitations.

Using the firestore query builder, I am able to construct and run a query with an inequality filter that does not match the orderBy.

If I fork this repo and remove this block from _validateOrderByCheck():

if (INEQUALITY[filter.operator]) {
  // Initial orderBy() parameter has to match every where() fieldPath parameter when inequality operator is invoked
  if (filterFieldPath !== this._orders[0].fieldPath._toPath()) {
    throw new Error(
      `Invalid query. Initial Query.orderBy() parameter: ${orderFieldPath} has to be the same as the Query.where() fieldPath parameter(s): ${filterFieldPath} when an inequality operator is invoked `,
    );
  }
}

Then from my app, I'm also able to successfully execute the same query pictured above.

There are discussions in the docs around best practices and performance considerations for optimizing indexes, but this appears to be a performance optimization recommendation rather than a hard requirement.

Proposed Discussion Points

• Could this validation be a legacy requirement that's no longer needed?
• Might this be related to the recent work on supporting multiple inequality filters (fix(firestore): remove exception throw on inequality queries on different fields #7885)?
• Should we consider removing or updating this validation logic?

I'm happy to provide additional testing or help investigate further if needed. Let me know if any clarification would be helpful!

---

Project Files

Javascript

Click To Expand

package.json:

# N/A

firebase.json for react-native-firebase v6:

# N/A

iOS

Click To Expand

ios/Podfile:

• I'm not using Pods
• I'm using Pods and my Podfile looks like:

# N/A

AppDelegate.m:

// N/A

---

Android

Click To Expand

Have you converted to AndroidX?

• my application is an AndroidX application?
• I am using android/gradle.settings jetifier=true for Android compatibility?
• I am using the NPM package jetifier for react-native compatibility?

android/build.gradle:

// N/A

android/app/build.gradle:

// N/A

android/settings.gradle:

// N/A

MainApplication.java:

// N/A

AndroidManifest.xml:

<!-- N/A -->

---

Environment

Click To Expand

react-native info output:

 OUTPUT GOES HERE

• Platform that you're experiencing the issue on:
  • iOS
  • Android
  • iOS but have not tested behavior on Android
  • Android but have not tested behavior on iOS
  • Both
• react-native-firebase version you're using that has this issue:
  • e.g. 5.4.3
• Firebase module(s) you're using that has the issue:
  • e.g. Instance ID
• Are you using TypeScript?
  • Y/N & VERSION

---

• 👉 Check out React Native Firebase and Invertase on Twitter for updates on the library.

[azizj1]

_validateOrderByCheck() also gets stuck in a catch-22 and consistently crashes with same error as above if you have multiple inequalities and any orderBy. E.g., this example from firebase docs wouldn't work in this react-native-firebase library:

const q = query(
    collection(db, "cities"),
    where('population', '<', 1000000),
    where('density', '<', 10000),
    orderBy('population') // FAILS. Wants `density` first
  )

fails because it complains that density needs to be the first orderBy. But if you do

const q = query(
    collection(db, "cities"),
    where('population', '<', 1000000),
    where('density', '<', 10000),
    orderBy('density') // FAILS. Wants `population` first
  )

it fails again because now it wants population to be the first.

The following examples also fail:

const q = query(
    collection(db, "cities"),
    where('population', '<', 1000000),
    where('density', '<', 10000),
    orderBy('population'), // FAILS. Wants `density` first
    orderBy('density')
  )

const q = query(
    collection(db, "cities"),
    where('population', '<', 1000000),
    where('density', '<', 10000),
    orderBy('density'), // FAILS. Wants `population` first
    orderBy('population')
  )

[mikehardy]

This is the most likely reason:

Could this validation be a legacy requirement that's no longer needed?

If you propose a PR that works for you we could probably get it merged - some of the e2e tests will likely need a fixup as well to match newly-possible query structure

[github-actions]

Hello 👋, to help manage issues we automatically close stale issues.

This issue has been automatically marked as stale because it has not had activity for quite some time.Has this issue been fixed, or does it still require attention?

This issue will be closed in 15 days if no further activity occurs.

Thank you for your contributions.

[mikehardy]

This is not stale

• see Firestore query modifiers - inequality operator with orderBy #8745
• also [🐛] Cannot execute query with inequality operator and orderBy different field #8534