Repository navigation
Expand file tree
/
Copy pathPostgresqlExplainTest.java
More file actions
112 lines (106 loc) · 5.01 KB
/
Copy pathPostgresqlExplainTest.java
File metadata and controls
112 lines (106 loc) · 5.01 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
/*-
* #%L
* JSQLParser library
* %%
* Copyright (C) 2004 - 2026 JSQLParser
* %%
* Dual licensed under GNU LGPL 2.1 or Apache License 2.0
* #L%
*/
package net.sf.jsqlparser.statement;
import static org.junit.jupiter.api.Assertions.*;
import java.util.List;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.parser.AbstractJSqlParser.Dialect;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.statement.ExplainStatement.Option;
import net.sf.jsqlparser.statement.ExplainStatement.OptionType;
import net.sf.jsqlparser.test.TestUtils;
import net.sf.jsqlparser.util.TablesNamesFinder;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.params.ParameterizedTest;
import org.junit.jupiter.params.provider.ValueSource;
class PostgresqlExplainTest {
@ParameterizedTest
@ValueSource(strings = {
"EXPLAIN SELECT 1",
"EXPLAIN ANALYZE VERBOSE SELECT 1",
"EXPLAIN (ANALYZE, VERBOSE, COSTS, BUFFERS) SELECT 1",
"EXPLAIN (ANALYZE TRUE, VERBOSE ON, COSTS OFF, BUFFERS FALSE) SELECT 1",
"EXPLAIN (ANALYZE 1, COSTS 0, FORMAT TEXT) SELECT 1",
"EXPLAIN (FORMAT XML) SELECT 1",
"EXPLAIN (FORMAT JSON) SELECT 1",
"EXPLAIN (FORMAT YAML) SELECT 1",
"EXPLAIN (ANALYZE, TIMING, SUMMARY, SETTINGS, WAL) SELECT 1",
"EXPLAIN (GENERIC_PLAN, SERIALIZE NONE, MEMORY) SELECT 1",
"EXPLAIN (SERIALIZE TEXT, GENERIC_PLAN FALSE) SELECT 1",
"EXPLAIN (ANALYZE, SERIALIZE BINARY) SELECT 1",
"EXPLAIN (SERIALIZE) SELECT 1",
"EXPLAIN (ANALYZE OFF, ANALYZE ON) SELECT 1",
"EXPLAIN (ANALYZE) WITH t AS (SELECT * FROM source) SELECT * FROM t",
"EXPLAIN (ANALYZE FALSE) INSERT INTO t VALUES (1)",
"EXPLAIN (COSTS OFF) UPDATE t SET n = 2",
"EXPLAIN (FORMAT JSON) DELETE FROM t WHERE n = 1",
"EXPLAIN (COSTS) VALUES (1), (2)",
"EXPLAIN (SELECT 1)"
})
void roundTrip(String sql) throws JSQLParserException {
TestUtils.assertSqlCanBeParsedAndDeparsed(sql, true,
parser -> parser.withDialect(Dialect.POSTGRESQL));
}
@ParameterizedTest
@ValueSource(strings = {
"EXPLAIN () SELECT 1",
"EXPLAIN ANALYZE TRUE SELECT 1",
"EXPLAIN VERBOSE TRUE SELECT 1",
"EXPLAIN BUFFERS SELECT 1",
"EXPLAIN COSTS SELECT 1",
"EXPLAIN FORMAT XML SELECT 1",
"EXPLAIN VERBOSE ANALYZE SELECT 1",
"EXPLAIN ANALYZE ANALYZE SELECT 1",
"EXPLAIN PLAN FOR SELECT 1",
"EXPLAIN (FORMAT) SELECT 1",
"EXPLAIN (FORMAT LONGTEXT) SELECT 1",
"EXPLAIN (ANALYZE 2) SELECT 1",
"EXPLAIN (ANALYZE MAYBE) SELECT 1",
"EXPLAIN (SERIALIZE JSON) SELECT 1",
"EXPLAIN (UNKNOWN_OPTION) SELECT 1",
"EXPLAIN (ANALYZE,) SELECT 1",
"EXPLAIN (ANALYZE VERBOSE) SELECT 1",
"EXPLAIN some_table"
})
void rejectInvalidPostgresqlOptions(String sql) {
assertThrows(JSQLParserException.class, () -> CCJSqlParserUtil.parse(sql,
parser -> parser.withDialect(Dialect.POSTGRESQL).withUnsupportedStatements(false)));
}
@Test
void preserveRepetitionsAndLegacyMapAccess() throws JSQLParserException {
ExplainStatement explain = (ExplainStatement) TestUtils.assertSqlCanBeParsedAndDeparsed(
"EXPLAIN (ANALYZE OFF, COSTS, ANALYZE ON) SELECT * FROM accounts");
assertTrue(explain.isParenthesizedOptions());
assertEquals(3, explain.getOptionList().size());
assertEquals(2, explain.getOptions().size());
assertEquals("ON", explain.getOption(OptionType.ANALYZE).getValue());
assertEquals("ON", explain.getOptions().get(OptionType.ANALYZE).getValue());
explain.getOptionList().clear();
explain.getOptions().clear();
assertEquals(3, explain.getOptionList().size());
explain.addOption(new Option(OptionType.ANALYZE).withValue("FALSE"));
assertEquals(3, explain.getOptionList().size());
assertEquals("FALSE", explain.getOption(OptionType.ANALYZE).getValue());
assertEquals(List.of("accounts"), new TablesNamesFinder().getTableList(explain));
}
@Test
void constructOptionsAndKeepOtherDialects() throws JSQLParserException {
ExplainStatement explain = new ExplainStatement(CCJSqlParserUtil.parse("SELECT 1"));
assertNull(explain.getOptions());
explain.setParenthesizedOptions(true);
explain.addOption(new Option(OptionType.GENERIC_PLAN));
explain.addOption(new Option(OptionType.FORMAT).withValue("TEXT"));
TestUtils.assertStatementCanBeDeparsedAs(explain,
"EXPLAIN (GENERIC_PLAN, FORMAT TEXT) SELECT 1");
TestUtils.assertSqlCanBeParsedAndDeparsed("EXPLAIN PLAN FOR SELECT 1");
TestUtils.assertSqlCanBeParsedAndDeparsed("EXPLAIN BUFFERS FALSE SELECT 1");
TestUtils.assertSqlCanBeParsedAndDeparsed("SUMMARIZE accounts");
}
}