Hello!
Thanks for reporting. Please find a patch which should fix this.
Give beedback!
>
> >From [EMAIL PROTECTED] Sun Feb 25 22:30:30 2001
> Received: from nagual.pp.ru ([EMAIL PROTECTED] [194.87.13.42])
> by tr155m.krystech.ru (8.9.3/8.9.3) with ESMTP id WAA09427
> for <[EMAIL PROTECTED]>; Sun, 25 Feb 2001 22:30:15 +0300
> Received: from hermes.dialup.ru (hermes.dialup.ru [194.87.16.230])
> by nagual.pp.ru (8.11.2/8.11.2) with ESMTP id f1PJUBB58515
> for <[EMAIL PROTECTED]>; Sun, 25 Feb 2001 22:30:12 +0300 (MSK)
> (envelope-from [EMAIL PROTECTED])
> Date: Sun, 25 Feb 2001 22:30:00 +0300
> From: "Andrey A. Chernov" <[EMAIL PROTECTED]>
> X-Mailer: The Bat! (v1.49)
> X-Priority: 3 (Normal)
> Message-ID: <[EMAIL PROTECTED]>
> X-Confirm-Reading-To: [EMAIL PROTECTED]
> Disposition-Notification-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: 3.1.11: "multi" mode substrings not works with mSQL db
> Mime-Version: 1.0
> Content-Type: text/plain; charset=koi8-r
> Content-Transfer-Encoding: 8bit
>
> According to storage.txt doc:
>
> ""multi" mode with SQL database have a support for substring search."
>
> But in reality {sub,beg,end}string searched only in the dictX where X is
> equal to string length, as mSQL trace log shows:
>
> SELECT url_id,intag FROM dict4 WHERE word LIKE '闻南%'
> ^^^
> ...
> SELECT url_id,intag FROM dict4 WHERE word LIKE '%闻南'
> ...
> SELECT url_id,intag FROM dict4 WHERE word LIKE '%闻南%'
>
> But other dictN's _not_ searched for it! Please send me some patch for
> this.
>
> --
> Andrey A. Chernov
> http://ache.pp.ru/
3.1.11.substr.diff.gz