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
/*
* Copyright 2004-2018 H2 Group. Multiple-Licensed under the MPL 2.0,
* and the EPL 1.0 (http://h2database.com/html/license.html).
* Initial Developer: H2 Group
*/
package org.h2.expression;
import org.h2.engine.Session;
import org.h2.table.ColumnResolver;
import org.h2.table.TableFilter;
import org.h2.value.Value;
import org.h2.value.ValueNull;
/**
* A NOT condition.
*/
public class ConditionNot extends Condition {
private Expression condition;
public ConditionNot(Expression condition) {
this.condition = condition;
}
@Override
public Expression getNotIfPossible(Session session) {
return condition;
}
@Override
public Value getValue(Session session) {
Value v = condition.getValue(session);
if (v == ValueNull.INSTANCE) {
return v;
}
return v.convertTo(Value.BOOLEAN).negate();
}
@Override
public void mapColumns(ColumnResolver resolver, int level) {
condition.mapColumns(resolver, level);
}
@Override
public Expression optimize(Session session) {
Expression e2 = condition.getNotIfPossible(session);
if (e2 != null) {
return e2.optimize(session);
}
Expression expr = condition.optimize(session);
if (expr.isConstant()) {
Value v = expr.getValue(session);
if (v == ValueNull.INSTANCE) {
return ValueExpression.getNull();
}
return ValueExpression.get(v.convertTo(Value.BOOLEAN).negate());
}
condition = expr;
return this;
}
@Override
public void setEvaluatable(TableFilter tableFilter, boolean b) {
condition.setEvaluatable(tableFilter, b);
}
@Override
public String getSQL() {
return "(NOT " + condition.getSQL() + ")";
}
@Override
public void updateAggregate(Session session) {
condition.updateAggregate(session);
}
@Override
public void addFilterConditions(TableFilter filter, boolean outerJoin) {
if (outerJoin) {
// can not optimize:
// select * from test t1 left join test t2 on t1.id = t2.id where
// not t2.id is not null
// to
// select * from test t1 left join test t2 on t1.id = t2.id and
// t2.id is not null
return;
}
super.addFilterConditions(filter, outerJoin);
}
@Override
public boolean isEverything(ExpressionVisitor visitor) {
return condition.isEverything(visitor);
}
@Override
public int getCost() {
return condition.getCost();
}
}