search for: subquery

Olly Betts writes: > On Wed, Jan 04, 2017 at 07:29:58AM +0100, Jean-Francois Dockes wrote: > > Olly Betts writes: > > > The ticket has a patch which attempts to handle the OR case (which seems > > > to be the part you actually care about) but this suffers from issues with > > > object lifetimes which get a bit involved in the details. Since there >

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,

On Thu, Jan 12, 2017 at 07:53:21PM +0100, Jean-Francois Dockes wrote: > Olly Betts writes: > > On Wed, Jan 04, 2017 at 07:29:58AM +0100, Jean-Francois Dockes wrote: > > > I'd rather go back to 1.2 than used a patched 1.4 by the way. > > > > Once we have a working patch, it should be mergable into 1.4.x (I can't > > see why any ABI changes would be

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

Olly Betts writes: > On Thu, Dec 29, 2016 at 07:21:41PM +0100, Jean-Francois Dockes wrote: > > 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

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

On Wed, Jan 04, 2017 at 07:29:58AM +0100, Jean-Francois Dockes wrote: > Olly Betts writes: > > The ticket has a patch which attempts to handle the OR case (which seems > > to be the part you actually care about) but this suffers from issues with > > object lifetimes which get a bit involved in the details. Since there > > wasn't a working patch when we got to making

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

...ad-fix.patch But clearly, that's not going to do it now (it was adding a "case 1" to a single-standing "case 0", but now we've got 0, 1, 2, 3 and default). The error appear when trying to instanciate a new XapianQuery object with a query element: new XapianQuery($subquery); (from https://github.com/chamilo/chamilo-lms/blob/1.10.x/main/inc/lib/search/xapian/XapianQuery.php#L44 ) Honestly, I feel comfortable with PHP but this is one of these super-explicit messages that tend to send you in another direction than the one you should go. Assuming the message is co...

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 a...

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

On Thu, Dec 29, 2016 at 07:21:41PM +0100, Jean-Francois Dockes wrote: > 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

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

...lue, coming from the ldap server. seems to me the sequence 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?

...default: DEBUGLINE(UNKNOWN, "Can't parse remainder `" << p - 1 << "'"); throw Xapian::InvalidArgumentError("Invalid query string"); @@ -554,6 +566,68 @@ } } +void +Xapian::Query::Internal::simplify_matchnothing() +{ + subquery_list::iterator sq; + switch (op) { + case OP_PHRASE: + case OP_NEAR: + case OP_AND: + case OP_FILTER: + // Doing an "AND" type operation - if we've got any MATCH_NOTHING + // nodes, we match nothing. + for (sq = subqs.beg...

...e and find a 9 year old message which says it's been fixed, you aren't hitting the same issue, but rather a different issue which gives the same error message. > The error appear when trying to instanciate a new XapianQuery object > with a query element: > > 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...

...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 relevance to the recent documents? Would be solution possible in PHP where is still...

...quence 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? >> >> >> >> >> > I have to investigate this a bit. > > > Aki > S...

Hi, I'm using Xapian in Python2. I'm trying to replicate an analysis that somebody else performed in Lucene. To do that I need to do a search for a multi-word query in which particular fields are boosted - preferably at query time. That is, given a query like "the cat is lying on the mat" (with an OR operator, ignoring word positions but with stemming and stop words removed),

...> seems to me the sequence 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? > > > > > I have to investigate this a bit. Aki