Fixes from Janko Richter <jankorichter@yahoo.de>

- Fix wrong index results on text, char, varchar for multibyte strings
- Fix some SIGFPE signals
- Add support for infinite timestamps
- Because of locale settings, btree_gist can not be a prefix index anymore (for text).
  Each node holds now just the lower and upper boundary.

3 files changed, 508 insertions, 0 deletions

diff --git a/contrib/btree_gist/data/char.data b/contrib/btree_gist/data/char.data
index 72dc75604c2..99bb6abedf2 100644
--- a/contrib/btree_gist/data/char.data
+++ b/contrib/btree_gist/data/char.data
@@ -532,3 +532,469 @@ c30f7472766d25af1dc80
 7c5aba41f53293b712fd
 3
 166d77ac1b46a1ec38aa
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/contrib/btree_gist/data/timestamp.data b/contrib/btree_gist/data/timestamp.data
index 34d50151c90..065bc507754 100644
--- a/contrib/btree_gist/data/timestamp.data
+++ b/contrib/btree_gist/data/timestamp.data
@@ -341,6 +341,14 @@
 2002-10-29 03:21:13
 2000-06-22 14:23:04
 1981-01-01 00:15:56
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
 2001-12-31 12:30:28
 2003-09-25 04:51:05
 2020-12-07 22:47:38
@@ -557,6 +565,14 @@
 2002-09-19 07:59:10
 2016-03-16 14:50:17
 1986-02-06 02:57:29
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
 2018-07-07 23:37:36
 1972-02-07 07:48:10
 2001-05-06 17:04:36
@@ -590,6 +606,14 @@
 2008-08-01 06:57:47
 2032-11-22 15:34:23
 1976-01-04 02:56:30
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
 2037-04-11 12:30:59
 2011-02-24 11:33:55
 1992-11-16 04:53:09
diff --git a/contrib/btree_gist/data/timestamptz.data b/contrib/btree_gist/data/timestamptz.data
index f67bb189be9..7f07cdcc274 100644
--- a/contrib/btree_gist/data/timestamptz.data
+++ b/contrib/btree_gist/data/timestamptz.data
@@ -393,6 +393,12 @@
 2004-01-28 20:45:12 GMT+0
 1991-03-21 13:23:37 GMT-5
 2029-07-26 06:01:08 GMT+9
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
 2002-11-15 19:24:22 GMT
 1987-05-02 16:25:01 GMT-6
 1999-04-01 05:54:41 GMT-2
@@ -422,6 +428,12 @@
 1984-10-17 02:42:50 GMT-7
 2001-04-29 03:59:54 GMT-1
 1996-08-15 07:16:34 GMT-3
+infinity
+infinity
+infinity
+infinity
+infinity
+infinity
 \N
 1974-02-10 02:40:01 GMT-11
 2033-03-28 21:51:56 GMT+10
@@ -475,6 +487,12 @@
 1973-06-15 06:34:08 GMT-11
 1976-03-21 22:21:06 GMT-10
 1976-06-15 07:14:46 GMT-10
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
+-infinity
 1972-01-15 06:30:22 GMT-11
 1971-08-06 10:41:43 GMT-11
 1995-08-21 21:12:06 GMT-3