Obviously. That is why I'm confused about this error. The TS-generated
SQL looks like this:
sql_query = SELECT "books"."id" * 2 + 0 AS "id" , "books"."title" AS
"title", "books"."subtitle" AS "subtitle", "books"."keywords" AS
"keywords", "books"."pub_year" AS "pub_year", "books"."id" AS
"sphinx_internal_id", 1809255439 AS "class_crc", 0 AS
"sphinx_deleted", COALESCE("books"."title", '') AS "title_sort",
COALESCE("books"."audience_type", '') AS "audience_type",
crc32("books"."audience_type") AS "audience_type_facet",
COALESCE("books"."author_type", '') AS "author_type",
crc32("books"."author_type") AS "author_type_facet",
COALESCE("books"."format", '') AS "format", crc32("books"."format") AS
"format_facet" FROM "books" WHERE ("books"."id" >= $start
AND "books"."id" <= $end) GROUP BY "books"."id", "books"."title",
"books"."subtitle", "books"."keywords", "books"."pub_year",
"books"."id", "books"."title", "books"."audience_type",
"books"."audience_type", "books"."author_type", "books"."author_type",
"books"."format", "books"."format"
On Nov 5, 11:17 am, Luciano Sousa <[email protected]> wrote:
> tables are not indexed with id = 0
>
> 2010/11/5 crazy_matt <[email protected]>
>
>
>
> > I keep getting the following error when I index:
>
> > ERROR: index 'book_core': sql_range_query: ERROR: index 0 out of
> > valid range, 0..-1
> > CONTEXT: PL/pgSQL function "crc32" line 10 at assignment
>
> > The only information I could find about the index out of range error
> > was for IDs that were enormous. I'm at a loss. Any ideas what may be
> > causing this?
>
> > Matt
>
> > --
> > 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]<thinking-sphinx%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/thinking-sphinx?hl=en.
>
> --
> att: Luciano Sousahttp://www.lucianosousa.net
> <http://www.lucianosousa.net>http://twitter.com/lucianosousa
> *Ruby on Rails Developer
> *Linux User #456387
> *Contato: (21) 7639-5049
--
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.
