Changes between Version 4 and Version 6 of Ticket #2877


Ignore:
Timestamp:
08/30/12 09:53:15 (20 months ago)
Author:
rgrp
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2877

    • Property Owner set to kindly
    • Property Status changed from new to assigned

  • Ticket #2877 – Description

    v4 v6  
    11In progress 
    22 
    3  1. [major] q does not seem to work reliably. e.g. using the setup from this gist https://gist.github.com/1930806 and doing a ?q=DE yields no results (does not work with "q=de" either) 
    4   * q=second does work ... 
     3 1. ~~[major] q does not seem to work reliably. e.g. using the setup from this gist https://gist.github.com/1930806 and doing a ?q=DE yields no results (does not work with "q=de" either)~~ 
     4  * ~~q=second does work ...~~ 
     5 1. [major] q does not work with 2 values (see below) 
    56 2. Query on search with limit 0 results in total of 0 (should either be null or correct total). Queries with other limits yield correct total AFAICT 
    67   * Also weird fact that limit is returned but as as as string - should it not be an integer 
    78 3. Types on fields: could these not be canonical and as per recline (or is it important to allow exact sql types ...) 
    89 
    9 ### Suggestions 
     10=== Multiple query values === 
     11 
     12Try a query such as: "second UK" and you will get 500 error: 
     13 
     14http://localhost:5000/api/3/action/datastore_search?resource_id=4f1299ab-a100-4e5f-ba81-e6d234a2f3bd&q=second%20UK 
     15 
     16{{{ 
     17ProgrammingError: (ProgrammingError) syntax error in tsquery: "second UK" 'select "_id", "id", "date", "x", "y", "z", "country", "title", "lat", "lon", count(*) over() as "_full_count"\n from "4f1299ab-a100-4e5f-ba81-e6d234a2f3bd" where _full_text @@ to_tsquery(%s) limit 100 offset 0' (u'second UK',) 
     18}}} 
     19 
     20=== Suggestions === 
    1021 
    1122Filter support: should think in more detail about this (may want to follow recline style)