Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2E4BF63221A for ; Fri, 26 Feb 2010 20:16:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37655-03 for ; Sat, 27 Feb 2010 00:16:48 +0000 (UTC) X-Greylist: delayed 00:05:43.72163 by SQLgrey-1.7.6 Received: from data-2.beotel.net (data-2.beotel.net [194.106.162.47]) by mail.postgresql.org (Postfix) with ESMTP id 679CC6333F5 for ; Fri, 26 Feb 2010 20:16:48 -0400 (AST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AvQEAOPxh0vCaqIY/2dsb2JhbACDBZc/gU6rL5AkgTSCXGkEi0s Received: from windu.beotel.net (HELO aine.beotel.net) ([194.106.162.24]) by data-2.beotel.net with ESMTP; 27 Feb 2010 01:13:34 +0100 Received: from localhost ([194.106.162.24]) by aine.beotel.net (IceWarp 9.4.2) with SMTP id JCN60410; Sat, 27 Feb 2010 01:12:10 +0100 Date: Sat, 27 Feb 2010 01:12:10 +0100 From: Administrator Reply-To: Administrator To: pgsql-bugs@postgresql.org Subject: Message-ID: X-Mailer: IceWarp Web Mail 5.6.7 X-Originating-IP: 93.86.142.234 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.022 tagged_above=-10 required=5 tests=BAYES_20=-0.74, MISSING_SUBJECT=1.762 X-Spam-Level: * X-Archive-Number: 201002/338 X-Sequence-Number: 26124 Logged by: Michael Kopljan email: admin@navigator-info.com PostgreSQL version: 8.4.2 Operating system: Windows 2008 Server Description: bug in string comparison Details: -- Drop DROP TABLE IF EXISTS "public"."test" ; -- Definition CREATE TABLE "public"."test" ( "id_robe" INTEGER NOT NULL, "sifra" VARCHAR(15) NOT NULL, "naziv" VARCHAR(50) NOT NULL, PRIMARY KEY("id_robe") ) WITH OIDS; ALTER TABLE "public"."test" ALTER COLUMN "id_robe" SET STATISTICS 0; ALTER TABLE "public"."test" ALTER COLUMN "sifra" SET STATISTICS 0; ALTER TABLE "public"."test" ALTER COLUMN "naziv" SET STATISTICS 0; COMMENT ON COLUMN "public"."test"."id_robe" IS 'PK'; -- Data INSERT INTO "public"."test" VALUES(1, 'PDTT18', 'POD TT18') ; INSERT INTO "public"."test" VALUES(2, 'K-K8-8', 'kutija 840x410x145') ; INSERT INTO "public"."test" VALUES(3, 'ZDTT25', 'ZID TT25') ; INSERT INTO "public"."test" VALUES(4, 'ZDW18' , 'ZID W18') ; INSERT INTO "public"."test" VALUES(5, 'ZDTT18', 'ZID TT18') ; INSERT INTO "public"."test" VALUES(6, 'ZDOR18', 'ZID OR18') ; INSERT INTO "public"."test" VALUES(7, 'ZDX18' , 'ZID X18') ; INSERT INTO "public"."test" VALUES(8, 'ZDW25' , 'ZID W25') ; ----------- -- QUERY -- ----------- --Query#1 (In PostgreSQL 8.2 returns all rows, but in 8.4 only 2 rows? Select t1.* From public.test t1 Where t1.sifra BETWEEN '%' AND 'z%' ; --Query#2 (In PostgreSQL 8.2 returns 0 rows, but in 8.4 only 2 rows? Select t1.* From public.test t1 Where t1.sifra BETWEEN 'a%' AND 'z%' ; --Query#3 (In PostgreSQL 8.2 returns all rows and in 8.4 returns all rows! Select t1.* From public.test t1 Where t1.sifra BETWEEN '%' AND 'zz%' ; -- BUG -- In field "sifra" data is stored in UPPER CASE, why query#1 don't return all data in 8.4? -- In field "sifra" data is stored in UPPER CASE, why query#2 return 2 rows in 8.4? -- Why, in query#3, must for second parameter of BETWEEN operator use "zz%" instead "z%" (that work on 8.2) to get all rows?