| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org> |
| Subject: | select like...not using index |
| Date: | 2004-05-28 20:54:50 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB34101AE43@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-hackers-win32 |
Sometime between yesterday and today queries in the form of
"select * from t where t.f like 'k%'" have been broken so that they
never use the index (on win32, not sure about others).
On win32, at least, they have been broken for a while but this was due
to a known issue based on the locales. AFAICT, the current cvs has
addressed this issue and (show lc_collate returns C) there seems to be
no reason why the queries aren't working properly.
Merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-05-28 20:59:13 | Re: Win32, PITR, nested transactions, tablespaces |
| Previous Message | Marc G. Fournier | 2004-05-28 20:54:45 | Re: Win32, PITR, nested transactions, tablespaces |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2004-05-28 20:57:59 | Re: could not locate my own executable path |
| Previous Message | Thomas Swan | 2004-05-28 20:48:32 | could not locate my own executable path |