Displaying 20 results from an estimated 60 matches for "subquerys".
Did you mean:
subquery
2017 Jan 12
2
NEAR non-leaf subqueries
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
>
2017 Jan 20
2
NEAR non-leaf subqueries
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,
2017 Jan 20
0
NEAR non-leaf subqueries
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
2006 Sep 20
3
Can this 1337 PostgreSQL Subquery Union be done in AR?
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
2017 Jan 04
2
NEAR non-leaf subqueries
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
2011 Aug 10
1
subqueries in sqlQuery function (package RODBC)
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
2017 Jan 12
0
NEAR non-leaf subqueries
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
2017 Jan 20
0
NEAR non-leaf subqueries
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
2016 Mar 27
2
PHP5 - Query Parsing Bug
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
2014 Sep 01
2
Escape comma in the LDAP passdb subquery configuration
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
2016 Dec 29
2
NEAR non-leaf subqueries
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
2017 Jan 04
0
NEAR non-leaf subqueries
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
2010 Jun 20
0
ActiveRecord and ARel: correlated subqueries?
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
2019 Jul 01
2
Variable expansion with variables containing '%' (ldap with 2.3.6)
Am Mon, 1 Jul 2019 13:08:46 +0300 (EEST)
schrieb Aki Tuomi <aki.tuomi at open-xchange.com>:
> Hi,
>
> there seems to be a problem when expanding variables containing a
> single '%' in value in dovecot V2.3.6
>
> having a user defined Variable in user_attrs like
>
> user_attrs = name=home=/maildir/%Ln,
> =myvar=path/%L{ldap:sAMAccountName}
>
>
2006 Dec 06
1
Bug and patch for +terms with wildcards
In current Xapian SVN HEAD, there is a bug in the query parser concerned
with the handling of wildcard terms with a "+" prefix. Specifically,
a query such as "+foo* bar" will be parsed by the query parser into
Xapian::Query("bar") if there are no terms in the database which start
"foo". Instead, since the "+" term cannot be matched, I believe
2016 Mar 27
0
PHP5 - Query Parsing Bug
On Sat, Mar 26, 2016 at 07:21:23PM -0500, Yannick Warnier wrote:
> I'm replying to a very old thread (9 years ago) here http://grokbase.com/t/xapian/xapian-discuss/072tprmr6h/php5-query-parsing-bug
It's a fairly safe bet that if you search for an error message and find
a 9 year old message which says it's been fixed, you aren't hitting the
same issue, but rather a different
2011 May 23
1
More relevance for recent documents
Good afternoon
I would like to ask if is possible 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
2019 Jul 02
1
Variable expansion with variables containing '%' (ldap with 2.3.6)
On 2.7.2019 8.24, Aki Tuomi via dovecot wrote:
> On 1.7.2019 13.37, Matthias Lay via dovecot wrote:
>> Am Mon, 1 Jul 2019 13:08:46 +0300 (EEST)
>> schrieb Aki Tuomi <aki.tuomi at open-xchange.com>:
>>
>>> Hi,
>>>
>>> there seems to be a problem when expanding variables containing a
>>> single '%' in value in dovecot V2.3.6
2018 Aug 09
2
Boosted fields search in Python
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),
2019 Jul 02
0
Variable expansion with variables containing '%' (ldap with 2.3.6)
On 1.7.2019 13.37, Matthias Lay via dovecot wrote:
> Am Mon, 1 Jul 2019 13:08:46 +0300 (EEST)
> schrieb Aki Tuomi <aki.tuomi at open-xchange.com>:
>
>> Hi,
>>
>> there seems to be a problem when expanding variables containing a
>> single '%' in value in dovecot V2.3.6
>>
>> having a user defined Variable in user_attrs like
>>