Yes in the example app I have no data, but what about irregular lines
from real app?
How can I avoid TS generate this line?
CONCAT_WS(',', IFNULL(`events`.`space_id`, `iterations`.`space_id`,
`task_entities`.`space_id`, `wiki_pages`.`space_id`, 0))
--
Best regards,
Sergey Avseyev
On Sat, Oct 31, 2009 at 05:50, Pat Allan <[email protected]> wrote:
>
> Hi Sergey
>
> Do you have any data for the polymorphic association? Thinking Sphinx
> doesn't know which tables to join to, otherwise.
>
> --
> Pat
>
> On 31/10/2009, at 12:50 AM, Sergey Avseyev wrote:
>
>>
>> Hi all,
>>
>> I have several model in my application and each model can be
>> commentable. I need to define index in Comment entity, which will
>> contain field from associated model (polymorphic association).
>>
>> I my working project TS generate wrong SQL expression for comment
>> index:
>> http://pastie.org/private/jkmlltoaoxioizpeecxnw
>> source comment_core_0
>> {
>> type = mysql
>> sql_host = localhost
>> sql_user = root
>> sql_pass =
>> sql_db = demo_development
>> sql_sock = /var/run/mysqld/mysqld.sock
>> sql_query_pre = UPDATE `comments` SET `delta` = 0 WHERE `delta` = 1
>> sql_query_pre = SET NAMES utf8
>> sql_query = SELECT `comments`.`id` * 25 + 16 AS `id` ,
>> CAST(`comments`.`contents` AS CHAR) AS `contents`, `comments`.`id` AS
>> `sphinx_internal_id`, 1539927024 AS `class_crc`, IFNULL('1539927024',
>> 0) AS `subclass_crcs`, 0 AS `sphinx_deleted`, CONCAT_WS(',',
>> IFNULL(`events`.`space_id`, `iterations`.`space_id`,
>> `task_entities`.`space_id`, `wiki_pages`.`space_id`, 0)) AS `space_id`
>> FROM `comments` LEFT OUTER JOIN `events` ON `events`.id =
>> `comments`.commentable_id AND `comments`.`commentable_type` = 'Event'
>> LEFT OUTER JOIN `iterations` ON `iterations`.id =
>> `comments`.commentable_id AND `comments`.`commentable_type` =
>> 'Iteration' LEFT OUTER JOIN `task_entities` ON `task_entities`.id =
>> `comments`.commentable_id AND `comments`.`commentable_type` =
>> 'TaskEntity' LEFT OUTER JOIN `wiki_pages` ON `wiki_pages`.id =
>> `comments`.commentable_id AND `comments`.`commentable_type` =
>> 'WikiPage' WHERE `comments`.`id` >= $start AND `comments`.`id` <=
>> $end AND `comments`.`delta` = 0 GROUP BY `comments`.`id` ORDER BY
>> NULL
>> sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
>> FROM `comments` WHERE `comments`.`delta` = 0
>> sql_range_step = 10000000
>> sql_attr_uint = sphinx_internal_id
>> sql_attr_uint = class_crc
>> sql_attr_uint = sphinx_deleted
>> sql_attr_multi = uint subclass_crcs from field
>> sql_attr_multi = uint space_id from field
>> sql_query_info = SELECT * FROM `comments` WHERE `id` = (($id -
>> 16) / 25)
>> }
>>
>> Wrong part is:
>> CONCAT_WS(',', IFNULL(`events`.`space_id`, `iterations`.`space_id`,
>> `task_entities`.`space_id`, `wiki_pages`.`space_id`, 0))
>>
>> Then I tried reproduce the problem on clean environment
>> (http://github.com/avsej/sphinx_test)
>> In this case TS doesn't generate any index for comment entity you can
>> see it there
>> http://github.com/avsej/sphinx_test/blob/master/config/development.sphinx.conf
>>
>> Where am I wrong?
>>
>> --
>>
>> Best regards,
>> Sergey Avseyev
>>
>> >
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
