[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