search for: subqueries

...at the patch and have a reworked version which solves the > object lifetime issue and works for some simple tests. Can you try it out > and see if it works for you? > > https://trac.xapian.org/ticket/508#comment:13 > > There are two limitations: > > * Only OP_OR subqueries are handled. I think supporting these would be a > useful step forward by itself, and AIUI it's all you actually need. Yes, my need arises from stem or synonym expansions occurring inside a NEAR query. This happens without the user doing anything special, so it's a problem when it...

Olly Betts writes: > On Thu, Jan 12, 2017 at 07:53:21PM +0100, Jean-Francois Dockes wrote: > > > Recoll also supports multi-word synonyms which could potentially > > generate PHRASE subqueries inside NEAR queries, but this > > understandably already did not work with 1.2, so the multi-word > > expansions are only used when proximity is not involved (by the way, > > proximity of phrases does make sense in this case, if there is a > > wishlist somewhere, but it&...

...the NEAR issue. I follow, but my point was that once we have a patch we're confident works we can merge it in for the next 1.4.x release - so you shouldn't need to consider this as an option anyway. > Recoll also supports multi-word synonyms which could potentially generate > PHRASE subqueries inside NEAR queries, but this understandably already did > not work with 1.2, so the multi-word expansions are only used when proximity > is not involved (by the way, proximity of phrases does make sense in this > case, if there is a wishlist somewhere, but it's admittedly not an issue...

Just wondering if it''s possible, without resorting to find_by_sql. select id, title, datetime, type from ( select id, title, added as datetime, ''items'' as type from items union select id, headline as title, datetime, ''news'' as type from news ) as items order by datetime desc limit 50; I''m also curious if it''s possible in MySQL. Joe

...; and distributes the factors to create something like: > > > > (A NEAR 2 C) OR (B NEAR 2 C) OR (B NEAR 2 C) OR (A NEAR 2 C) > > > > Xapian 1.4 rejects such a query with the error message. > > > > OP_NEAR and OP_PHRASE only currently support leaf subqueries > > > > Because Recoll expands the terms to their stem siblings at query time, its > > NEAR queries are affected by the change (no stemming is used with PHRASE > > queries, so these are unaffected). > > > > Of course, it would be possible to effect the di...

Hi R users. sorry for missing example and if question is to general but I am wondering if it is possible to execute subqueries in function sqlQuery (package RODBC) with opened connection with Excel or SQL server 2000. I couldn't find any example of this. And if it is possible what should be a correct syntax for this query: SELECT ct,COUNT(*) as n FROM (SELECT COUNT(*) AS ct FROM children GROUP BY family_id) AS x GROU...

...ange might be implemented ? I had another poke at the patch and have a reworked version which solves the object lifetime issue and works for some simple tests. Can you try it out and see if it works for you? https://trac.xapian.org/ticket/508#comment:13 There are two limitations: * Only OP_OR subqueries are handled. I think supporting these would be a useful step forward by itself, and AIUI it's all you actually need. * Currently the OP_OR subqueries can only have two subqueries of their own. Lifting this restriction needs a bit of work on the new OrPositionList class - the old pat...

On Fri, Jan 20, 2017 at 03:35:13PM +0100, Jean-Francois Dockes wrote: > Olly Betts writes: > > On Thu, Jan 12, 2017 at 07:53:21PM +0100, Jean-Francois Dockes wrote: > > > > > Recoll also supports multi-word synonyms which could potentially > > > generate PHRASE subqueries inside NEAR queries, but this > > > understandably already did not work with 1.2, so the multi-word > > > expansions are only used when proximity is not involved (by the way, > > > proximity of phrases does make sense in this case, if there is a > > > wishlis...

I'm replying to a very old thread (9 years ago) here http://grokbase.com/t/xapian/xapian-discuss/072tprmr6h/php5-query-parsing-bug So not sure if that's going to end up being more or less readable... I have this error : Fatal error: No matching function for overloaded 'new_Query' in /usr/share/php/xapian.php on line 2607 Line 2607 (and surrounding) looks like this and are in

Hi I have to configure the LDAP passdb to execute a subquery defining dinamically the new DN to use. For example: pass_attrs = @mail=mail=%{login_user},dc=%{login_domain},dc=example,dc=com,\ =proxy=y,\ =host=%{ldap:mailHost at mail} In the previous example, the problem is the use of "," for DN representation, which is also the separator for the attribute

Hi, Xapian 1.2 supports a query like: (A OR B) NEAR (C OR D) and distributes the factors to create something like: (A NEAR 2 C) OR (B NEAR 2 C) OR (B NEAR 2 C) OR (A NEAR 2 C) Xapian 1.4 rejects such a query with the error message. OP_NEAR and OP_PHRASE only currently support leaf subqueries Because Recoll expands the terms to their stem siblings at query time, its NEAR queries are affected by the change (no stemming is used with PHRASE queries, so these are unaffected). Of course, it would be possible to effect the distribution at the application level, but, before I get into this,...

...(A OR B) NEAR (C OR D) > > and distributes the factors to create something like: > > (A NEAR 2 C) OR (B NEAR 2 C) OR (B NEAR 2 C) OR (A NEAR 2 C) > > Xapian 1.4 rejects such a query with the error message. > > OP_NEAR and OP_PHRASE only currently support leaf subqueries > > Because Recoll expands the terms to their stem siblings at query time, its > NEAR queries are affected by the change (no stemming is used with PHRASE > queries, so these are unaffected). > > Of course, it would be possible to effect the distribution at the > application l...

I''m trying to figure out how to use ActiveRecord in conjunction with ARel. In particular, I''d like to replace my residual literal SQL with ARel, if only I could see how. Let''s take Article with multiple Versions as an example. With ARel alone, I can find articles with their latest versions like this articles = Article.arel_table versions = Article.arel_table

...uence of intepreting variables and modifiers changed between 2.2 ans 2.3 now it gets the variable value from remote in the first place, and interprets the value itself for more variables or modifiers, which might not be what you want. like in a subquery using @mail=%{ldap:mailDN} but I dont use subqueries. just a simple expansion =myvar=%{ldap:mailDN} any more ideas?

...to fix this issue, but it requires the introduction of a new query operator, to mark a query as matching no documents (as opposed to a query created with the default query constructor, which represents an undefined query). I've called this operator "OP_MATCH_NOTHING", and it takes no subqueries. I believe this should be public, since it may be useful for people trying to write their own query parsers, rather than relying on the builtin query parser. It's possible that a similar approach would be a neat solution for representing "alldocument" queries. Currently, a special...

...t; new XapianQuery($subquery); Their function doccomment says $extra is an array of arrays, so $subquery is an array. But the code fails to say what operator to use to combine the elements in that array, so the error you're getting seems correct to me. Their should be something like: $subqueries[] = new XapianQuery(XapianQuery::OP_AND, $subquery); Or maybe OP_OR - I'm not really sure what they are trying to do here. Presumably the developers of this software haven't tested cases where $extra is non-empty. Cheers, Olly

...e somehow give more relevance to the recent documents in search results. I dont want to sort results according to the date, I still prefer relevance, but I would like to see recent documents with better scoring. I was trying to add search query using AND_MAYBE, which should use relevance from both subqueries, but it didnt add any benefit to the resalts which are match by this subquery $query = new XapianQuery(XapianQuery::OP_AND_MAYBE, $query, new XapianQuery(XapianQuery::OP_VALUE_GE, self::DATE, date('Ymd000000', strtotime("- 1 year")))); Is there some way how to give more releva...

...gt; now it gets the variable value from remote in the first place, and >> interprets the value itself for more variables or modifiers, which >> might not be what you want. >> >> like in a subquery using >> >> @mail=%{ldap:mailDN} >> >> but I dont use subqueries. just a simple expansion >> >> =myvar=%{ldap:mailDN} >> >> any more ideas? >> >> >> >> >> > I have to investigate this a bit. > > > Aki > Seems to be a bug of a kind. I'll open it in our issue tracker. Aki

...t) but 1. it is not immediately clear to me how to translate the examples given to Python 2. the examples are for boosting single terms, not fields and not multiple-word queries I have implemented a workaround that manually attaches prefixes to terms and combines everything with an OR, like this: subqueries = [] subqueries.extend([xapian.Query(xapian.Query.OP_SCALE_WEIGHT, xapian.Query('S'+term), 4) for term in query_terms]) subqueries.extend([xapian.Query(xapian.Query.OP_SCALE_WEIGHT, xapian.Query('XD'+term), 2) for term in query_terms]) query = xapian.Query(xapian.Query.OP_OR, subque...

...anged > between 2.2 ans 2.3 > now it gets the variable value from remote in the first place, and > interprets the value itself for more variables or modifiers, which > might not be what you want. > > like in a subquery using > > @mail=%{ldap:mailDN} > > but I dont use subqueries. just a simple expansion > > =myvar=%{ldap:mailDN} > > any more ideas? > > > > > I have to investigate this a bit. Aki