CAML query not filtering results

Question

Can someone tell me why the following CAML query is not filtering results? It's returning files that do not contain "/Internal/Bug 594" in their FileRef value. Thanks.

<View Scope='Recursive'>
    <RowLimit>1000</RowLimit>
    <Query>
        <And>
            <Eq>
                <FieldRef Name='FSObjType' />
                <Value Type='Text'>0</Value>
            </Eq>
            <Contains>
                <FieldRef Name='FileRef' />
                <Value Type='Text'>/Internal/Bug 594</Value>
            </Contains>
        </And>
    </Query>
</View>

And here's the code i'm using to execute this query:

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = [the query you see above];

//IEnumerator<ClientOM.List> LibsIterate = null;
ListItemCollection tempItems = LibsIterate.Current.GetItems(camlQuery);

//ClientOM.ClientContext clientContext = null;
clientContext.Load(tempItems);
clientContext.ExecuteQuery();

//List<ListItem> allItems = new List<ListItem>();
allItems.AddRange(tempItems.ToList());

Answer 1

Well, as you already guessed if the CAML query is not syntactically correct it will just run and return everything without applying any filters or ordering.

You don't get any exceptions and this is pretty counter-intuitive.

Answer 2

I think the problem is that the value of the FileRef field contains a space. Try replacing the space with %20 and see if it works.