From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Administrator <admin(at)navigator-info(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2010-03-01 14:38:37 |
Message-ID: | 603c8f071003010638v5e5c3b86m728408fa2d48b759@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, Feb 26, 2010 at 7:12 PM, Administrator <admin(at)navigator-info(dot)com> wrote:
> Logged by: Michael Kopljan
> email: admin(at)navigator-info(dot)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?
My thought is that you must have different locale/encoding settings on
your 8.2 database than you do on your 8.4 database.
...Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-03-01 14:50:59 | Re: BUG #5338: PG_DUMP fails due to invalid adnum value |
Previous Message | Oleg Serov | 2010-03-01 09:25:47 | Re: Bug in procedure When you modificate table |