Index search problem

[Magdalena Tytkowska]

Hi, I have a problem with an index search. To reproduce this issue, first you have to create some example models, for example like in the attached picture.

Then I created a new index like this one

Then if I run this query: 

@in<ExampleIdString>:(ExampleModels/2f7392c1\-dc2b\-4199\-9e40\-4d4fc6758c92,ExampleModels/a04abe17\-301a\-4a90\-b1ce\-a6bf7590dd5f,ExampleModels/8f6ff28c\-6923\-4737\-b0c1\-6e2b7134036,ExampleModels/90ce55c0\-d3a8\-4982\-af33\-85a7d525ae01,ExampleModels/3be3bdbc\-34a1\-48d4\-aa28\-de5bc873d510,ExampleModels/5) 

I won't get any results, but if I add a space just before ExampleModels/5, like this:

@in<ExampleIdString>:(ExampleModels/2f7392c1\-dc2b\-4199\-9e40\-4d4fc6758c92,ExampleModels/a04abe17\-301a\-4a90\-b1ce\-a6bf7590dd5f,ExampleModels/8f6ff28c\-6923\-4737\-b0c1\-6e2b7134036,ExampleModels/90ce55c0\-d3a8\-4982\-af33\-85a7d525ae01,ExampleModels/3be3bdbc\-34a1\-48d4\-aa28\-de5bc873d510, ExampleModels/5)

I get the specified models.

Am I correctly defining this query or not? Maybe this issue is caused by something else?

[Fitzchak Yitzchaki]

Hello,

First of all, the index doesn't make sense as your'e doing map reduce on an ID but ID is unique. In this case it is the same as going with just a map.

Second, it may be that in this case ExampleModels/5 id has a leading space? like " ExampleModels/5"?

What version of RavenDB are you using?

Please send us a failing test that reproduce the issue: http://ravendb.net/docs/article-page/3.5/Csharp/server/troubleshooting/sending-support-ticket#writing-unit-tests

Best Regards,

Hibernating Rhinos Ltd  

Fitzchak Yitzchaki l Senior Software Engineer l Mobile:+972-58-345-9538

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Magdalena Tytkowska]

I'm using 3.0 version. I hope I created this test correctly:

public class NoResultTestClass : RavenTestBase

    {

        public class ExampleModel

        {

            public string Id;

            public string SearchString;

        }

        public class ExampleIndex : AbstractIndexCreationTask<ExampleModel>

        {

            public ExampleIndex()

            {

                Map = examples => from example in examples

                                  select new

                                  {

                                      Id = example.Id,

                                      SearchString = example.SearchString

                                  };

                Index(x => x.SearchString, FieldIndexing.Analyzed);

            }

        }

        

        [Fact]

        public void NoResultTestMethod()

        {

            using (DocumentStore store = NewRemoteDocumentStore())

            {

                new ExampleIndex().Execute(store);

                using (var session = store.OpenSession())

                {

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/90ce55c0-d3a8-4982-af33-85a7d525ae01",

                        Id = "a"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/3be3bdbc-34a1-48d4-aa28-de5bc873d510",

                        Id = "b"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/2f7392c1-dc2b-4199-9e40-4d4fc6758c92",

                        Id = "c"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/a04abe17-301a-4a90-b1ce-a6bf7590dd5f",

                        Id = "d"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/8f6ff28c-6923-4737-b0c1-6e2b7134036",

                        Id = "e"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/6",

                        Id = "f"

                    });

                    session.Store(new ExampleModel

                    {

                        SearchString = "ExampleModels/7",

                        Id = "g"

                    });

                    session.SaveChanges();

                }

                WaitForIndexing(store);

                using (var session = store.OpenSession())

                {

                    var ids = new List<string> { "ExampleModels/90ce55c0-d3a8-4982-af33-85a7d525ae01", "ExampleModels/3be3bdbc-34a1-48d4-aa28-de5bc873d510", "ExampleModels/2f7392c1-dc2b-4199-9e40-4d4fc6758c92", "ExampleModels/a04abe17-301a-4a90-b1ce-a6bf7590dd5f", "ExampleModels/8f6ff28c-6923-4737-b0c1-6e2b7134036" };

                    var examples1Query = session.Advanced.DocumentQuery<ExampleModel, ExampleIndex>().WhereIn(x => x.SearchString, ids);

                    var examples1 = examples1Query.ToList();

                    ids.Add("ExampleModels/6");

                    var examples2Query = session.Advanced.DocumentQuery<ExampleModel, ExampleIndex>().WhereIn(x => x.SearchString, ids);

                    var examples2 = examples2Query.ToList();

                    Assert.Equal(5, examples1.Count);

                    Assert.Equal(6, examples2.Count);

                }

            }

        }

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.

[Oren Eini (Ayende Rahien)]

This tests passes

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+unsubscribe@googlegroups.com.

[Oren Eini (Ayende Rahien)]

https://github.com/ayende/ravendb/blob/v3.5/Raven.Tests.MailingList/Tytkowska.cs

[Magdalena Tytkowska]

And what version of .NET framework are you using? To be precise I'm using .NET Framework 4.5.2 and Raven 3.0.30153

[Oren Eini (Ayende Rahien)]

I tested that on 3.5, please check it there.

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+unsubscribe@googlegroups.com.

[Magdalena Tytkowska]

I just tested it, and you're right that it's working on Raven 3.5, but still Raven 3.5 is not yet a stable version and I don't want to use it yet. What do you suggest in this situation?

[Idan Haim]

Hi,

Thank you for notice us.

Going to make some test to try solve this problem.

You can track the progress here: http://issues.hibernatingrhinos.com/issue/RavenDB-5228

[Idan Haim]

We manage to fix the issue 

just update your client after the merge.

Thank you