505088 - Bug search doesn't work when using Cyrillic product name and PostgreSQL DB

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect)

Description

[Raphael Bossek]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; de; rv:1.9.0.11) Gecko/2009061212 Firefox/2.0.0.11 (Debian-3.0.9-1)
Build Identifier: 3.0.4

When using PostgreSQL as a backend database, Bugzilla search doesn't work
with product names containing cyrillic characters.

No error does occur, but the result of the search is always empty.

Steps to reproduce on a fresh Debian Lenny system:

1. dpkg-reconfigure locales
   - enable ru_RU.UTF-8 as default system locale

2. Install bugzilla3, apache2 and PostgreSQL:
   aptitude install bugzilla3 apache2 postgresql-8.3

3. Create PostgreSQL user and database:
   su - postgres
   createrole -P bugs
   createdb -O bugs bugs

4. Edit /etc/bugzilla3/dbconfig-params and /etc/bugzilla3/localconfig
   to use PostgreSQL instead of MySQL: set dbtype to pg, dbuser
   to bugs and password to the database user password.

5. Run dpkg-reconfigure bugzilla3, choose not to reconfigure DB
   (as we have already done that and debconf currently knows nothing
    about PostgreSQL with Bugzilla).

6. Configure apache for bugzilla access by adding stanzas from
   /usr/share/doc/bugzilla3/examples/basic.conf to
   /etc/apache2/sites-enabled/000-default

7. Open bugzilla in browser http://localhost/bugzilla3/.
   Enter administrative login and password.

8. Set parameter specific_search_allow_empty_words to ON
   at the configuration page.

9. Create new product with cyrillic letters in name.
   Create a single component in this new product.

10. Create a single bug for this product. Leave the new bug open.

11. Open default Bugzilla search page, choose the newly created
    product and try to find all open bugs. The search will not
    return the newly created bug from step 10, although it should.


Reproducible: Always

Comment 1

[Raphael Bossek]

Original post at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=531987 by [e-mail]

Comment 2

[Raphael Bossek]

These are the results of additional investigation:

1. When using bugzilla3 Debian package, bug search by product name with
Cyrillic
characters does not work at all - no matter with PostgreSQL or MySQL
backend.
This means that the problem is not limited to PostgreSQL backend.

2. Bugzilla 3.2.3 (downloaded from www.bugzilla.org) works fine. No problems
at all
and pretty nice localization.