Repository navigation
Expand file tree
/
Copy pathSqlServerSetOptionsTest.java
More file actions
157 lines (146 loc) · 7.12 KB
/
Copy pathSqlServerSetOptionsTest.java
File metadata and controls
157 lines (146 loc) · 7.12 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
/*-
* #%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 java.util.Arrays;
import java.util.Collections;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.expression.LongValue;
import net.sf.jsqlparser.expression.operators.relational.ExpressionList;
import net.sf.jsqlparser.parser.AbstractJSqlParser.Dialect;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.parser.feature.Feature;
import net.sf.jsqlparser.statement.SetStatement.OnOffOption;
import net.sf.jsqlparser.statement.SetStatement.OnOffOptions;
import net.sf.jsqlparser.util.TablesNamesFinder;
import net.sf.jsqlparser.util.deparser.ExpressionDeParser;
import net.sf.jsqlparser.util.deparser.SetStatementDeParser;
import net.sf.jsqlparser.util.deparser.StatementDeParser;
import net.sf.jsqlparser.util.validation.ValidationContext;
import net.sf.jsqlparser.util.validation.ValidationTestAsserts;
import net.sf.jsqlparser.util.validation.feature.PostgresqlVersion;
import net.sf.jsqlparser.util.validation.feature.SqlServerVersion;
import net.sf.jsqlparser.util.validation.validator.SetStatementValidator;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.params.ParameterizedTest;
import org.junit.jupiter.params.provider.EnumSource;
import org.junit.jupiter.params.provider.ValueSource;
import static org.junit.jupiter.api.Assertions.*;
class SqlServerSetOptionsTest {
private SetStatement parse(String sql) throws JSQLParserException {
return (SetStatement) CCJSqlParserUtil.parse(sql,
p -> p.withDialect(Dialect.SQLSERVER).withUnsupportedStatements(false));
}
private void assertRoundTrip(SetStatement set, String sql) throws Exception {
assertEquals(sql, set.toString());
StringBuilder buffer = new StringBuilder();
set.accept(new StatementDeParser(buffer), null);
assertEquals(sql, buffer.toString());
assertEquals(sql, parse(buffer.toString()).toString());
}
@ParameterizedTest
@EnumSource(OnOffOption.class)
void parsesBothStatesAsOptions(OnOffOption option) throws Exception {
for (boolean on : new boolean[] {true, false}) {
String sql = "SET " + option + (on ? " ON" : " OFF");
SetStatement set = parse(sql);
assertEquals(Collections.singletonList(option), set.getOnOffOptions().getOptions());
assertEquals(on, set.getOnOffOptions().isOn());
assertEquals(0, set.getCount());
assertRoundTrip(set, sql);
}
}
@Test
void retainsGroupedOptionsAndEditsTheirSharedValue() throws Exception {
SetStatement set = parse("set quoted_identifier, /* group */ ansi_nulls on");
assertEquals(Arrays.asList(OnOffOption.QUOTED_IDENTIFIER, OnOffOption.ANSI_NULLS),
set.getOnOffOptions().getOptions());
set.getOnOffOptions().getOptions().set(0, OnOffOption.NOCOUNT);
set.getOnOffOptions().setOn(false);
assertRoundTrip(set, "SET NOCOUNT, ANSI_NULLS OFF");
assertTrue(new TablesNamesFinder().getTables(set).isEmpty());
assertEquals(3, CCJSqlParserUtil.parseStatements(
"SET NOCOUNT ON; SET XACT_ABORT OFF; SELECT 1;",
p -> p.withDialect(Dialect.SQLSERVER)).size());
Object context = new Object();
assertSame(context, set.accept(new StatementVisitorAdapter<Object>() {
@Override
public <S> Object visit(SetStatement statement, S value) {
assertSame(set, statement);
return value;
}
}, context));
}
@ParameterizedTest
@ValueSource(strings = {"SET NOCOUNT", "SET NOCOUNT TRUE", "SET NOCOUNT 1",
"SET NOCOUNT, ON", "SET NOCOUNT,, ANSI_NULLS ON", "SET NOCOUNT, unknown ON",
"SET NOCOUNT ON OFF", "SET NOCOUNT ON, ANSI_NULLS OFF"})
void rejectsIncompleteOrMixedOptionGroups(String sql) {
assertThrows(JSQLParserException.class, () -> parse(sql));
}
@Test
void retainsGenericAssignmentsAndDialectIsolation() throws Exception {
for (String sql : new String[] {"SET NOCOUNT = 1", "SET NOCOUNT.value = 1",
"SET v = 1, c = 3", "SET v = 1, 3", "SET @Flag = 1",
"SET LOCAL Time Zone 'UTC'", "SET standard_conforming_strings = on"}) {
SetStatement set = parse(sql);
assertNull(set.getOnOffOptions());
assertEquals(CCJSqlParserUtil.parse(sql).toString(), set.toString());
assertRoundTrip(set, set.toString());
}
assertThrows(JSQLParserException.class, () -> CCJSqlParserUtil.parse("SET NOCOUNT ON"));
assertThrows(JSQLParserException.class, () -> CCJSqlParserUtil.parse("SET NOCOUNT ON",
p -> p.withDialect(Dialect.POSTGRESQL)));
SetStatement generic = (SetStatement) CCJSqlParserUtil.parse("SET NOCOUNT OFF");
assertNull(generic.getOnOffOptions());
assertEquals(1, generic.getCount());
}
@Test
void sharesPunctuationWithoutBypassingCustomExpressionDeparsers() throws Exception {
SetStatement set = parse("SET v = 1, 3, c = 5");
StringBuilder buffer = new StringBuilder();
ExpressionDeParser expressions = new ExpressionDeParser() {
@Override
public <S> StringBuilder visit(LongValue value, S context) {
return getBuilder().append(value.getValue() + 10);
}
};
expressions.setBuilder(buffer);
new SetStatementDeParser(expressions, buffer).deParse(set);
assertEquals("SET v = 11, 13, c = 15", buffer.toString());
}
@Test
void switchesBetweenAssignmentAndOptionForms() throws Exception {
SetStatement set = parse("SET LOCAL x = 1");
set.setOnOffOptions(new OnOffOptions(Collections.singleton(OnOffOption.NOCOUNT), true));
assertNull(set.getEffectParameter());
assertRoundTrip(set, "SET NOCOUNT ON");
set.add("x", new ExpressionList<>(new LongValue(2)), true);
assertNull(set.getOnOffOptions());
assertRoundTrip(set, "SET x = 2");
set.setOnOffOptions(new OnOffOptions(Collections.singleton(OnOffOption.XACT_ABORT), false));
set.clear();
assertNull(set.getOnOffOptions());
assertEquals(0, set.getCount());
assertThrows(IllegalArgumentException.class,
() -> new OnOffOptions(Collections.emptyList(), true));
}
@Test
void validatesSqlServerCapabilitySeparatelyFromGenericSet() throws Exception {
SetStatement set = parse("SET ANSI_NULLS, QUOTED_IDENTIFIER ON");
SetStatementValidator validator = new SetStatementValidator();
validator.setContext(new ValidationContext().setCapabilities(
Arrays.asList(SqlServerVersion.V2019, PostgresqlVersion.V10)));
validator.validate(set);
assertFalse(validator.getValidationErrors().containsKey(SqlServerVersion.V2019));
ValidationTestAsserts.assertNotSupported(
validator.getValidationErrors().get(PostgresqlVersion.V10),
Feature.sqlServerSetOptions);
}
}