[BUG]

[xmlanjia]

Data

Product
{
"_id": 1,
"Sn": {"$guid": "28fc0e64-f26a-4423-a9e5-bd435fabb188"},
"GoodsNumber": "DC00001"
}

SELECT $ FROM Product where GoodsNumber like '%00001%'
OK
SELECT $ FROM Product where GoodsNumber like '%01%'
No Data

????

in C#
ILiteQueryable q = db.GetCollection(Lanjia.DB.SysDB.Product).Query();

           var list = q.Where(p => p.GoodsNumber.Contains("00001")) .ToList();

ok

var list = q.Where(p => p.GoodsNumber.Contains("01")) .ToList();
No Data

why????

[ProKn1fe]

Very interesting behavior. Feels like some integer conversion bug.

    public class Issue2254_Tests
    {
        [Fact]
        public void SelectTest()
        {
            var ms = new MemoryStream();
            var litedb = new LiteDatabase(ms);

            var collection = litedb.GetCollection<TestData>();
            collection.Insert(new TestData()
            {
                Guid = Guid.NewGuid(),
                Name = "DC00001"
            });

            var test1 = collection.FindOne(a => a.Name.Contains('0')); // Work
            var test2 = collection.FindOne(a => a.Name.Contains('1')); // Work
            var test3 = collection.FindOne(a => a.Name.Contains("01")); // Not work
            var test4 = collection.FindOne(a => a.Name.Contains("001")); // Not work
            var test5 = collection.FindOne(a => a.Name.Contains("0001")); // Not work
            var test6 = collection.FindOne(a => a.Name.Contains("00001")); // Work
            var test7 = collection.FindOne(a => a.Name.Contains("C00001")); // Work
            var test8 = collection.FindOne(a => a.Name.Contains("DC00001")); // Work
            //Assert.NotNull(item);
        }

        private class TestData
        {
            public Guid Guid { get; set; }
            public string Name { get; set; }
        }
    }

[xmlanjia]

@ProKn1fe Yes, the same to u,hexadecimal?

[ProKn1fe]

No it's not integers bug, it's SqlLike function bug. Actually there is already pull request #2235 (not merged) that fix this.