[EMAIL PROTECTED] writes:
> >Description:
> When I query using
> "SELECT d1.document_id as document_id_1, d2.document_id as document_id_2,
>sum(d1.weight * d2.weight) as similarity FROM dw_merge as d1 INNER JOIN dw_merge as
>d2 ON d1.word_id=d2.word_id WHERE d1.document_id=5 AND d1.weight > 0.05 AND d2.weight
>> 0.05 GROUP BY document_id_1, document_id_2 ORDER BY similarity DESC limit 0,50;"
> dw_merge table is a MERGE table, it reference to 100 tables.
> The total number of records of the 100 tables is about 400,000 records.
>
> >How-To-Repeat:
> the table schema of the 100 tables is
> "CREATE TABLE document_word (
> document_id int(11) DEFAULT '0' NOT NULL,
> word_id int(11) DEFAULT '0' NOT NULL,
> freq int(6) DEFAULT '0' NOT NULL,
> weight float(7,5) DEFAULT '0.00000' NOT NULL,
> PRIMARY KEY (document_id, word_id),
> KEY word_id (word_id),
> KEY document_id (document_id),
> KEY weight (weight)
> );"
>
Hi!
If you repair all tables contained within MERGE will the above SELECT
still return the same error ??
This is very important for us to know.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
