Im having this problem where I have 3 entries of Track model in the database, they have title: "testar". when I then try to search to get these 3 record
Track.seach "tes" # witch gives me
Track Load (1.0ms) SELECT "tracks".*, ts_rank(to_tsvector('english', "tracks"."title"::text), plainto_tsquery('english', 'tes'::text)) + ts_rank(to_tsvector('english', "tracks"."territory"::text), plainto_tsquery('english', 'tes'::text)) + ts_rank(to_tsvector('english', "tracks"."country"::text), plainto_tsquery('english', 'tes'::text)) + ts_rank(to_tsvector('english', "tracks"."audio_file"::text), plainto_tsquery('english', 'tes'::text)) AS "rank0.6132058516241189" FROM "tracks" WHERE (to_tsvector('english', "tracks"."title"::text) @@ plainto_tsquery('english', 'tes'::text) OR to_tsvector('english', "tracks"."territory"::text) @@ plainto_tsquery('english', 'tes'::text) OR to_tsvector('english', "tracks"."country"::text) @@ plainto_tsquery('english', 'tes'::text) OR to_tsvector('english', "tracks"."audio_file"::text) @@ plainto_tsquery('english', 'tes'::text)) ORDER BY "rank0.6132058516241189" DESC
=> []
but Track.search "testar" gives me
Track Load (1.2ms) SELECT "tracks".*, ts_rank(to_tsvector('english', "tracks"."title"::text), plainto_tsquery('english', 'testar'::text)) + ts_rank(to_tsvector('english', "tracks"."territory"::text), plainto_tsquery('english', 'testar'::text)) + ts_rank(to_tsvector('english', "tracks"."country"::text), plainto_tsquery('english', 'testar'::text)) + ts_rank(to_tsvector('english', "tracks"."audio_file"::text), plainto_tsquery('english', 'testar'::text)) AS "rank0.6562876665202837" FROM "tracks" WHERE (to_tsvector('english', "tracks"."title"::text) @@ plainto_tsquery('english', 'testar'::text) OR to_tsvector('english', "tracks"."territory"::text) @@ plainto_tsquery('english', 'testar'::text) OR to_tsvector('english', "tracks"."country"::text) @@ plainto_tsquery('english', 'testar'::text) OR to_tsvector('english', "tracks"."audio_file"::text) @@ plainto_tsquery('english', 'testar'::text)) ORDER BY "rank0.6562876665202837" DESC
=> [#<Track id: 1, title: "testar", cataloge_id: 318854401, record_date: "2013-06-03", duration: 182, territory: "AL", country: "AL", quality: 5, category_id: nil, release_year: nil, audio_file: "Bondax_-Gold__Snakehips_Remix.mp3", created_at: "2013-03-14 01:53:01", updated_at: "2013-03-14 01:53:26">, #<Track id: 3, title: "testar", cataloge_id: 318854401, record_date: "2013-06-03", duration: 297, territory: "AL", country: "AL", quality: 5, category_id: nil, release_year: nil, audio_file: "Of_Monsters___Men_-Little_Talks__The_Knocks_Remix...", created_at: "2013-03-14 01:53:01", updated_at: "2013-03-14 01:53:26">]
what could cause it not to find them in the first example ? any help would be appreciated