Skip site navigation (1) Skip section navigation (2)

LIKE bug

From: Moucha Václav <MouchaV(at)Radiomobil(dot)cz>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: LIKE bug
Date: 2000-06-07 08:16:15
Message-ID: 45A23EF28E99D211BDCB00A0C9EA8AB3050C0BDE@rdmkspe02.rdm.cz (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name			:	Vaclav Moucha
Your email address	:	mouchav(at)radiomobil(dot)cz

System Configuration
---------------------
  Architecture (example: Intel Pentium)  		:	Intel
Pentium III/350

  Operating System (example: Linux 2.0.26 ELF) 	:	Linux 2.2.14

  PostgreSQL version (example: PostgreSQL-6.5.1):	postgresql-7.0.1

  Compiler used (example:  gcc 2.8.0)		:	gcc version
egcs-2.91.66 
	
19990314 (egcs-1.1.2 release)

Please enter a FULL description of your problem:
------------------------------------------------
I will find out some bug with like operator if I use locales.

Steps to involve a bug result:

1. Compilation
   ./configure --enable-locale	# not needed for RPMS precompiled binaries 

2. Starting postmaster
   export LC_CTYPE=cs_CZ
   export LC_COLLATE=cs_CZ		# this setting is important for the
bug result
   postmaster -S -D /home/pgsql/data -o '-Fe'	

3. SQL steps
   create table test (name text);
   insert into test values ('á');	# the first char is E1 from LATIN 2
coding
   insert into test values ('áb');
   create index test_index on test (name);
   set cpu_tuple_cost=1;		# force backend to use index
scanning
   select * from test where name like 'á%';

BUG: Only 1 line is selected with 'á' only instead of both lines.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2000-06-07 09:11:39
Subject: Re: Problems with char array set to NULL
Previous:From: Denis PerchineDate: 2000-06-07 07:42:06
Subject: Slightly faster version of vacuumlo

pgsql-bugs by date

Next:From: Sean KellyDate: 2000-06-07 16:41:31
Subject: Bug?
Previous:From: Rudolf WeberDate: 2000-06-06 17:28:29
Subject: libpgtcl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group