[Pkg-postgresql-public] Bug#760564: postgresql-9.4: regexp_matches behavior change 9.3 -> 9.4

Jérémy Lal kapouer at melix.org
Fri Sep 5 11:54:45 UTC 2014


Package: postgresql-9.4
Version: 9.4~beta2-1+b1
Severity: normal

Dear Maintainer,

With postgres 9.3 i have
select regexp_matches('gestion/football/ligue-des-champions', '^((?!d{4}-d{1,2}-d{1,2})[^/]+?)(?:/((?!d{4}-d{1,2}-d{1,2})[^/]+?))(?:/((?!d{4}-d{1,2}-d{1,2})[^/]+?))?$', 'g');
             regexp_matches             
----------------------------------------
 {gestion,football,ligue-des-champions}

With postgres 9.4 it returns 0 row. Removing the greedy quantifier at the end
[^/]+? -> [^/]+
makes it return a result again.

Regards,
Jérémy.

-- System Information:
Debian Release: jessie/sid
  APT prefers unstable
  APT policy: (670, 'unstable'), (650, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.16-trunk-amd64 (SMP w/4 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-9.4 depends on:
ii  libc6                  2.19-10
ii  libgssapi-krb5-2       1.12.1+dfsg-9
ii  libldap-2.4-2          2.4.39-1.1+b1
ii  libpam0g               1.1.8-3.1
ii  libpq5                 9.4~beta2-1+b1
ii  libssl1.0.0            1.0.1i-2
ii  libxml2                2.9.1+dfsg1-4
ii  locales                2.19-10
ii  postgresql-client-9.4  9.4~beta2-1+b1
ii  postgresql-common      160
ii  ssl-cert               1.0.34
ii  tzdata                 2014g-1

postgresql-9.4 recommends no packages.

Versions of packages postgresql-9.4 suggests:
pn  locales-all             <none>
pn  oidentd | ident-server  <none>

-- no debconf information



More information about the Pkg-postgresql-public mailing list