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:
ffa3de3
)
[スキャン方式]試験のSQLファイルの分類名を最新の名前に変更した。
author
Takashi Suzuki
<suzuki.takashi@metrosystems.co.jp>
Mon, 5 Aug 2013 02:00:13 +0000
(11:00 +0900)
committer
Takashi Suzuki
<suzuki.takashi@metrosystems.co.jp>
Mon, 5 Aug 2013 02:00:13 +0000
(11:00 +0900)
sql/ut-S.sql
patch
|
blob
|
history
diff --git
a/sql/ut-S.sql
b/sql/ut-S.sql
index
9002982
..
7b1786d
100644
(file)
--- a/
sql/ut-S.sql
+++ b/
sql/ut-S.sql
@@
-140,7
+140,7
@@
EXPLAIN (COSTS false) SELECT * FROM (SELECT * FROM s1.t1 WHERE t1.c1 = 1) AS s1
EXPLAIN (COSTS false) SELECT * FROM (SELECT * FROM s1.t1 WHERE t1.c1 = 1) AS s1 WHERE s1.c1 = 1;
----
----- No. S-2-1
complexity query block
+---- No. S-2-1
some complexity query blocks
----
-- No. S-2-1-1
@@
-417,7
+417,7
@@
SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)'
;
----
----- No. S-2-3 RULE
definition table
+---- No. S-2-3 RULE
or VIEW
----
-- No. S-2-3-1