| リビジョン | 5946ec096b22d1b0b05470b0aaa8f869c911a205 (tree) |
|---|---|
| 日時 | 2013-12-24 16:00:56 |
| 作者 | Takashi Suzuki <suzuki.takashi@metr...> |
| コミッター | Takashi Suzuki |
スキャン方式試験の番号のずれを修正した。
sql/ut-S.sql (diff)| @@ -935,29 +935,29 @@ EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1; | ||
| 935 | 935 | EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1; |
| 936 | 936 | |
| 937 | 937 | ---- |
| 938 | ----- No. S-3-11 inheritance table specified table | |
| 938 | +---- No. S-3-10 inheritance table specified table | |
| 939 | 939 | ---- |
| 940 | 940 | |
| 941 | 941 | EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1; |
| 942 | 942 | |
| 943 | --- No. S-3-11-1 | |
| 943 | +-- No. S-3-10-1 | |
| 944 | 944 | /*+IndexScan(p2)*/ |
| 945 | 945 | EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1; |
| 946 | 946 | |
| 947 | --- No. S-3-11-2 | |
| 947 | +-- No. S-3-10-2 | |
| 948 | 948 | /*+IndexScan(p2c1)*/ |
| 949 | 949 | EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1; |
| 950 | 950 | |
| 951 | --- No. S-3-11-3 | |
| 951 | +-- No. S-3-10-3 | |
| 952 | 952 | EXPLAIN SELECT c4 FROM s1.p1 WHERE c2 * 2 < 100 AND c1 < 10; |
| 953 | 953 | /*+IndexScan(p1 p1_parent)*/ |
| 954 | 954 | EXPLAIN SELECT c4 FROM s1.p1 WHERE c2 * 2 < 100 AND c1 < 10; |
| 955 | 955 | |
| 956 | --- No. S-3-11-4 | |
| 956 | +-- No. S-3-10-4 | |
| 957 | 957 | /*+IndexScan(p1 p1_i2)*/ |
| 958 | 958 | EXPLAIN SELECT c2 FROM s1.p1 WHERE c2 = 1; |
| 959 | 959 | |
| 960 | --- No. S-3-11-5 | |
| 960 | +-- No. S-3-10-5 | |
| 961 | 961 | /*+IndexScan(p2 p2c1_pkey)*/ |
| 962 | 962 | EXPLAIN (COSTS true) SELECT * FROM s1.p2 WHERE c1 = 1; |
| 963 | 963 |
Fork