forked from sqlancer/sqlancer
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTiDBTLPWhereOracle.java
More file actions
45 lines (37 loc) · 1.65 KB
/
TiDBTLPWhereOracle.java
File metadata and controls
45 lines (37 loc) · 1.65 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
package sqlancer.tidb.oracle;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import sqlancer.ComparatorHelper;
import sqlancer.Randomly;
import sqlancer.tidb.TiDBErrors;
import sqlancer.tidb.TiDBProvider.TiDBGlobalState;
import sqlancer.tidb.visitor.TiDBVisitor;
public class TiDBTLPWhereOracle extends TiDBTLPBase {
public TiDBTLPWhereOracle(TiDBGlobalState state) {
super(state);
TiDBErrors.addExpressionErrors(errors);
}
@Override
public void check() throws SQLException {
super.check();
select.setWhereClause(null);
String originalQueryString = TiDBVisitor.asString(select);
List<String> resultSet = ComparatorHelper.getResultSetFirstColumnAsString(originalQueryString, errors, state);
boolean orderBy = Randomly.getBooleanWithRatherLowProbability();
if (orderBy) {
select.setOrderByExpressions(gen.generateOrderBys());
}
select.setWhereClause(predicate);
String firstQueryString = TiDBVisitor.asString(select);
select.setWhereClause(negatedPredicate);
String secondQueryString = TiDBVisitor.asString(select);
select.setWhereClause(isNullPredicate);
String thirdQueryString = TiDBVisitor.asString(select);
List<String> combinedString = new ArrayList<>();
List<String> secondResultSet = ComparatorHelper.getCombinedResultSet(firstQueryString, secondQueryString,
thirdQueryString, combinedString, !orderBy, state, errors);
ComparatorHelper.assumeResultSetsAreEqual(resultSet, secondResultSet, originalQueryString, combinedString,
state);
}
}