[appengine-java] Order of index propertis

[John Patterson]

I have a query that is throwing an exception (occasionally) due to the  
order of properties in an index.

the query is like: closed = false AND blocks = x ORDER BY popularity
An exception is thrown on the local datastore:

Query ??? requires the following index:

    <datastore-index kind="H" ancestor="false" source="manual">
        <property name="blocks" direction="asc"/>
        <property name="closed" direction="asc"/>
        <property name="popularity" direction="desc"/>
    </datastore-index>


But I have the following index

        <datastore-index kind="H" ancestor="false" source="manual">
                <property name="closed" direction="asc" />
                <property name="blocks" direction="asc" />
                <property name="popularity" direction="desc" />
        </datastore-index>

Surely that should be OK?  I haven't tried this on the datastore as it  
takes a long time to build the indexes but should the current index  
work there?

Thanks,

JD


-- 

You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group.

To post to this group, send email to google-appengine-j...@googlegroups.com.

To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.