OSDN Git Service
(root)
/
pghintplan
/
pg_hint_plan.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
516e175
)
試験対象の文字の種類が不足していたため追加した。
author
Takashi Suzuki
<suzuki.takashi@metrosystems.co.jp>
Mon, 5 Aug 2013 05:43:16 +0000
(14:43 +0900)
committer
Takashi Suzuki
<suzuki.takashi@metrosystems.co.jp>
Mon, 5 Aug 2013 05:43:16 +0000
(14:43 +0900)
sql/ut-A.sql
patch
|
blob
|
history
diff --git
a/sql/ut-A.sql
b/sql/ut-A.sql
index
577c62f
..
1bb5649
100644
(file)
--- a/
sql/ut-A.sql
+++ b/
sql/ut-A.sql
@@
-71,7
+71,7
@@
EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
-- No. A-5-2-2
-EXPLAIN (COSTS false) SELECT c1 /*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;
+EXPLAIN (COSTS false) SELECT c1
, c2 AS c_2
/*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;
-- No. A-5-2-3
EXPLAIN (COSTS false) SELECT c1 AS "c1"/*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;