OSDN > 軟體搜索 > Use planner hints on PostgreSQL > SCM > git > pg_hint_plan > 提交

Use planner hints on PostgreSQL
Fork

pg_hint_plan: 提交

firtst release

修訂	1407e83006c68de21748d64b0b55579a82a9679c (tree)
時間	2017-05-19 14:00:32
作者	Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
Commiter	Kyotaro Horiguchi

Change version to 1.1.4

1.1.3 has a crash bug raised by queries in specific shape involving
complex views and/or SQL functions.

It is fixed in this version.

--- a/COPYRIGHT

+++ b/COPYRIGHT

		@@ -1,4 +1,4 @@
1		-Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
	1	+Copyright (c) 2012-2017, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
2	2	All rights reserved.
3	3
4	4	Redistribution and use in source and binary forms, with or without

--- a/Makefile

+++ b/Makefile

		@@ -1,11 +1,11 @@
1	1	#
2	2	# pg_hint_plan: Makefile
3	3	#
4		-# Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
	4	+# Copyright (c) 2012-2017, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
5	5	#
6	6
7	7	MODULES = pg_hint_plan
8		-HINTPLANVER = 1.1.3
	8	+HINTPLANVER = 1.1.4
9	9
10	10	REGRESS = init base_plan pg_hint_plan ut-init ut-A ut-S ut-J ut-L ut-G ut-R ut-fdw ut-fini
11	11

		@@ -14,7 +14,8 @@ REGRESSION_EXPECTED = expected/init.out expected/base_plan.out expected/pg_hint_
14	14	REGRESS_OPTS = --encoding=UTF8
15	15
16	16	EXTENSION = pg_hint_plan
17		-DATA = pg_hint_plan--1.1.3.sql pg_hint_plan--1.1.2--1.1.3.sql
	17	+DATA = pg_hint_plan--1.1.4.sql pg_hint_plan--1.1.3--1.1.4.sql \
	18	+ pg_hint_plan--1.1.2--1.1.3.sql
18	19
19	20	EXTRA_CLEAN = sql/ut-fdw.sql expected/ut-fdw.out
20	21

		@@ -32,6 +33,8 @@ TARSOURCES = Makefile .c .h COPYRIGHT* \
32	33	doc/* expected/.out sql/.sql sql/maskout.sh \
33	34	data/data.csv input/.source output/.source SPECS/*.spec
34	35
	36	+LDFLAGS+=-Wl,--build-id
	37	+
35	38	installcheck: $(REGRESSION_EXPECTED)
36	39
37	40	rpms: rpm94

--- a/SPECS/pg_hint_plan94.spec

+++ b/SPECS/pg_hint_plan94.spec

		@@ -1,5 +1,5 @@
1	1	# SPEC file for pg_hint_plan
2		-# Copyright(C) 2012-2014 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
	2	+# Copyright(C) 2012-2017 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
3	3
4	4	%define _pgdir /usr/pgsql-9.4
5	5	%define _bindir %{_pgdir}/bin

		@@ -13,7 +13,7 @@
13	13	## Set general information for pg_hint_plan.
14	14	Summary: Optimizer hint for PostgreSQL 9.4
15	15	Name: pg_hint_plan94
16		-Version: 1.1.3
	16	+Version: 1.1.4
17	17	Release: 1%{?dist}
18	18	License: BSD
19	19	Group: Applications/Databases

		@@ -61,7 +61,8 @@ install -d %{buildroot}%{_libdir}
61	61	install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so
62	62	install -d %{buildroot}%{_datadir}/extension
63	63	install -m 644 pg_hint_plan--1.1.2--1.1.3.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.2--1.1.3.sql
64		-install -m 644 pg_hint_plan--1.1.3.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3.sql
	64	+install -m 644 pg_hint_plan--1.1.3--1.1.4.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3--1.1.4.sql
	65	+install -m 644 pg_hint_plan--1.1.4.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.4.sql
65	66	install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control
66	67
67	68	%clean

		@@ -72,11 +73,14 @@ rm -rf %{buildroot}
72	73	%{_libdir}/pg_hint_plan.so
73	74	%defattr(0644,root,root)
74	75	%{_datadir}/extension/pg_hint_plan--1.1.2--1.1.3.sql
75		-%{_datadir}/extension/pg_hint_plan--1.1.3.sql
	76	+%{_datadir}/extension/pg_hint_plan--1.1.3--1.1.4.sql
	77	+%{_datadir}/extension/pg_hint_plan--1.1.4.sql
76	78	%{_datadir}/extension/pg_hint_plan.control
77	79
78	80	# History of pg_hint_plan.
79	81	%changelog
	82	+* Fri May 19 2017 Kyotaro Horiguchi
	83	+- Fixed a crash bug.
80	84	* Thu Dec 22 2014 Kyotaro Horiguchi
81	85	- Bug fix related to pl/pgsql.
82	86	* Thu Dec 17 2014 Kyotaro Horiguchi

--- /dev/null

+++ b/pg_hint_plan--1.1.3--1.1.4.sql

		@@ -0,0 +1,4 @@
	1	+/* pg_hint_plan/pg_hint_plan--1.1.3--1.1.4.sql */
	2	+
	3	+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
	4	+\echo Use "ALTER EXTENSION pg_hint_plan UPDATE" to load this file. \quit

--- a/pg_hint_plan--1.1.3.sql

+++ b/pg_hint_plan--1.1.4.sql

		@@ -1,4 +1,4 @@
1		-/* pg_hint_plan/pg_hint_plan--1.1.3.sql */
	1	+/* pg_hint_plan/pg_hint_plan--1.1.4.sql */
2	2
3	3	-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4	4	\echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit

--- a/pg_hint_plan.c

+++ b/pg_hint_plan.c

		@@ -4,7 +4,7 @@
4	4	* do instructions or hints to the planner using C-style block comments
5	5	* of the SQL.
6	6	*
7		- * Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
	7	+ * Copyright (c) 2012-2017, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
8	8	*
9	9	*-------------------------------------------------------------------------
10	10	*/

--- a/pg_hint_plan.control

+++ b/pg_hint_plan.control