Query with a string "01" will fail not considering 0 before 1 as whole string.

[richard457]

brick.Where('name').isNot("01")

[tshedor]

@richard457 can you please take a look at f0bde2a ? This test case succeeds. Does this represent your problem?

[richard457]

@tshedor yes, it represents my problem. Thank you very much.

[tshedor]

@richard457 ok, but this test passes, so is your problem solved?

[richard457]

May you kindly guide me on how to use this change? I have checked on pub.dev and there is no new update.

[tshedor]

There is no change, it's just a test case to validate that the SQL query is being generated as expected

[richard457]

I double-checked unfortunately it does not work on my end, maybe test is faulty.

[tshedor]

You ran the test locally? Is there another way that you can prove the generated SQL is different from the test case?

[tshedor]

@richard457 the test passes in CI, so if the test matches your use case, I think there's something else going on in your app OR there needs to be a different SQLite operator.

I would try running SQLite queries locally against your DB and finding the one that works and reporting it back here