Skip to content

Instantly share code, notes, and snippets.

@LemonWaterr

LemonWaterr/gist:0ba79477bdd6affd00de9823e05d9276

Last active November 6, 2018 21:36
Show Gist options
  • Save LemonWaterr/0ba79477bdd6affd00de9823e05d9276 to your computer and use it in GitHub Desktop.
Save LemonWaterr/0ba79477bdd6affd00de9823e05d9276 to your computer and use it in GitHub Desktop.
Download ZIP
Hsql Testrun 1
Raw
gistfile1.log
"C:\Program Files\Java\jdk1.8.0_111\bin\java" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\idea_rt.jar=14822:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_111\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\rt.jar;D:\DissProject\out\production\DissProject;D:\DissProject\lib\hsqldb.jar;D:\DissProject\lib\servlet-2_3-fcs-classfiles.zip;D:\DissProject\lib\sqltool.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\groovy-all-2.4.6.jar;D:\DissProject\lib\ivy-2.5.0-rc1.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\junit.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\junit-4.12.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\plugins\testng\lib\testng.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\plugins\testng\lib\testng-plugin.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-jai.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-jmf.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-jsch.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-antlr.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-junit.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-swing.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-junit4.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-jdepend.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-netrexx.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-javamail.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-launcher.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-testutil.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-bsf.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-oro.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-bcel.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-commons-net.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-log4j.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-regexp.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-xalan2.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-apache-resolver.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.2.5\lib\ant\lib\ant-commons-logging.jar" org.hsqldb.test.AllTests
..checked 95 collations for availability.
F.[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6bc168e5]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6bc168e5]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Opened test script file: D:\DissProject\testrun\hsqldb\TestSelf.txt
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:46 returned an unexpected result:
******
Type:
SQL: drop table ref2;drop table ref;drop table main
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:74 returned an unexpected result:
******
Type:
SQL: drop table t1;drop table t2;drop table "T3";
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:75 returned an unexpected result:
******
Type:
SQL: DROP TABLE T4;Drop Table T5; drop table T6
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:76 returned an unexpected result:
******
Type:
SQL: drop table t7; drop table t8; drop table t9
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:215 returned an unexpected result:
******
Type: r
SQL: update test set nr=2;select avg(nr) from test
expected results:
2
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:216 returned an unexpected result:
******
Type: r
SQL: update test set nr=1+1*2;select sum(nr) from test
expected results:
3
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:217 returned an unexpected result:
******
Type: r
SQL: update test set nr=-(select max(t2.nr) from test t2);select nr from test
expected results:
-3
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:218 returned an unexpected result:
******
Type: r
SQL: update test set nr=2*(1- -1);select nr from test
expected results:
4
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:219 returned an unexpected result:
******
Type: r
SQL: select sum(nr) from test where nr in(select t2.nr from test t2)
expected results:
4
message:
Expected row 1 of the ResultSet to contain:
4
but field 1 contained 1
actual results:
1
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:225 returned an unexpected result:
******
Type: r
SQL: update test set nr=4/2;select "TEST"."NR" from test
expected results:
2
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:226 returned an unexpected result:
******
Type: r
SQL: update test set name='3' || '4';select distinct name from test
expected results:
34
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:227 returned an unexpected result:
******
Type: r
SQL: select 'Ho' as hhoo from TEsT where name in ('34','y','z')
expected results:
Ho
message:
Expected the ResultSet to contain 1 rows, but it contained 0 rows.
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:239 returned an unexpected result:
******
Type:
SQL: drop table address drop table place drop table invoices
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:240 returned an unexpected result:
******
Type:
SQL: drop table t_double;drop table t_date drop table t_bit
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:241 returned an unexpected result:
******
Type:
SQL: drop table problem; drop table class
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:244 returned an unexpected result:
******
Type:
SQL: CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
expected results:
message:
java.sql.SQLSyntaxErrorException: object name already exists: ADDRESS in statement [CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
]
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:250 returned an unexpected result:
******
Type: u
SQL: INSERT INTO ADDRESS(ID, countryID) VALUES(5, (SELECT ID FROM Country WHERE name = 'USA'))
expected results:
1
message:
java.lang.Exception: Expected an update count of 1, but got the error: user lacks privilege or object not found: ID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:252 returned an unexpected result:
******
Type:
SQL: SELECT * FROM ADDRESS INNER JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:253 returned an unexpected result:
******
Type:
SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:254 returned an unexpected result:
******
Type:
SQL: INSERT INTO ADDRESS(ID) VALUES(6)
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:255 returned an unexpected result:
******
Type: c
SQL: SELECT * FROM ADDRESS ad INNER JOIN COUNTRY ON ad.CountryID = COUNTRY.ID
expected results:
1
message:
java.lang.Exception: Expected a ResultSet containing 1 rows, but got the error: user lacks privilege or object not found: AD.COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:256 returned an unexpected result:
******
Type: c
SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
2
message:
java.lang.Exception: Expected a ResultSet containing 2 rows, but got the error: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:257 returned an unexpected result:
******
Type:
SQL: SELECT * FROM Address,Country
WHERE Address.countryID=Country.ID AND
EXISTS (SELECT C.Name FROM Country AS C WHERE C.ID=Country.ID) AND
EXISTS (SELECT * FROM Country AS C WHERE C.ID=Address.countryID)
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ADDRESS.COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:423 returned an unexpected result:
******
Type: r
SQL: insert into test values(3,'123',''); select name from test where nr=3;
expected results:
123
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:424 returned an unexpected result:
******
Type: r
SQL: insert into test values(4,'','12345'); select other from test where nr=4;
expected results:
12345
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Processed 1250 lines from D:\DissProject\testrun\hsqldb\TestSelf.txt
.[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7b3300e5]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7b3300e5]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Opened test script file: D:\DissProject\testrun\hsqldb\TestSelf.txt
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:46 returned an unexpected result:
******
Type:
SQL: drop table ref2;drop table ref;drop table main
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:74 returned an unexpected result:
******
Type:
SQL: drop table t1;drop table t2;drop table "T3";
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:75 returned an unexpected result:
******
Type:
SQL: DROP TABLE T4;Drop Table T5; drop table T6
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:76 returned an unexpected result:
******
Type:
SQL: drop table t7; drop table t8; drop table t9
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:215 returned an unexpected result:
******
Type: r
SQL: update test set nr=2;select avg(nr) from test
expected results:
2
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:216 returned an unexpected result:
******
Type: r
SQL: update test set nr=1+1*2;select sum(nr) from test
expected results:
3
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:217 returned an unexpected result:
******
Type: r
SQL: update test set nr=-(select max(t2.nr) from test t2);select nr from test
expected results:
-3
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:218 returned an unexpected result:
******
Type: r
SQL: update test set nr=2*(1- -1);select nr from test
expected results:
4
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:219 returned an unexpected result:
******
Type: r
SQL: select sum(nr) from test where nr in(select t2.nr from test t2)
expected results:
4
message:
Expected row 1 of the ResultSet to contain:
4
but field 1 contained 1
actual results:
1
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:225 returned an unexpected result:
******
Type: r
SQL: update test set nr=4/2;select "TEST"."NR" from test
expected results:
2
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:226 returned an unexpected result:
******
Type: r
SQL: update test set name='3' || '4';select distinct name from test
expected results:
34
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:227 returned an unexpected result:
******
Type: r
SQL: select 'Ho' as hhoo from TEsT where name in ('34','y','z')
expected results:
Ho
message:
Expected the ResultSet to contain 1 rows, but it contained 0 rows.
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:239 returned an unexpected result:
******
Type:
SQL: drop table address drop table place drop table invoices
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:240 returned an unexpected result:
******
Type:
SQL: drop table t_double;drop table t_date drop table t_bit
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:241 returned an unexpected result:
******
Type:
SQL: drop table problem; drop table class
expected results:
message:
java.sql.SQLException: statement is invalid
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:244 returned an unexpected result:
******
Type:
SQL: CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
expected results:
message:
java.sql.SQLSyntaxErrorException: object name already exists: ADDRESS in statement [CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
]
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:250 returned an unexpected result:
******
Type: u
SQL: INSERT INTO ADDRESS(ID, countryID) VALUES(5, (SELECT ID FROM Country WHERE name = 'USA'))
expected results:
1
message:
java.lang.Exception: Expected an update count of 1, but got the error: user lacks privilege or object not found: ID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:252 returned an unexpected result:
******
Type:
SQL: SELECT * FROM ADDRESS INNER JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:253 returned an unexpected result:
******
Type:
SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:254 returned an unexpected result:
******
Type:
SQL: INSERT INTO ADDRESS(ID) VALUES(6)
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:255 returned an unexpected result:
******
Type: c
SQL: SELECT * FROM ADDRESS ad INNER JOIN COUNTRY ON ad.CountryID = COUNTRY.ID
expected results:
1
message:
java.lang.Exception: Expected a ResultSet containing 1 rows, but got the error: user lacks privilege or object not found: AD.COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:256 returned an unexpected result:
******
Type: c
SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
expected results:
2
message:
java.lang.Exception: Expected a ResultSet containing 2 rows, but got the error: user lacks privilege or object not found: COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:257 returned an unexpected result:
******
Type:
SQL: SELECT * FROM Address,Country
WHERE Address.countryID=Country.ID AND
EXISTS (SELECT C.Name FROM Country AS C WHERE C.ID=Country.ID) AND
EXISTS (SELECT * FROM Country AS C WHERE C.ID=Address.countryID)
expected results:
message:
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ADDRESS.COUNTRYID
actual results:
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:423 returned an unexpected result:
******
Type: r
SQL: insert into test values(3,'123',''); select name from test where nr=3;
expected results:
123
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:424 returned an unexpected result:
******
Type: r
SQL: insert into test values(4,'','12345'); select other from test where nr=4;
expected results:
12345
message:
java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
actual results:
no result
******
Processed 1250 lines from D:\DissProject\testrun\hsqldb\TestSelf.txt
.[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@2e5c649]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@2e5c649]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table: T1 priv: SELECT
Table: T1 priv: INSERT
Table: T1 priv: UPDATE
Table: T1 priv: DELETE
Table: T1 priv: REFERENCES
Table: T1 priv: TRIGGER
Table: T1 IndexName: T1
Table: T2 IndexName: T2
.[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@136432db]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@136432db]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7382f612]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7382f612]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1055e4af]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1055e4af]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.................................
.[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@24273305]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@24273305]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5b1d2887]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5b1d2887]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
33
34
35
36
37
38
39
40
41
42
.[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@46f5f779]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@46f5f779]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
generated: 33
34
35
36
37
38
.[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1c2c22f3]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1c2c22f3]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
0
0
.[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@18e8568]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@18e8568]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
generated: 33
34
35
36
37
38
.[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@33e5ccce]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@33e5ccce]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.SetUp (sub-)test: testBlobA
Starting (sub-)test: testBlobA
TearDown (sub-)test: testBlobA
.SetUp (sub-)test: testClobD
Starting (sub-)test: testClobD
Time for inserts in 248 ms.
Time for updates in 9 ms.
TearDown (sub-)test: testClobD
.SetUp (sub-)test: testBlobH
Starting (sub-)test: testBlobH
TearDown (sub-)test: testBlobH
.SetUp (sub-)test: testClobA
Starting (sub-)test: testClobA
TearDown (sub-)test: testClobA
.SetUp (sub-)test: testBlobI
Starting (sub-)test: testBlobI
Running insert...
Running update...
Running select...
Results: 0
Result: 3
TearDown (sub-)test: testBlobI
.SetUp (sub-)test: testClobB
Starting (sub-)test: testClobB
TearDown (sub-)test: testClobB
.SetUp (sub-)test: testClobC
Starting (sub-)test: testClobC
TearDown (sub-)test: testClobC
.SetUp (sub-)test: testClobG
Starting (sub-)test: testClobG
TearDown (sub-)test: testClobG
.SetUp (sub-)test: testClobF
Starting (sub-)test: testClobF
TearDown (sub-)test: testClobF
.SetUp (sub-)test: testClobE
Starting (sub-)test: testClobE
Time for inserts in 9 ms.
Time for updates in 14 ms.
TearDown (sub-)test: testClobE
.SetUp (sub-)test: testClobH
Starting (sub-)test: testClobH
dafsdfasdf
TearDown (sub-)test: testClobH
.SetUp (sub-)test: testBlobB
Starting (sub-)test: testBlobB
Size of retrieved blob: 11
Size of retrieved blob: 11
TearDown (sub-)test: testBlobB
.[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@11e21d0e]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@11e21d0e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 4 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
I:10:A:testA :B:INSERTED :
testMerge10 complete
.[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1dd02175]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1dd02175]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:G :B:UPDATED :
testMerge7 complete
.[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@31206beb]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@31206beb]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 4 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:3:A:F :B:INSERTED :
I:4:A:G :B:UPDATED :
testMerge9 complete
.[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3e77a1ed]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3e77a1ed]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 4 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:3:A:F :B:INSERTED :
I:4:A:C :B:c :
testMerge8 complete
.[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3ffcd140]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3ffcd140]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 5 rows total:
I:0:A:D :B:UPDATED :
I:1:A:B :B:b :
I:2:A:E :B:INSERTED :
I:3:A:F :B:INSERTED :
I:4:A:G :B:UPDATED :
testMerge5 complete
.[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@23bb8443]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@23bb8443]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 5 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:2:A:E :B:INSERTED :
I:3:A:F :B:INSERTED :
I:4:A:C :B:c :
testMerge3 complete
.[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1176dcec]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1176dcec]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 5 rows total:
I:0:A:D :B:UPDATED :
I:1:A:B :B:b :
I:2:A:E :B:INSERTED :
I:3:A:F :B:INSERTED :
I:4:A:G :B:UPDATED :
testMerge1 complete
.[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@120d6fe6]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@120d6fe6]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 3 rows total:
I:0:A:D :B:UPDATED :
I:1:A:B :B:b :
I:4:A:G :B:UPDATED :
testMerge2 complete
.[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@4ba2ca36]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@4ba2ca36]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 5 rows total:
I:0:A:D :B:UPDATED :
I:1:A:B :B:b :
I:2:A:E :B:INSERTED :
I:3:A:F :B:INSERTED :
I:4:A:G :B:UPDATED :
testMerge6 complete
.[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3444d69d]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@3444d69d]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 5 rows total:
I:0:A:D :B:UPDATED :
I:1:A:B :B:b :
I:2:A:E :B:INSERTED :
I:3:A:F :B:INSERTED :
I:4:A:G :B:UPDATED :
testMerge4 complete
.[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1372ed45]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1372ed45]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table SA.T, expecting 3 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
Table SA.S, expecting 4 rows total:
I:0:A:D :B:d :C:Dd :
I:2:A:E :B:e :C:Ee :
I:3:A:F :B:f :C:Ff :
I:4:A:G :B:g :C:Gg :
Table SA.T, expecting 4 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:4:A:C :B:c :
I:10:A:testA :B:INSERTED :
testMerge10 complete
.[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6a79c292]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6a79c292]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Table T, expecting 2 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
Table T, expecting 6 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:2:A:single1 :B:s1 :
I:3:A:single2 :B:s2 :
I:4:A:double1 :B:d1 :
I:5:A:double2 :B:d2 :
Table T, expecting 9 rows total:
I:0:A:A :B:a :
I:1:A:B :B:b :
I:2:A:single1 :B:s1 :
I:3:A:single2 :B:s2 :
I:4:A:double1 :B:d1 :
I:5:A:double2 :B:d2 :
I:6:A:prepared1 :B:test1 :
I:7:A:prepared2 :B:test2 :
I:8:A:prepared3 :B:test3 :
testMultiInsert complete
.[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@37574691]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@37574691]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@25359ed8]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@25359ed8]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@21a947fe]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@21a947fe]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5606c0b]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5606c0b]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@57d5872c]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@57d5872c]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@667a738]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@667a738]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Testing DatabaseMetaData methods
2
3
HSQL Database Engine
2.3.6
2
2
3
HSQL Database Engine Driver
2.3.6
"
4
0
0
128
0
0
0
0
0
0
128
0
128
0
128
0
0
128
128
ABS,ACOS,ASIN,ATAN,ATAN2,BITAND,BITOR,BITXOR,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MOD,PI,POWER,RADIANS,RAND,ROUND,ROUNDMAGIC,SIGN,SIN,SQRT,TAN,TRUNCATE
PROCEDURE
1
SCHEMA
\
Testing DatabaseMetaData.getSQLKeywords()
2
Testing DatabaseMetaData.getStringFunctions()
ASCII,CHAR,CONCAT,DIFFERENCE,HEXTORAW,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,RAWTOHEX,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTR,UCASE
Testing DatabaseMetaData.getSystemFunctions()
DATABASE,IFNULL,USER
Testing DatabaseMetaData.getTimeDateFunctions()
CURDATE,CURTIME,DATEDIFF,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,HOUR,MINUTE,MONTH,MONTHNAME,NOW,QUARTER,SECOND,SECONDS_SINCE_MIDNIGHT,TIMESTAMPADD,TIMESTAMPDIFF,TO_CHAR,WEEK,YEAR
jdbc:hsqldb:hsql://localhost/test
SA
0
true
false
PUBLIC:PUBLIC:USER:USER_ID:1:SYS_PK_10093:
0:USER_ID:4:INTEGER:32:null:null:1:PUBLIC:PUBLIC:USER:0:TRUE:
PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK:USER_ID:1:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:CATEGORY_ID:PUBLIC:PUBLIC:ADDRESSBOOK:CATEGORY_ID:2:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK:USER_ID:1:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:CATEGORY_ID:PUBLIC:PUBLIC:ADDRESSBOOK:CATEGORY_ID:2:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
PUBLIC:PUBLIC:USER:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:1:3:0:FK_ADRBKCAT1:SYS_PK_10093:7:
PUBLIC:PUBLIC:USER:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:1:3:0:FK_ADRBKCAT1:SYS_PK_10093:7:
I:0:A:get_column_name :B:false :A:get_column_name :B:false :C6:1:
I:0:A:get_column_name :B:false :aliasA:get_column_name :aliasB:false :C6:1:
first column identity: true
call identity(): 1
testMetaData complete
.[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@36f0f1be]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@36f0f1be]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@157632c9]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@157632c9]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
java.sql.SQLException: statement is invalid
at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:418)
at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:2104)
at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:620)
at org.hsqldb.test.TestSql.testAny(TestSql.java:519)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
TestSql.testAny() error: statement is invalid
testAny complete
.[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@55040f2f]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@55040f2f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Max value for i: 2147483647
Max value for ID: 0
testDoubleNaN complete
.[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@64c87930]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@64c87930]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.
[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@400cff1a]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@400cff1a]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@275710fc]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@275710fc]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@525f1e4e]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@525f1e4e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@75f9eccc]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@75f9eccc]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@52aa2946]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@52aa2946]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
.[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@4de5031f]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@4de5031f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
..Opened test script file: D:\DissProject\testrun\hsqldb\TestText01.txt
Processed 35 lines from D:\DissProject\testrun\hsqldb\TestText01.txt
Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
..Opened test script file: D:\DissProject\testrun\hsqldb\TestText01.txt
Processed 35 lines from D:\DissProject\testrun\hsqldb\TestText01.txt
Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
..2018-11-06T21:27:59.160+0000 WARNING Problem processing SET TABLE SOURCE
org.hsqldb.HsqlException: Header not allowed or too long
at org.hsqldb.error.Error.error(Error.java:138)
at org.hsqldb.error.Error.error(Error.java:107)
at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
at org.hsqldb.TextTable.setHeader(TextTable.java:270)
at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
at org.hsqldb.persist.Log.processScript(Log.java:758)
at org.hsqldb.persist.Log.open(Log.java:144)
at org.hsqldb.persist.Logger.open(Logger.java:389)
at org.hsqldb.Database.reopen(Database.java:227)
at org.hsqldb.Database.open(Database.java:209)
at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
2018-11-06T21:27:59.162+0000 WARNING Problem processing SET TABLE SOURCE
org.hsqldb.HsqlException: Header not allowed or too long
at org.hsqldb.error.Error.error(Error.java:138)
at org.hsqldb.error.Error.error(Error.java:107)
at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
at org.hsqldb.TextTable.setHeader(TextTable.java:270)
at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
at org.hsqldb.persist.Log.processScript(Log.java:758)
at org.hsqldb.persist.Log.open(Log.java:144)
at org.hsqldb.persist.Logger.open(Logger.java:389)
at org.hsqldb.Database.reopen(Database.java:227)
at org.hsqldb.Database.open(Database.java:209)
at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
2018-11-06T21:27:59.165+0000 WARNING Problem processing SET TABLE SOURCE
org.hsqldb.HsqlException: Header not allowed or too long
at org.hsqldb.error.Error.error(Error.java:138)
at org.hsqldb.error.Error.error(Error.java:107)
at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
at org.hsqldb.TextTable.setHeader(TextTable.java:270)
at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
at org.hsqldb.persist.Log.processScript(Log.java:758)
at org.hsqldb.persist.Log.open(Log.java:144)
at org.hsqldb.persist.Logger.open(Logger.java:389)
at org.hsqldb.Database.reopen(Database.java:227)
at org.hsqldb.Database.open(Database.java:209)
at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
2018-11-06T21:27:59.167+0000 WARNING Problem processing SET TABLE SOURCE
org.hsqldb.HsqlException: Header not allowed or too long
at org.hsqldb.error.Error.error(Error.java:138)
at org.hsqldb.error.Error.error(Error.java:107)
at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
at org.hsqldb.TextTable.setHeader(TextTable.java:270)
at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
at org.hsqldb.persist.Log.processScript(Log.java:758)
at org.hsqldb.persist.Log.open(Log.java:144)
at org.hsqldb.persist.Logger.open(Logger.java:389)
at org.hsqldb.Database.reopen(Database.java:227)
at org.hsqldb.Database.open(Database.java:209)
at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
.Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
....[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@415b0b49]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@415b0b49]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1 TEST 1 1010
2 TEST 2 1010
3 TEST 3 1010
4 TEST 4 1010
5 TEST 5 1010
6 TEST 6 1010
7 TEST 7 1010
8 TEST 8 1010
9 TEST 9 1010
12 TEST 12 1010
13 TEST 13 1010
14 TEST 14 1010
15 TEST 15 1010
16 TEST 16 1010
17 TEST 17 1010
18 TEST 18 1010
19 TEST 19 1010
20 TEST 20 1010
10 UPDATE10 1010
1011 INSERT1011 0101
1012 def 1010
1013 def 1111
.[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6d5620ce]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6d5620ce]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
0 s
1 s
2 s
3 s
4 s
5 s
6 s
7 s
8 s
9 s
.[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@311bf055]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@311bf055]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
Deleting row:0
Deleting row:7
Deleting row:14
Deleting row:21
Deleting row:28
Deleting row:35
Deleting row:42
Deleting row:49
Deleting row:56
Deleting row:63
Deleting row:70
Deleting row:77
Deleting row:84
Deleting row:91
Deleting row:98
.[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@222a59e6]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@222a59e6]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1 s 1.0
0 s 0.0
1 s 1.0
0 s 0.0
0 s 0.0
0 s 0.0
.[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6c7a164b]: [Thread[main,5,main]]: setDatabaseName(0,test)
[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6c7a164b]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
2018-11-06 21:28:03.732 2 COMMIT
2018-11-06 21:28:03.732 2 drop table t1 if exists
2018-11-06 21:28:03.732 2 COMMIT
2018-11-06 21:28:03.733 2 COMMIT
2018-11-06 21:28:03.733 2 create table t1 (i int primary key, v varchar(10), t varbinary(3), b blob(16), c clob(16))
2018-11-06 21:28:03.733 2 COMMIT
2018-11-06 21:28:03.734 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (1,16,0,30)
2018-11-06 21:28:03.734 1 COMMIT
2018-11-06 21:28:03.735 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,1)
2018-11-06 21:28:03.735 1 COMMIT
2018-11-06 21:28:03.736 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (2,3,0,40)
2018-11-06 21:28:03.736 1 COMMIT
2018-11-06 21:28:03.736 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,2)
2018-11-06 21:28:03.736 1 COMMIT
2018-11-06 21:28:03.737 2 insert into t1 values(?,?,?,?,?) (0,'0 s',X'002000',1,2)
2018-11-06 21:28:03.737 2 COMMIT
2018-11-06 21:28:03.738 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (3,16,0,30)
2018-11-06 21:28:03.738 1 COMMIT
2018-11-06 21:28:03.738 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,3)
2018-11-06 21:28:03.739 1 COMMIT
2018-11-06 21:28:03.739 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (4,3,0,40)
2018-11-06 21:28:03.739 1 COMMIT
2018-11-06 21:28:03.739 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,4)
2018-11-06 21:28:03.739 1 COMMIT
2018-11-06 21:28:03.739 2 insert into t1 values(?,?,?,?,?) (1,'1 s',X'012001',3,4)
2018-11-06 21:28:03.739 2 COMMIT
2018-11-06 21:28:03.739 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (5,16,0,30)
2018-11-06 21:28:03.740 1 COMMIT
2018-11-06 21:28:03.740 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,5)
2018-11-06 21:28:03.740 1 COMMIT
2018-11-06 21:28:03.740 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (6,3,0,40)
2018-11-06 21:28:03.740 1 COMMIT
2018-11-06 21:28:03.740 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,6)
2018-11-06 21:28:03.741 1 COMMIT
2018-11-06 21:28:03.743 2 insert into t1 values(?,?,?,?,?) (2,'2 s',X'022002',5,6)
2018-11-06 21:28:03.743 2 COMMIT
2018-11-06 21:28:03.744 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (7,16,0,30)
2018-11-06 21:28:03.744 1 COMMIT
2018-11-06 21:28:03.746 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,7)
2018-11-06 21:28:03.746 1 COMMIT
2018-11-06 21:28:03.746 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (8,3,0,40)
2018-11-06 21:28:03.746 1 COMMIT
2018-11-06 21:28:03.746 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,8)
2018-11-06 21:28:03.746 1 COMMIT
2018-11-06 21:28:03.747 2 insert into t1 values(?,?,?,?,?) (3,'3 s',X'032003',7,8)
2018-11-06 21:28:03.747 2 COMMIT
2018-11-06 21:28:03.748 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (9,16,0,30)
2018-11-06 21:28:03.748 1 COMMIT
2018-11-06 21:28:03.748 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,9)
2018-11-06 21:28:03.748 1 COMMIT
2018-11-06 21:28:03.748 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (10,3,0,40)
2018-11-06 21:28:03.749 1 COMMIT
2018-11-06 21:28:03.749 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,10)
2018-11-06 21:28:03.749 1 COMMIT
2018-11-06 21:28:03.749 2 insert into t1 values(?,?,?,?,?) (4,'4 s',X'042004',9,10)
2018-11-06 21:28:03.749 2 COMMIT
2018-11-06 21:28:03.750 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (11,16,0,30)
2018-11-06 21:28:03.750 1 COMMIT
2018-11-06 21:28:03.750 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,11)
2018-11-06 21:28:03.750 1 COMMIT
2018-11-06 21:28:03.751 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (12,3,0,40)
2018-11-06 21:28:03.751 1 COMMIT
2018-11-06 21:28:03.751 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,12)
2018-11-06 21:28:03.751 1 COMMIT
2018-11-06 21:28:03.751 2 insert into t1 values(?,?,?,?,?) (5,'5 s',X'052005',11,12)
2018-11-06 21:28:03.751 2 COMMIT
2018-11-06 21:28:03.752 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (13,16,0,30)
2018-11-06 21:28:03.752 1 COMMIT
2018-11-06 21:28:03.752 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,13)
2018-11-06 21:28:03.752 1 COMMIT
2018-11-06 21:28:03.752 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (14,3,0,40)
2018-11-06 21:28:03.752 1 COMMIT
2018-11-06 21:28:03.752 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,14)
2018-11-06 21:28:03.752 1 COMMIT
2018-11-06 21:28:03.752 2 insert into t1 values(?,?,?,?,?) (6,'6 s',X'062006',13,14)
2018-11-06 21:28:03.753 2 COMMIT
2018-11-06 21:28:03.753 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (15,16,0,30)
2018-11-06 21:28:03.753 1 COMMIT
2018-11-06 21:28:03.754 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,15)
2018-11-06 21:28:03.754 1 COMMIT
2018-11-06 21:28:03.754 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (16,3,0,40)
2018-11-06 21:28:03.754 1 COMMIT
2018-11-06 21:28:03.754 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,16)
2018-11-06 21:28:03.754 1 COMMIT
2018-11-06 21:28:03.754 2 insert into t1 values(?,?,?,?,?) (7,'7 s',X'072007',15,16)
2018-11-06 21:28:03.754 2 COMMIT
2018-11-06 21:28:03.754 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (17,16,0,30)
2018-11-06 21:28:03.754 1 COMMIT
2018-11-06 21:28:03.755 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,17)
2018-11-06 21:28:03.755 1 COMMIT
2018-11-06 21:28:03.755 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (18,3,0,40)
2018-11-06 21:28:03.755 1 COMMIT
2018-11-06 21:28:03.755 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,18)
2018-11-06 21:28:03.755 1 COMMIT
2018-11-06 21:28:03.755 2 insert into t1 values(?,?,?,?,?) (8,'8 s',X'082008',17,18)
2018-11-06 21:28:03.755 2 COMMIT
2018-11-06 21:28:03.755 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (19,16,0,30)
2018-11-06 21:28:03.755 1 COMMIT
2018-11-06 21:28:03.756 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,19)
2018-11-06 21:28:03.756 1 COMMIT
2018-11-06 21:28:03.756 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (20,3,0,40)
2018-11-06 21:28:03.756 1 COMMIT
2018-11-06 21:28:03.756 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,20)
2018-11-06 21:28:03.756 1 COMMIT
2018-11-06 21:28:03.756 2 insert into t1 values(?,?,?,?,?) (9,'9 s',X'092009',19,20)
2018-11-06 21:28:03.756 2 COMMIT
2018-11-06 21:28:03.756 2 COMMIT
2018-11-06 21:28:03.757 2 select i, v, t, b, c from t1 where i > ? (-1)
2018-11-06 21:28:03.758 2 select i, v, t, b, c from t1 where i > ? (NULL,'0 s0 s',NULL,NULL,NULL,1202590842880,NULL)
2018-11-06 21:28:03.758 2 select i, v, t, b, c from t1 where i > ? (NULL,'1 s1 s',NULL,NULL,NULL,1202590842881,NULL)
2018-11-06 21:28:03.759 2 select i, v, t, b, c from t1 where i > ? (NULL,'2 s2 s',NULL,NULL,NULL,1202590842882,NULL)
2018-11-06 21:28:03.759 2 select i, v, t, b, c from t1 where i > ? (NULL,'3 s3 s',NULL,NULL,NULL,1202590842883,NULL)
2018-11-06 21:28:03.759 2 select i, v, t, b, c from t1 where i > ? (NULL,'4 s4 s',NULL,NULL,NULL,1202590842884,NULL)
2018-11-06 21:28:03.759 2 select i, v, t, b, c from t1 where i > ? (NULL,'5 s5 s',NULL,NULL,NULL,1202590842885,NULL)
2018-11-06 21:28:03.760 2 select i, v, t, b, c from t1 where i > ? (NULL,'6 s6 s',NULL,NULL,NULL,1202590842886,NULL)
2018-11-06 21:28:03.760 2 select i, v, t, b, c from t1 where i > ? (NULL,'7 s7 s',NULL,NULL,NULL,1202590842887,NULL)
2018-11-06 21:28:03.760 2 select i, v, t, b, c from t1 where i > ? (NULL,'8 s8 s',NULL,NULL,NULL,1202590842888,NULL)
2018-11-06 21:28:03.761 2 select i, v, t, b, c from t1 where i > ? (NULL,'9 s9 s',NULL,NULL,NULL,1202590842889,NULL)
2018-11-06 21:28:03.761 2 select i, v, t, b, c from t1 where i > ? (-1)
0 s0 s
1 s1 s
2 s2 s
3 s3 s
4 s4 s
5 s5 s
6 s6 s
7 s7 s
8 s8 s
9 s9 s
2018-11-06 21:28:03.761 2 ROLLBACK
2018-11-06 21:28:03.762 2 select i, v, t, b, c from t1 where i > ? (-1)
0 s
1 s
2 s
3 s
4 s
5 s
6 s
7 s
8 s
9 s
2018-11-06 21:28:03.762 2 COMMIT
2018-11-06 21:28:03.762 2 select i, v, t, b, c from t1 where i > ? (-1)
2018-11-06 21:28:03.763 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (21,15,0,40)
2018-11-06 21:28:03.763 1 COMMIT
2018-11-06 21:28:03.763 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,21)
2018-11-06 21:28:03.763 1 COMMIT
2018-11-06 21:28:03.763 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,21,1202590842880,NULL)
2018-11-06 21:28:03.764 2 ROLLBACK
2018-11-06 21:28:03.764 2 select i, v, t, b, c from t1 where i > ? (-1)
2018-11-06 21:28:03.765 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (22,16,0,30)
2018-11-06 21:28:03.765 1 COMMIT
2018-11-06 21:28:03.765 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,22)
2018-11-06 21:28:03.765 1 COMMIT
2018-11-06 21:28:03.765 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,22,NULL,1202590842880,NULL)
2018-11-06 21:28:03.766 2 ROLLBACK
2018-11-06 21:28:03.766 2 select i, v, t, b, c from t1 where i > ? (-1)
2018-11-06 21:28:03.766 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (23,15,0,40)
2018-11-06 21:28:03.766 1 COMMIT
2018-11-06 21:28:03.766 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,23)
2018-11-06 21:28:03.766 1 COMMIT
2018-11-06 21:28:03.766 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,23,1202590842880,NULL)
2018-11-06 21:28:03.767 2 ROLLBACK
2018-11-06 21:28:03.767 2 select i, v, t, b, c from t1 where i > ? (-1)
2018-11-06 21:28:03.768 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (24,5,0,40)
2018-11-06 21:28:03.768 1 COMMIT
2018-11-06 21:28:03.768 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,24)
2018-11-06 21:28:03.768 1 COMMIT
2018-11-06 21:28:03.768 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,24,1202590842880,NULL)
2018-11-06 21:28:03.768 2 ROLLBACK
2018-11-06 21:28:03.769 2 ROLLBACK
2018-11-06 21:28:03.769 0 ROLLBACK
2018-11-06 21:28:03.769 1 ROLLBACK
.Opened test script file: D:\DissProject\testrun\hsqldb\TestTriggers.txt
Processed 29 lines from D:\DissProject\testrun\hsqldb\TestTriggers.txt
.[Server@5d43661b]: [Thread[main,5,main]]: putPropertiesFromString(): [database.0=mem:test;dbname.0=;silent=true;trace=false]
[Server@5d43661b]: Initiating startup sequence...
[Server@5d43661b]: Server socket opened successfully in 0 ms.
[Server@5d43661b]: Database [index=0, id=81, db=mem:test, alias=] opened successfully in 22 ms.
[Server@5d43661b]: Startup sequence completed in 22 ms.
[Server@5d43661b]: 2018-11-06 21:28:04.628 HSQLDB server 2.3.6 is online on port 9001
[Server@5d43661b]: To close normally, connect and execute SHUTDOWN SQL
[Server@5d43661b]: From command line, use [Ctrl]+[C] to abort abruptly
.[Server@5d43661b]: Initiating shutdown sequence...
[Server@12299890]: [Thread[main,5,main]]: putPropertiesFromString(): [database.0=mem:test;dbname.0=;silent=true;trace=false]
[Server@5d43661b]: Shutdown sequence completed in 0 ms.
[Server@5d43661b]: 2018-11-06 21:28:04.917 SHUTDOWN : System.exit() was not called
[Server@12299890]: Initiating startup sequence...
[Server@12299890]: Server socket opened successfully in 0 ms.
[Server@12299890]: Database [index=0, id=81, db=mem:test, alias=] opened successfully in 0 ms.
[Server@12299890]: Startup sequence completed in 0 ms.
[Server@12299890]: 2018-11-06 21:28:04.918 HSQLDB server 2.3.6 is online on port 9001
[Server@12299890]: To close normally, connect and execute SHUTDOWN SQL
[Server@12299890]: From command line, use [Ctrl]+[C] to abort abruptly
.[Server@12299890]: Initiating shutdown sequence...
[Server@12299890]: Shutdown sequence completed in 0 ms.
[Server@12299890]: 2018-11-06 21:28:05.253 SHUTDOWN : System.exit() was not called
. -- #0 -----------------------
-- executing directly
<<<
drop table public.ivtest if exists cascade
>>>
***** st.execute gave me false
-- #1 -----------------------
-- executing directly
<<<
create cached table ivtest(interval1 INTERVAL YEAR TO MONTH, interval2 INTERVAL DAY TO SECOND(3))
>>>
***** st.execute gave me false
-- #2 -----------------------
-- executing directly
<<<
drop table public.dttest if exists cascade
>>>
***** st.execute gave me false
-- #3 -----------------------
-- executing directly
<<<
create cached table dttest(adate date not null, atime time not null,bg int, primary key(adate,atime))
>>>
***** st.execute gave me false
-- #4 -----------------------
-- executing directly
<<<
insert into dttest values(current_date - 10 day, current_time + 1 hour, 1)
>>>
***** st.execute gave me false
-- #5 -----------------------
-- executing directly
<<<
insert into dttest values(current_date - 8 day, current_time - 5 hour, 2)
>>>
***** st.execute gave me false
-- #6 -----------------------
-- executing directly
<<<
insert into dttest values(current_date - 7 day, current_time - 4 hour, 3)
>>>
***** st.execute gave me false
-- #7 -----------------------
-- executing directly
<<<
insert into dttest values(current_date, '12:44:31', 4)
>>>
***** st.execute gave me false
-- #8 -----------------------
-- executing directly
<<<
insert into dttest values(current_date + 3 day, current_time - 12 hour, 5)
>>>
***** st.execute gave me false
-- #9 -----------------------
-- executing directly
<<<
insert into dttest values(current_date + 1 day, current_time - 1 hour, 6)
>>>
***** st.execute gave me false
-- #10 -----------------------
-- preparing
<<<
select atime adate from dttest where atime = ? and adate = ?
>>>
-- setting 2 Args [12:44:31; 2018-11-06]
-- executing
***** ps.execute returned result row count 1 -- #11 -----------------------
-- preparing
<<<
insert into ivtest values ?, ?
>>>
-- setting 2 Args [1-10; 10 02:15:30.333]
-- executing
***** ps.executeUpdate gave me 1
-- #12 -----------------------
-- preparing
<<<
insert into ivtest values CAST (? AS INTERVAL YEAR TO MONTH), CAST (? AS INTERVAL DAY TO SECOND)
>>>
-- setting 2 Args [1-10; 10 02:15:30.333]
-- executing
***** ps.executeUpdate gave me 1
-- #13 -----------------------
-- preparing
<<<
script
>>>
-- executing
***** ps.execute returned result row count 46 -- #14 -----------------------
-- executing directly
<<<
drop table public.bintest if exists cascade
>>>
***** st.execute gave me false
-- #15 -----------------------
-- executing directly
<<<
create cached table bintest(val BIGINT, id BINARY(100))
>>>
***** st.execute gave me false
-- #16 -----------------------
-- preparing
<<<
insert into bintest values ?, ?
>>>
-- setting 2 Args [10; [B@62833051]
-- executing
***** ps.executeUpdate gave me 1
-- #17 -----------------------
-- preparing
<<<
select val from bintest where id = ?
>>>
-- setting 1 Args [[B@a37aefe]
-- executing
***** ps.execute returned result row count 1...... -- #0 -----------------------
-- executing directly
<<<
drop table a if exists cascade
>>>
***** st.execute gave me false
-- #1 -----------------------
-- executing directly
<<<
create cached table a (a int identity,b int)
>>>
***** st.execute gave me false
-- #2 -----------------------
-- executing directly
<<<
create index bIdx on a(b)
>>>
***** st.execute gave me false
-- #3 -----------------------
-- preparing
<<<
insert into a(b) values(1)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #4 -----------------------
-- preparing
<<<
insert into a(b) values(2)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #5 -----------------------
-- preparing
<<<
insert into a(b) values(3)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #6 -----------------------
-- preparing
<<<
insert into a(b) values(4)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #7 -----------------------
-- preparing
<<<
insert into a(b) values(5)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #8 -----------------------
-- preparing
<<<
insert into a(b) values(6)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 1
-- #9 -----------------------
-- preparing
<<<
update a set b=100 where b>(select b from a X where X.a=2)
>>>
-- setting 0 Args []
-- executing
***** ps.executeUpdate gave me 3
-- #10 -----------------------
-- preparing
<<<
update a set b=200 where b>(select b from a where a=?)
>>>
-- setting 1 Args [2]
-- executing
***** ps.executeUpdate gave me 3
-- #11 -----------------------
-- preparing
<<<
update a set b=300 where b>(select b from a X where X.a=?)
>>>
-- setting 1 Args [2]
-- executing
***** ps.executeUpdate gave me 3
..........
...............Max value for i: 2147483647
Max value for ID: 0
testDoubleNaN complete
..String Type Object 1
String Type Object 1
String Type Object 1
String Type Object 1
Time: 30.025
There was 1 failure:
1) testVerifyAvailability(org.hsqldb.test.TestCollation)junit.framework.AssertionFailedError: the following locales are not installed:
af-ZA; am-ET; as-IN; az-AZ; az-cyrillic; bn-IN; bo-CN; bs-BA; cy-GB; eu; gn-PY; gu-IN; ha-NG; he-IL; hy-AM; id-ID; ig-NG; iu-CA; ka-GE; kk-KZ; km-KH; kn-IN; kok-IN; ks; ky-KG; lo-LA; mi-NZ; ml-IN; mn-MN; mni-IN; mr-IN; my-MM; nb-NO; ne-NP; nn-NO; or-IN; pa-IN; ps-AF; sa-IN; sd-IN; so-SO; sr-YU; sh-BA; sw-KE; ta-IN; te-IN; tg-TJ; tk-TM; tn-BW; tt-RU; ur-PK; uz-UZ; ven-ZA; yo-NG; zu-ZA
(55 out of 95)
at org.hsqldb.test.TestCollation.testVerifyAvailability(TestCollation.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.hsqldb.test.AllTests.main(AllTests.java:82)
FAILURES!!!
Tests run: 140, Failures: 1, Errors: 0
Process finished with exit code 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment