01: /* =============================================================
02: * SmallSQL : a free Java DBMS library for the Java(tm) platform
03: * =============================================================
04: *
05: * (C) Copyright 2004-2007, by Volker Berlin.
06: *
07: * Project Info: http://www.smallsql.de/
08: *
09: * This library is free software; you can redistribute it and/or modify it
10: * under the terms of the GNU Lesser General Public License as published by
11: * the Free Software Foundation; either version 2.1 of the License, or
12: * (at your option) any later version.
13: *
14: * This library is distributed in the hope that it will be useful, but
15: * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
16: * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
17: * License for more details.
18: *
19: * You should have received a copy of the GNU Lesser General Public
20: * License along with this library; if not, write to the Free Software
21: * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
22: * USA.
23: *
24: * [Java is a trademark or registered trademark of Sun Microsystems, Inc.
25: * in the United States and other countries.]
26: *
27: * ---------------
28: * ExpressionInSelect.java
29: * ---------------
30: * Author: Volker Berlin
31: *
32: * Created on 07.08.2004
33: */
34: package smallsql.database;
35:
36: import smallsql.database.language.Language;
37:
38: /**
39: * @author Volker Berlin
40: */
41: class ExpressionInSelect extends ExpressionArithmetic {
42:
43: final private CommandSelect cmdSel;
44: final private Index index = new Index(true);
45: final private SSConnection con;
46:
47: ExpressionInSelect(SSConnection con, Expression left,
48: CommandSelect cmdSel, int operation) {
49: super (left, (Expressions) null, operation);
50: this .cmdSel = cmdSel;
51: this .con = con;
52: }
53:
54: private void loadInList() throws Exception {
55: if (cmdSel.compile(con)) {
56: cmdSel.from.execute();
57: if (cmdSel.columnExpressions.size() != 1)
58: throw SmallSQLException.create(
59: Language.SUBQUERY_COL_COUNT, new Integer(
60: cmdSel.columnExpressions.size()));
61: index.clear();
62: while (cmdSel.next()) {
63: try {
64: index.addValues(0, cmdSel.columnExpressions);
65: } catch (Exception e) {
66: //double values can not add
67: }
68: }
69: }
70: }
71:
72: boolean isInList() throws Exception {
73: loadInList();
74: return index.findRows(getParams(), false, null) != null;
75: }
76: }
|