BUG #8970: ts_parse incorrectly split numbers in digit token - Mailing list pgsql-bugs

From marco.atzeri@gmail.com
Subject BUG #8970: ts_parse incorrectly split numbers in digit token
Date
Msg-id 20140125065024.26700.13481@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8970: ts_parse incorrectly split numbers in digit token
Re: BUG #8970: ts_parse incorrectly split numbers in digit token
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8970
Logged by:          Marco Atzeri
Email address:      marco.atzeri@gmail.com
PostgreSQL version: 9.3.2
Operating system:   Cygwin
Description:

Extract from failure comparison.

=====================================
---
/pub/devel/postgresql/postgresql-9.3.2-1/src/postgresql-9.3.2/src/test/regress/expected/tsearch.out
2013-12-02 21:57:48.000000000 +0100
+++
/pub/devel/postgresql/postgresql-9.3.2-1/build/src/test/regress/results/tsearch.out
2014-01-24 19:36:27.625466800 +0100
@@ -267,10 +267,11 @@
 SELECT * FROM ts_parse('default', '345 qwe@efd.r '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/?  ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455
5.005 teodor@stack.net qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1>
ewri2 <a href="qwe<qwe>">
 /usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c
gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234
 <i <b> wow  < jqw <> qwerty');
- tokid |                token
--------+--------------------------------------
-    22 | 345
-    12 |
+ tokid |          token
+-------+-------------------------
+    12 | 3
+    12 | 4
+    12 | 5
      1 | qwe
     12 | @
     19 | efd.r
@@ -283,53 +284,97 @@
      6 | aew.werc.ewr
     18 | /?ad=qwe&dw
     12 |
-     5 | 1aew.werc.ewr/?ad=qwe&dw
-     6 | 1aew.werc.ewr
+    12 | 1
+     5 | aew.werc.ewr/?ad=qwe&dw
+     6 | aew.werc.ewr
     18 | /?ad=qwe&dw
=======================================

current build dependecy
  bash-4.1.10-4
  crypt-1.2-1
  cygwin-1.7.27-2
  gettext-0.18.1.1-2
  libgcc1-4.8.2-2
  libintl8-0.18.1.1-2
  libopenldap2_4_2-2.4.35-2
  libopenssl100-1.0.1f-1
  libreadline7-6.1.2-3
  openldap-devel-2.4.35-2
  openssl-devel-1.0.1f-1
  perl-5.14.2-3
  python-2.7.3-1
  zlib0-1.2.8-1

####################################
extracts from config.log

/pub/devel/postgresql/postgresql-9.3.2-2/src/postgresql-9.3.2/configure
--srcdir=/pub/devel/postgresql/postgresql-9.3.2-2/src/postgresql-9.3.2
--prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin
--libexecdir=/usr/libexec --datadir=/usr/share --localstatedir=/var
--sysconfdir=/etc --libdir=/usr/lib --datarootdir=/usr/share
--docdir=/usr/share/doc/postgresql --htmldir=/usr/share/doc/postgresql/html
-C LDFLAGS=-Wl,-no-undefined --enable-nls --with-openssl --with-perl
--with-python --with-ldap

[cut]

## ----------- ##
## confdefs.h. ##
## ----------- ##

#define PACKAGE_NAME "PostgreSQL"
#define PACKAGE_TARNAME "postgresql"
#define PACKAGE_VERSION "9.3.2"
#define PACKAGE_STRING "PostgreSQL 9.3.2"
#define PACKAGE_BUGREPORT "pgsql-bugs@postgresql.org"
#define PG_VERSION "9.3.2"
#define PG_MAJORVERSION "9.3"
#define USE_INTEGER_DATETIMES 1
#define ENABLE_NLS 1
#define DEF_PGPORT 5432
#define DEF_PGPORT_STR "5432"
#define BLCKSZ 8192
#define RELSEG_SIZE 131072
#define XLOG_BLCKSZ 8192
#define XLOG_SEG_SIZE (16 * 1024 * 1024)
#define ENABLE_THREAD_SAFETY 1
#define PG_KRB_SRVNAM "postgres"
#define USE_LDAP 1
#define USE_SSL 1
#define HAVE_LIBM 1
#define HAVE_LIBREADLINE 1
#define HAVE_LIBZ 1
#define HAVE_SPINLOCKS 1
#define HAVE_LIBCRYPTO 1
#define HAVE_LIBSSL 1
#define STDC_HEADERS 1
#define HAVE_SYS_TYPES_H 1
#define HAVE_SYS_STAT_H 1
#define HAVE_STDLIB_H 1
#define HAVE_STRING_H 1
#define HAVE_MEMORY_H 1
#define HAVE_STRINGS_H 1
#define HAVE_INTTYPES_H 1
#define HAVE_STDINT_H 1
#define HAVE_UNISTD_H 1
#define HAVE_CRYPT_H 1
#define HAVE_GETOPT_H 1
#define HAVE_IEEEFP_H 1
#define HAVE_IFADDRS_H 1
#define HAVE_LANGINFO_H 1
#define HAVE_POLL_H 1
#define HAVE_PWD_H 1
#define HAVE_SYS_IOCTL_H 1
#define HAVE_SYS_IPC_H 1
#define HAVE_SYS_POLL_H 1
#define HAVE_SYS_RESOURCE_H 1
#define HAVE_SYS_SELECT_H 1
#define HAVE_SYS_SEM_H 1
#define HAVE_SYS_SHM_H 1
#define HAVE_SYS_SOCKET_H 1
#define HAVE_SYS_TIME_H 1
#define HAVE_SYS_UN_H 1
#define HAVE_TERMIOS_H 1
#define HAVE_UTIME_H 1
#define HAVE_WCHAR_H 1
#define HAVE_WCTYPE_H 1
#define HAVE_NET_IF_H 1
#define HAVE_NETINET_IN_H 1
#define HAVE_NETINET_TCP_H 1
#define HAVE_READLINE_READLINE_H 1
#define HAVE_READLINE_HISTORY_H 1
#define HAVE_LDAP_H 1
#define PG_USE_INLINE 1
#define HAVE_STRINGIZE 1
#define FLEXIBLE_ARRAY_MEMBER /**/
#define HAVE_FUNCNAME__FUNC 1
#define HAVE__STATIC_ASSERT 1
#define HAVE__BUILTIN_TYPES_COMPATIBLE_P 1
#define HAVE__BUILTIN_CONSTANT_P 1
#define HAVE__BUILTIN_UNREACHABLE 1
#define HAVE__VA_ARGS 1
#define HAVE_TZNAME 1
#define HAVE_UNIX_SOCKETS 1
#define HAVE_STRUCT_SOCKADDR_STORAGE 1
#define HAVE_STRUCT_SOCKADDR_STORAGE_SS_FAMILY 1
#define HAVE_STRUCT_ADDRINFO 1
#define HAVE_INTPTR_T 1
#define HAVE_UINTPTR_T 1
#define HAVE_LONG_LONG_INT 1
#define HAVE_STRUCT_OPTION 1
#define SIZEOF_OFF_T 8
#define HAVE_INT_TIMEZONE /**/
#define ACCEPT_TYPE_RETURN int
#define ACCEPT_TYPE_ARG1 int
#define ACCEPT_TYPE_ARG2 struct sockaddr *
#define ACCEPT_TYPE_ARG3 int
#define HAVE_CBRT 1
#define HAVE_DLOPEN 1
#define HAVE_FDATASYNC 1
#define HAVE_GETIFADDRS 1
#define HAVE_GETRLIMIT 1
#define HAVE_MEMMOVE 1
#define HAVE_POLL 1
#define HAVE_READLINK 1
#define HAVE_SETSID 1
#define HAVE_SIGPROCMASK 1
#define HAVE_SYMLINK 1
#define HAVE_TOWLOWER 1
#define HAVE_UTIME 1
#define HAVE_UTIMES 1
#define HAVE_WCSTOMBS 1
#define HAVE_FSEEKO 1
#define HAVE_FSEEKO 1
#define HAVE_POSIX_FADVISE 1
#define HAVE_DECL_POSIX_FADVISE 1
#define HAVE_DECL_FDATASYNC 1
#define HAVE_DECL_STRLCAT 1
#define HAVE_DECL_STRLCPY 1
#define HAVE_DECL_F_FULLFSYNC 0
#define HAVE_IPV6 1
#define HAVE_SNPRINTF 1
#define HAVE_VSNPRINTF 1
#define HAVE_DECL_SNPRINTF 1
#define HAVE_DECL_VSNPRINTF 1
#define HAVE_ISINF 1
#define HAVE_CRYPT 1
#define HAVE_GETOPT 1
#define HAVE_GETRUSAGE 1
#define HAVE_INET_ATON 1
#define HAVE_RANDOM 1
#define HAVE_RINT 1
#define HAVE_SRANDOM 1
#define HAVE_STRERROR 1
#define HAVE_STRLCAT 1
#define HAVE_STRLCPY 1
#define HAVE_UNSETENV 1
#define HAVE_GETPEEREID 1
#define HAVE_GETADDRINFO 1
#define HAVE_GETOPT_LONG 1
#define HAVE_SIGSETJMP 1
#define HAVE_DECL_SYS_SIGLIST 1
#define HAVE_SYSLOG 1
#define HAVE_INT_OPTERR 1
#define HAVE_INT_OPTRESET 1
#define HAVE_STRTOLL 1
#define HAVE_STRTOULL 1
#define HAVE_GCC_INT_ATOMICS 1
#define HAVE_RL_COMPLETION_APPEND_CHARACTER 1
#define HAVE_RL_COMPLETION_MATCHES 1
#define HAVE_RL_FILENAME_COMPLETION_FUNCTION 1
#define HAVE_APPEND_HISTORY 1
#define HAVE_HISTORY_TRUNCATE_FILE 1
#define HAVE_STRERROR_R 1
#define HAVE_GETPWUID_R 1
#define GETPWUID_R_5ARG /**/
#define STRERROR_R_INT /**/
#define HAVE_LIBLDAP 1
#define HAVE_LIBLDAP_R 1
#define HAVE_LONG_LONG_INT_64 1
#define PG_INT64_TYPE long long int
#define HAVE_LL_CONSTANTS 1
#define INT64_FORMAT "%lld"
#define UINT64_FORMAT "%llu"
#define SIZEOF_VOID_P 4
#define SIZEOF_SIZE_T 4
#define SIZEOF_LONG 4
#define USE_FLOAT4_BYVAL 1
#define FLOAT4PASSBYVAL true
#define FLOAT8PASSBYVAL false
#define ALIGNOF_SHORT 2
#define ALIGNOF_INT 4
#define ALIGNOF_LONG 4
#define ALIGNOF_LONG_LONG_INT 8
#define ALIGNOF_DOUBLE 8
#define MAXIMUM_ALIGNOF 8
#define HAVE_SIG_ATOMIC_T 1
#define HAVE_POSIX_SIGNALS /**/
#define USE_SYSV_SEMAPHORES 1
#define USE_SYSV_SHARED_MEMORY 1
#define MEMSET_LOOP_LIMIT 1024
#define PG_VERSION_STR "PostgreSQL 9.3.2 on i686-pc-cygwin, compiled by gcc
(GCC) 4.8.2, 32-bit"
#define PG_VERSION_NUM 90302

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 9.3.2 Server crashes upon start
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #8970: ts_parse incorrectly split numbers in digit token