• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisionf0982417a7cacc59199d86bfdd060be7229bb18f (tree)
Time2013-08-08 09:41:07
AuthorTakashi Suzuki <suzuki.takashi@metr...>
CommiterTakashi Suzuki

Log Message

ヒント用テーブルのid列に連番が自動的に付与されることを確認するテストを追加した。

Change Summary

Incremental Difference

--- a/sql/pg_hint_plan.sql
+++ b/sql/pg_hint_plan.sql
@@ -823,7 +823,10 @@ EXPLAIN (COSTS false) SELECT val FROM p1 WHERE val = 1;
823823 EXPLAIN (COSTS false) SELECT val FROM p1 WHERE val = 1;
824824
825825 -- search from hint table
826-INSERT INTO hint_plan.hints (norm_query_string, application_name, hints) VALUES ('EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = ?;', '', 'SeqScan(t1)');
826+INSERT INTO hint_plan.hints (norm_query_string, application_name, hints) VALUES ('EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = ?;', 'psql', 'SeqScan(t1)');
827+INSERT INTO hint_plan.hints (norm_query_string, application_name, hints) VALUES ('EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = ?;', '', 'BitmapScan(t1)');
828+INSERT INTO hint_plan.hints (norm_query_string, application_name, hints) VALUES ('EXPLAIN (COSTS false) SELECT id FROM t1 WHERE t1.id = ?;', '', 'IndexScan(t1)');
829+SELECT * FROM hint_plan.hints ORDER BY id;
827830 SET pg_hint_plan.enable_hint_table = on;
828831 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = 1;
829832 SET pg_hint_plan.enable_hint_table = off;
Show on old repository browser