BUG #3493: Cannot find data with = operator
От | Michal Niklas |
---|---|
Тема | BUG #3493: Cannot find data with = operator |
Дата | |
Msg-id | 200707271011.l6RABgbG022579@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3493: Cannot find data with = operator
Re: BUG #3493: Cannot find data with = operator |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3493 Logged by: Michal Niklas Email address: mn@heuthes.pl PostgreSQL version: 8.1.9 Operating system: Linux, x86-64, debian Description: Cannot find data with = operator Details: I cannot find just inserted data with = operator. It can be found if I use LIKE. My SQL looks like: begin; select version(); insert into customers (name) values ('KIOSK '); select id,name from customers where name='KIOSK '; select id,name from customers where name like 'KIOSK '; rollback; Result on my psql console: isof_customer=# select version(); version ---------------------------------------------------------------------------- ------------------------------------- PostgreSQL 8.1.9 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) (1 row) isof_customer=# insert into customers (name) values ('KIOSK '); INSERT 437819002 1 isof_customer=# select id,name from customers where name='KIOSK '; id | name ---------------+------------------ (0 rows) isof_customer=# select id,name from customers where name like 'KIOSK '; id | name ---------------+------------------ 218856 | KIOSK (1 row) This is problem in just one table in one database. It works as expected on just created tmp table and on other customers databases. It works if I change 'KIOSK ' to other text. I tried 'vacuum analyze' on this table but it didn't help. Regards, Michal Niklas HEUTHES Poland
В списке pgsql-bugs по дате отправления: