01: /* Copyright (c) 2001-2005, The HSQL Development Group
02: * All rights reserved.
03: *
04: * Redistribution and use in source and binary forms, with or without
05: * modification, are permitted provided that the following conditions are met:
06: *
07: * Redistributions of source code must retain the above copyright notice, this
08: * list of conditions and the following disclaimer.
09: *
10: * Redistributions in binary form must reproduce the above copyright notice,
11: * this list of conditions and the following disclaimer in the documentation
12: * and/or other materials provided with the distribution.
13: *
14: * Neither the name of the HSQL Development Group nor the names of its
15: * contributors may be used to endorse or promote products derived from this
16: * software without specific prior written permission.
17: *
18: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19: * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20: * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21: * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22: * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24: * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25: * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28: * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29: */
30:
31: package org.hsqldb.test;
32:
33: import java.sql.Connection;
34: import java.sql.Statement;
35:
36: import junit.framework.TestCase;
37: import junit.framework.TestResult;
38:
39: /**
40: * HSQLDB TestBug808460 Junit test case. <p>
41: *
42: * @author boucherb@users
43: * @version 1.7.2
44: * @since 1.7.2
45: */
46: public class TestBug808460 extends TestBase {
47:
48: public TestBug808460(String name) {
49: super (name);
50: }
51:
52: /* Implements the TestBug808460 test */
53: public void test() throws Exception {
54:
55: Connection conn = newConnection();
56: Statement stmt = conn.createStatement();
57:
58: stmt
59: .executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
60: conn.close();
61:
62: conn = newConnection();
63: stmt = conn.createStatement();
64:
65: stmt
66: .executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
67: conn.close();
68: }
69:
70: /* Runs TestBug808460 test from the command line*/
71: public static void main(String[] args) throws Exception {
72:
73: TestResult result;
74: TestCase test;
75: java.util.Enumeration failures;
76: int count;
77:
78: result = new TestResult();
79: test = new TestBug808460("test");
80:
81: test.run(result);
82:
83: count = result.failureCount();
84:
85: System.out.println("TestBug808460 failure count: " + count);
86:
87: failures = result.failures();
88:
89: while (failures.hasMoreElements()) {
90: System.out.println(failures.nextElement());
91: }
92: }
93: }
|