· 7 years ago · Nov 07, 2018, 02:56 AM
1"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
2..checked 95 collations for availability.
3F.[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) entered
4[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) exited
5[Server@6bc168e5]: [Thread[main,5,main]]: setDatabaseName(0,test)
6[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) entered
7[Server@6bc168e5]: [Thread[main,5,main]]: checkRunning(false) exited
8[Server@6bc168e5]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
9Opened test script file: D:\DissProject\testrun\hsqldb\TestSelf.txt
10Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:46 returned an unexpected result:
11******
12Type:
13SQL: drop table ref2;drop table ref;drop table main
14
15expected results:
16
17
18message:
19java.sql.SQLException: statement is invalid
20actual results:
21
22******
23
24Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:74 returned an unexpected result:
25******
26Type:
27SQL: drop table t1;drop table t2;drop table "T3";
28
29expected results:
30
31
32message:
33java.sql.SQLException: statement is invalid
34actual results:
35
36******
37
38Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:75 returned an unexpected result:
39******
40Type:
41SQL: DROP TABLE T4;Drop Table T5; drop table T6
42
43expected results:
44
45
46message:
47java.sql.SQLException: statement is invalid
48actual results:
49
50******
51
52Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:76 returned an unexpected result:
53******
54Type:
55SQL: drop table t7; drop table t8; drop table t9
56
57expected results:
58
59
60message:
61java.sql.SQLException: statement is invalid
62actual results:
63
64******
65
66Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:215 returned an unexpected result:
67******
68Type: r
69SQL: update test set nr=2;select avg(nr) from test
70expected results:
712
72
73
74message:
75java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
76actual results:
77no result
78******
79
80Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:216 returned an unexpected result:
81******
82Type: r
83SQL: update test set nr=1+1*2;select sum(nr) from test
84expected results:
853
86
87
88message:
89java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
90actual results:
91no result
92******
93
94Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:217 returned an unexpected result:
95******
96Type: r
97SQL: update test set nr=-(select max(t2.nr) from test t2);select nr from test
98expected results:
99-3
100
101
102message:
103java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
104actual results:
105no result
106******
107
108Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:218 returned an unexpected result:
109******
110Type: r
111SQL: update test set nr=2*(1- -1);select nr from test
112expected results:
1134
114
115
116message:
117java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
118actual results:
119no result
120******
121
122Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:219 returned an unexpected result:
123******
124Type: r
125SQL: select sum(nr) from test where nr in(select t2.nr from test t2)
126expected results:
1274
128
129
130message:
131Expected row 1 of the ResultSet to contain:
1324
133but field 1 contained 1
134actual results:
1351
136
137******
138
139Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:225 returned an unexpected result:
140******
141Type: r
142SQL: update test set nr=4/2;select "TEST"."NR" from test
143expected results:
1442
145
146
147message:
148java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
149actual results:
150no result
151******
152
153Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:226 returned an unexpected result:
154******
155Type: r
156SQL: update test set name='3' || '4';select distinct name from test
157expected results:
15834
159
160
161message:
162java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
163actual results:
164no result
165******
166
167Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:227 returned an unexpected result:
168******
169Type: r
170SQL: select 'Ho' as hhoo from TEsT where name in ('34','y','z')
171expected results:
172Ho
173
174
175message:
176Expected the ResultSet to contain 1 rows, but it contained 0 rows.
177actual results:
178
179******
180
181Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:239 returned an unexpected result:
182******
183Type:
184SQL: drop table address drop table place drop table invoices
185
186expected results:
187
188
189message:
190java.sql.SQLException: statement is invalid
191actual results:
192
193******
194
195Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:240 returned an unexpected result:
196******
197Type:
198SQL: drop table t_double;drop table t_date drop table t_bit
199
200expected results:
201
202
203message:
204java.sql.SQLException: statement is invalid
205actual results:
206
207******
208
209Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:241 returned an unexpected result:
210******
211Type:
212SQL: drop table problem; drop table class
213
214expected results:
215
216
217message:
218java.sql.SQLException: statement is invalid
219actual results:
220
221******
222
223Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:244 returned an unexpected result:
224******
225Type:
226SQL: CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
227 address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
228 state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
229 phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
230
231expected results:
232
233
234message:
235java.sql.SQLSyntaxErrorException: object name already exists: ADDRESS in statement [CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
236 address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
237 state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
238 phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
239]
240actual results:
241
242******
243
244Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:250 returned an unexpected result:
245******
246Type: u
247SQL: INSERT INTO ADDRESS(ID, countryID) VALUES(5, (SELECT ID FROM Country WHERE name = 'USA'))
248expected results:
2491
250
251message:
252java.lang.Exception: Expected an update count of 1, but got the error: user lacks privilege or object not found: ID
253actual results:
254
255******
256
257Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:252 returned an unexpected result:
258******
259Type:
260SQL: SELECT * FROM ADDRESS INNER JOIN COUNTRY ON CountryID = COUNTRY.ID
261
262expected results:
263
264
265message:
266java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
267actual results:
268
269******
270
271Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:253 returned an unexpected result:
272******
273Type:
274SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
275
276expected results:
277
278
279message:
280java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
281actual results:
282
283******
284
285Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:254 returned an unexpected result:
286******
287Type:
288SQL: INSERT INTO ADDRESS(ID) VALUES(6)
289
290expected results:
291
292
293message:
294java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ID
295actual results:
296
297******
298
299Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:255 returned an unexpected result:
300******
301Type: c
302SQL: SELECT * FROM ADDRESS ad INNER JOIN COUNTRY ON ad.CountryID = COUNTRY.ID
303expected results:
3041
305
306message:
307java.lang.Exception: Expected a ResultSet containing 1 rows, but got the error: user lacks privilege or object not found: AD.COUNTRYID
308actual results:
309
310******
311
312Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:256 returned an unexpected result:
313******
314Type: c
315SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
316expected results:
3172
318
319message:
320java.lang.Exception: Expected a ResultSet containing 2 rows, but got the error: user lacks privilege or object not found: COUNTRYID
321actual results:
322
323******
324
325Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:257 returned an unexpected result:
326******
327Type:
328SQL: SELECT * FROM Address,Country
329 WHERE Address.countryID=Country.ID AND
330 EXISTS (SELECT C.Name FROM Country AS C WHERE C.ID=Country.ID) AND
331 EXISTS (SELECT * FROM Country AS C WHERE C.ID=Address.countryID)
332
333expected results:
334
335
336message:
337java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ADDRESS.COUNTRYID
338actual results:
339
340******
341
342Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:423 returned an unexpected result:
343******
344Type: r
345SQL: insert into test values(3,'123',''); select name from test where nr=3;
346expected results:
347123
348
349
350message:
351java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
352actual results:
353no result
354******
355
356Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:424 returned an unexpected result:
357******
358Type: r
359SQL: insert into test values(4,'','12345'); select other from test where nr=4;
360expected results:
36112345
362
363
364message:
365java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
366actual results:
367no result
368******
369
370Processed 1250 lines from D:\DissProject\testrun\hsqldb\TestSelf.txt
371.[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) entered
372[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) exited
373[Server@7b3300e5]: [Thread[main,5,main]]: setDatabaseName(0,test)
374[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) entered
375[Server@7b3300e5]: [Thread[main,5,main]]: checkRunning(false) exited
376[Server@7b3300e5]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
377Opened test script file: D:\DissProject\testrun\hsqldb\TestSelf.txt
378Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:46 returned an unexpected result:
379******
380Type:
381SQL: drop table ref2;drop table ref;drop table main
382
383expected results:
384
385
386message:
387java.sql.SQLException: statement is invalid
388actual results:
389
390******
391
392Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:74 returned an unexpected result:
393******
394Type:
395SQL: drop table t1;drop table t2;drop table "T3";
396
397expected results:
398
399
400message:
401java.sql.SQLException: statement is invalid
402actual results:
403
404******
405
406Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:75 returned an unexpected result:
407******
408Type:
409SQL: DROP TABLE T4;Drop Table T5; drop table T6
410
411expected results:
412
413
414message:
415java.sql.SQLException: statement is invalid
416actual results:
417
418******
419
420Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:76 returned an unexpected result:
421******
422Type:
423SQL: drop table t7; drop table t8; drop table t9
424
425expected results:
426
427
428message:
429java.sql.SQLException: statement is invalid
430actual results:
431
432******
433
434Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:215 returned an unexpected result:
435******
436Type: r
437SQL: update test set nr=2;select avg(nr) from test
438expected results:
4392
440
441
442message:
443java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
444actual results:
445no result
446******
447
448Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:216 returned an unexpected result:
449******
450Type: r
451SQL: update test set nr=1+1*2;select sum(nr) from test
452expected results:
4533
454
455
456message:
457java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
458actual results:
459no result
460******
461
462Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:217 returned an unexpected result:
463******
464Type: r
465SQL: update test set nr=-(select max(t2.nr) from test t2);select nr from test
466expected results:
467-3
468
469
470message:
471java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
472actual results:
473no result
474******
475
476Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:218 returned an unexpected result:
477******
478Type: r
479SQL: update test set nr=2*(1- -1);select nr from test
480expected results:
4814
482
483
484message:
485java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
486actual results:
487no result
488******
489
490Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:219 returned an unexpected result:
491******
492Type: r
493SQL: select sum(nr) from test where nr in(select t2.nr from test t2)
494expected results:
4954
496
497
498message:
499Expected row 1 of the ResultSet to contain:
5004
501but field 1 contained 1
502actual results:
5031
504
505******
506
507Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:225 returned an unexpected result:
508******
509Type: r
510SQL: update test set nr=4/2;select "TEST"."NR" from test
511expected results:
5122
513
514
515message:
516java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
517actual results:
518no result
519******
520
521Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:226 returned an unexpected result:
522******
523Type: r
524SQL: update test set name='3' || '4';select distinct name from test
525expected results:
52634
527
528
529message:
530java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
531actual results:
532no result
533******
534
535Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:227 returned an unexpected result:
536******
537Type: r
538SQL: select 'Ho' as hhoo from TEsT where name in ('34','y','z')
539expected results:
540Ho
541
542
543message:
544Expected the ResultSet to contain 1 rows, but it contained 0 rows.
545actual results:
546
547******
548
549Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:239 returned an unexpected result:
550******
551Type:
552SQL: drop table address drop table place drop table invoices
553
554expected results:
555
556
557message:
558java.sql.SQLException: statement is invalid
559actual results:
560
561******
562
563Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:240 returned an unexpected result:
564******
565Type:
566SQL: drop table t_double;drop table t_date drop table t_bit
567
568expected results:
569
570
571message:
572java.sql.SQLException: statement is invalid
573actual results:
574
575******
576
577Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:241 returned an unexpected result:
578******
579Type:
580SQL: drop table problem; drop table class
581
582expected results:
583
584
585message:
586java.sql.SQLException: statement is invalid
587actual results:
588
589******
590
591Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:244 returned an unexpected result:
592******
593Type:
594SQL: CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
595 address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
596 state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
597 phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
598
599expected results:
600
601
602message:
603java.sql.SQLSyntaxErrorException: object name already exists: ADDRESS in statement [CREATE TABLE Address(ID INTEGER PRIMARY KEY,organization VARCHAR(20),
604 address1 VARCHAR(20),address2 VARCHAR(20),address3 VARCHAR(20),city VARCHAR(20),
605 state VARCHAR(20),zipCode VARCHAR(20),countryID INTEGER,phone VARCHAR(20),
606 phoneExtension VARCHAR(20),fax VARCHAR(20),eMail VARCHAR(20))
607]
608actual results:
609
610******
611
612Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:250 returned an unexpected result:
613******
614Type: u
615SQL: INSERT INTO ADDRESS(ID, countryID) VALUES(5, (SELECT ID FROM Country WHERE name = 'USA'))
616expected results:
6171
618
619message:
620java.lang.Exception: Expected an update count of 1, but got the error: user lacks privilege or object not found: ID
621actual results:
622
623******
624
625Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:252 returned an unexpected result:
626******
627Type:
628SQL: SELECT * FROM ADDRESS INNER JOIN COUNTRY ON CountryID = COUNTRY.ID
629
630expected results:
631
632
633message:
634java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
635actual results:
636
637******
638
639Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:253 returned an unexpected result:
640******
641Type:
642SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
643
644expected results:
645
646
647message:
648java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: COUNTRYID
649actual results:
650
651******
652
653Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:254 returned an unexpected result:
654******
655Type:
656SQL: INSERT INTO ADDRESS(ID) VALUES(6)
657
658expected results:
659
660
661message:
662java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ID
663actual results:
664
665******
666
667Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:255 returned an unexpected result:
668******
669Type: c
670SQL: SELECT * FROM ADDRESS ad INNER JOIN COUNTRY ON ad.CountryID = COUNTRY.ID
671expected results:
6721
673
674message:
675java.lang.Exception: Expected a ResultSet containing 1 rows, but got the error: user lacks privilege or object not found: AD.COUNTRYID
676actual results:
677
678******
679
680Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:256 returned an unexpected result:
681******
682Type: c
683SQL: SELECT * FROM ADDRESS LEFT JOIN COUNTRY ON CountryID = COUNTRY.ID
684expected results:
6852
686
687message:
688java.lang.Exception: Expected a ResultSet containing 2 rows, but got the error: user lacks privilege or object not found: COUNTRYID
689actual results:
690
691******
692
693Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:257 returned an unexpected result:
694******
695Type:
696SQL: SELECT * FROM Address,Country
697 WHERE Address.countryID=Country.ID AND
698 EXISTS (SELECT C.Name FROM Country AS C WHERE C.ID=Country.ID) AND
699 EXISTS (SELECT * FROM Country AS C WHERE C.ID=Address.countryID)
700
701expected results:
702
703
704message:
705java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ADDRESS.COUNTRYID
706actual results:
707
708******
709
710Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:423 returned an unexpected result:
711******
712Type: r
713SQL: insert into test values(3,'123',''); select name from test where nr=3;
714expected results:
715123
716
717
718message:
719java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
720actual results:
721no result
722******
723
724Section starting at D:\DissProject\testrun\hsqldb\TestSelf.txt:424 returned an unexpected result:
725******
726Type: r
727SQL: insert into test values(4,'','12345'); select other from test where nr=4;
728expected results:
72912345
730
731
732message:
733java.lang.Exception: Expected a ResultSet, but got the error: statement is invalid
734actual results:
735no result
736******
737
738Processed 1250 lines from D:\DissProject\testrun\hsqldb\TestSelf.txt
739.[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) entered
740[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) exited
741[Server@2e5c649]: [Thread[main,5,main]]: setDatabaseName(0,test)
742[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) entered
743[Server@2e5c649]: [Thread[main,5,main]]: checkRunning(false) exited
744[Server@2e5c649]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
745Table: T1 priv: SELECT
746Table: T1 priv: INSERT
747Table: T1 priv: UPDATE
748Table: T1 priv: DELETE
749Table: T1 priv: REFERENCES
750Table: T1 priv: TRIGGER
751Table: T1 IndexName: T1
752Table: T2 IndexName: T2
753.[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) entered
754[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) exited
755[Server@136432db]: [Thread[main,5,main]]: setDatabaseName(0,test)
756[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) entered
757[Server@136432db]: [Thread[main,5,main]]: checkRunning(false) exited
758[Server@136432db]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
759.[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) entered
760[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) exited
761[Server@7382f612]: [Thread[main,5,main]]: setDatabaseName(0,test)
762[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) entered
763[Server@7382f612]: [Thread[main,5,main]]: checkRunning(false) exited
764[Server@7382f612]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
765.[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) entered
766[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) exited
767[Server@1055e4af]: [Thread[main,5,main]]: setDatabaseName(0,test)
768[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) entered
769[Server@1055e4af]: [Thread[main,5,main]]: checkRunning(false) exited
770[Server@1055e4af]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
771.................................
772.[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) entered
773[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) exited
774[Server@24273305]: [Thread[main,5,main]]: setDatabaseName(0,test)
775[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) entered
776[Server@24273305]: [Thread[main,5,main]]: checkRunning(false) exited
777[Server@24273305]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
778.[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) entered
779[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) exited
780[Server@5b1d2887]: [Thread[main,5,main]]: setDatabaseName(0,test)
781[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) entered
782[Server@5b1d2887]: [Thread[main,5,main]]: checkRunning(false) exited
783[Server@5b1d2887]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
78433
78534
78635
78736
78837
78938
79039
79140
79241
79342
794.[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) entered
795[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) exited
796[Server@46f5f779]: [Thread[main,5,main]]: setDatabaseName(0,test)
797[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) entered
798[Server@46f5f779]: [Thread[main,5,main]]: checkRunning(false) exited
799[Server@46f5f779]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
800generated: 33
80134
80235
80336
80437
80538
806.[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) entered
807[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) exited
808[Server@1c2c22f3]: [Thread[main,5,main]]: setDatabaseName(0,test)
809[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) entered
810[Server@1c2c22f3]: [Thread[main,5,main]]: checkRunning(false) exited
811[Server@1c2c22f3]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
8120
8130
814.[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) entered
815[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) exited
816[Server@18e8568]: [Thread[main,5,main]]: setDatabaseName(0,test)
817[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) entered
818[Server@18e8568]: [Thread[main,5,main]]: checkRunning(false) exited
819[Server@18e8568]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
820generated: 33
82134
82235
82336
82437
82538
826.[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) entered
827[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) exited
828[Server@33e5ccce]: [Thread[main,5,main]]: setDatabaseName(0,test)
829[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) entered
830[Server@33e5ccce]: [Thread[main,5,main]]: checkRunning(false) exited
831[Server@33e5ccce]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
832.SetUp (sub-)test: testBlobA
833Starting (sub-)test: testBlobA
834TearDown (sub-)test: testBlobA
835.SetUp (sub-)test: testClobD
836Starting (sub-)test: testClobD
837Time for inserts in 248 ms.
838Time for updates in 9 ms.
839TearDown (sub-)test: testClobD
840.SetUp (sub-)test: testBlobH
841Starting (sub-)test: testBlobH
842TearDown (sub-)test: testBlobH
843.SetUp (sub-)test: testClobA
844Starting (sub-)test: testClobA
845TearDown (sub-)test: testClobA
846.SetUp (sub-)test: testBlobI
847Starting (sub-)test: testBlobI
848Running insert...
849Running update...
850Running select...
851Results: 0
852Result: 3
853TearDown (sub-)test: testBlobI
854.SetUp (sub-)test: testClobB
855Starting (sub-)test: testClobB
856TearDown (sub-)test: testClobB
857.SetUp (sub-)test: testClobC
858Starting (sub-)test: testClobC
859TearDown (sub-)test: testClobC
860.SetUp (sub-)test: testClobG
861Starting (sub-)test: testClobG
862TearDown (sub-)test: testClobG
863.SetUp (sub-)test: testClobF
864Starting (sub-)test: testClobF
865TearDown (sub-)test: testClobF
866.SetUp (sub-)test: testClobE
867Starting (sub-)test: testClobE
868Time for inserts in 9 ms.
869Time for updates in 14 ms.
870TearDown (sub-)test: testClobE
871.SetUp (sub-)test: testClobH
872Starting (sub-)test: testClobH
873dafsdfasdf
874TearDown (sub-)test: testClobH
875.SetUp (sub-)test: testBlobB
876Starting (sub-)test: testBlobB
877Size of retrieved blob: 11
878Size of retrieved blob: 11
879TearDown (sub-)test: testBlobB
880.[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) entered
881[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) exited
882[Server@11e21d0e]: [Thread[main,5,main]]: setDatabaseName(0,test)
883[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) entered
884[Server@11e21d0e]: [Thread[main,5,main]]: checkRunning(false) exited
885[Server@11e21d0e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
886Table SA.T, expecting 3 rows total:
887I:0:A:A :B:a :
888I:1:A:B :B:b :
889I:4:A:C :B:c :
890
891Table SA.S, expecting 4 rows total:
892I:0:A:D :B:d :C:Dd :
893I:2:A:E :B:e :C:Ee :
894I:3:A:F :B:f :C:Ff :
895I:4:A:G :B:g :C:Gg :
896
897Table SA.T, expecting 4 rows total:
898I:0:A:A :B:a :
899I:1:A:B :B:b :
900I:4:A:C :B:c :
901I:10:A:testA :B:INSERTED :
902
903testMerge10 complete
904
905.[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) entered
906[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) exited
907[Server@1dd02175]: [Thread[main,5,main]]: setDatabaseName(0,test)
908[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) entered
909[Server@1dd02175]: [Thread[main,5,main]]: checkRunning(false) exited
910[Server@1dd02175]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
911Table SA.T, expecting 3 rows total:
912I:0:A:A :B:a :
913I:1:A:B :B:b :
914I:4:A:C :B:c :
915
916Table SA.S, expecting 4 rows total:
917I:0:A:D :B:d :C:Dd :
918I:2:A:E :B:e :C:Ee :
919I:3:A:F :B:f :C:Ff :
920I:4:A:G :B:g :C:Gg :
921
922Table SA.T, expecting 3 rows total:
923I:0:A:A :B:a :
924I:1:A:B :B:b :
925I:4:A:G :B:UPDATED :
926
927testMerge7 complete
928
929.[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) entered
930[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) exited
931[Server@31206beb]: [Thread[main,5,main]]: setDatabaseName(0,test)
932[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) entered
933[Server@31206beb]: [Thread[main,5,main]]: checkRunning(false) exited
934[Server@31206beb]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
935Table SA.T, expecting 3 rows total:
936I:0:A:A :B:a :
937I:1:A:B :B:b :
938I:4:A:C :B:c :
939
940Table SA.S, expecting 4 rows total:
941I:0:A:D :B:d :C:Dd :
942I:2:A:E :B:e :C:Ee :
943I:3:A:F :B:f :C:Ff :
944I:4:A:G :B:g :C:Gg :
945
946Table SA.T, expecting 4 rows total:
947I:0:A:A :B:a :
948I:1:A:B :B:b :
949I:3:A:F :B:INSERTED :
950I:4:A:G :B:UPDATED :
951
952testMerge9 complete
953
954.[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) entered
955[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) exited
956[Server@3e77a1ed]: [Thread[main,5,main]]: setDatabaseName(0,test)
957[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) entered
958[Server@3e77a1ed]: [Thread[main,5,main]]: checkRunning(false) exited
959[Server@3e77a1ed]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
960Table SA.T, expecting 3 rows total:
961I:0:A:A :B:a :
962I:1:A:B :B:b :
963I:4:A:C :B:c :
964
965Table SA.S, expecting 4 rows total:
966I:0:A:D :B:d :C:Dd :
967I:2:A:E :B:e :C:Ee :
968I:3:A:F :B:f :C:Ff :
969I:4:A:G :B:g :C:Gg :
970
971Table SA.T, expecting 4 rows total:
972I:0:A:A :B:a :
973I:1:A:B :B:b :
974I:3:A:F :B:INSERTED :
975I:4:A:C :B:c :
976
977testMerge8 complete
978
979.[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) entered
980[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) exited
981[Server@3ffcd140]: [Thread[main,5,main]]: setDatabaseName(0,test)
982[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) entered
983[Server@3ffcd140]: [Thread[main,5,main]]: checkRunning(false) exited
984[Server@3ffcd140]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
985Table SA.T, expecting 3 rows total:
986I:0:A:A :B:a :
987I:1:A:B :B:b :
988I:4:A:C :B:c :
989
990Table SA.S, expecting 4 rows total:
991I:0:A:D :B:d :C:Dd :
992I:2:A:E :B:e :C:Ee :
993I:3:A:F :B:f :C:Ff :
994I:4:A:G :B:g :C:Gg :
995
996Table SA.T, expecting 5 rows total:
997I:0:A:D :B:UPDATED :
998I:1:A:B :B:b :
999I:2:A:E :B:INSERTED :
1000I:3:A:F :B:INSERTED :
1001I:4:A:G :B:UPDATED :
1002
1003testMerge5 complete
1004
1005.[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) entered
1006[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) exited
1007[Server@23bb8443]: [Thread[main,5,main]]: setDatabaseName(0,test)
1008[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) entered
1009[Server@23bb8443]: [Thread[main,5,main]]: checkRunning(false) exited
1010[Server@23bb8443]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1011Table SA.T, expecting 3 rows total:
1012I:0:A:A :B:a :
1013I:1:A:B :B:b :
1014I:4:A:C :B:c :
1015
1016Table SA.S, expecting 4 rows total:
1017I:0:A:D :B:d :C:Dd :
1018I:2:A:E :B:e :C:Ee :
1019I:3:A:F :B:f :C:Ff :
1020I:4:A:G :B:g :C:Gg :
1021
1022Table SA.T, expecting 5 rows total:
1023I:0:A:A :B:a :
1024I:1:A:B :B:b :
1025I:2:A:E :B:INSERTED :
1026I:3:A:F :B:INSERTED :
1027I:4:A:C :B:c :
1028
1029testMerge3 complete
1030
1031.[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) entered
1032[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) exited
1033[Server@1176dcec]: [Thread[main,5,main]]: setDatabaseName(0,test)
1034[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) entered
1035[Server@1176dcec]: [Thread[main,5,main]]: checkRunning(false) exited
1036[Server@1176dcec]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1037Table SA.T, expecting 3 rows total:
1038I:0:A:A :B:a :
1039I:1:A:B :B:b :
1040I:4:A:C :B:c :
1041
1042Table SA.S, expecting 4 rows total:
1043I:0:A:D :B:d :C:Dd :
1044I:2:A:E :B:e :C:Ee :
1045I:3:A:F :B:f :C:Ff :
1046I:4:A:G :B:g :C:Gg :
1047
1048Table SA.T, expecting 5 rows total:
1049I:0:A:D :B:UPDATED :
1050I:1:A:B :B:b :
1051I:2:A:E :B:INSERTED :
1052I:3:A:F :B:INSERTED :
1053I:4:A:G :B:UPDATED :
1054
1055testMerge1 complete
1056
1057.[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) entered
1058[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) exited
1059[Server@120d6fe6]: [Thread[main,5,main]]: setDatabaseName(0,test)
1060[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) entered
1061[Server@120d6fe6]: [Thread[main,5,main]]: checkRunning(false) exited
1062[Server@120d6fe6]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1063Table SA.T, expecting 3 rows total:
1064I:0:A:A :B:a :
1065I:1:A:B :B:b :
1066I:4:A:C :B:c :
1067
1068Table SA.S, expecting 4 rows total:
1069I:0:A:D :B:d :C:Dd :
1070I:2:A:E :B:e :C:Ee :
1071I:3:A:F :B:f :C:Ff :
1072I:4:A:G :B:g :C:Gg :
1073
1074Table SA.T, expecting 3 rows total:
1075I:0:A:D :B:UPDATED :
1076I:1:A:B :B:b :
1077I:4:A:G :B:UPDATED :
1078
1079testMerge2 complete
1080
1081.[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) entered
1082[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) exited
1083[Server@4ba2ca36]: [Thread[main,5,main]]: setDatabaseName(0,test)
1084[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) entered
1085[Server@4ba2ca36]: [Thread[main,5,main]]: checkRunning(false) exited
1086[Server@4ba2ca36]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1087Table SA.T, expecting 3 rows total:
1088I:0:A:A :B:a :
1089I:1:A:B :B:b :
1090I:4:A:C :B:c :
1091
1092Table SA.S, expecting 4 rows total:
1093I:0:A:D :B:d :C:Dd :
1094I:2:A:E :B:e :C:Ee :
1095I:3:A:F :B:f :C:Ff :
1096I:4:A:G :B:g :C:Gg :
1097
1098Table SA.T, expecting 5 rows total:
1099I:0:A:D :B:UPDATED :
1100I:1:A:B :B:b :
1101I:2:A:E :B:INSERTED :
1102I:3:A:F :B:INSERTED :
1103I:4:A:G :B:UPDATED :
1104
1105testMerge6 complete
1106
1107.[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) entered
1108[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) exited
1109[Server@3444d69d]: [Thread[main,5,main]]: setDatabaseName(0,test)
1110[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) entered
1111[Server@3444d69d]: [Thread[main,5,main]]: checkRunning(false) exited
1112[Server@3444d69d]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1113Table SA.T, expecting 3 rows total:
1114I:0:A:A :B:a :
1115I:1:A:B :B:b :
1116I:4:A:C :B:c :
1117
1118Table SA.S, expecting 4 rows total:
1119I:0:A:D :B:d :C:Dd :
1120I:2:A:E :B:e :C:Ee :
1121I:3:A:F :B:f :C:Ff :
1122I:4:A:G :B:g :C:Gg :
1123
1124Table SA.T, expecting 5 rows total:
1125I:0:A:D :B:UPDATED :
1126I:1:A:B :B:b :
1127I:2:A:E :B:INSERTED :
1128I:3:A:F :B:INSERTED :
1129I:4:A:G :B:UPDATED :
1130
1131testMerge4 complete
1132
1133.[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) entered
1134[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) exited
1135[Server@1372ed45]: [Thread[main,5,main]]: setDatabaseName(0,test)
1136[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) entered
1137[Server@1372ed45]: [Thread[main,5,main]]: checkRunning(false) exited
1138[Server@1372ed45]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1139Table SA.T, expecting 3 rows total:
1140I:0:A:A :B:a :
1141I:1:A:B :B:b :
1142I:4:A:C :B:c :
1143
1144Table SA.S, expecting 4 rows total:
1145I:0:A:D :B:d :C:Dd :
1146I:2:A:E :B:e :C:Ee :
1147I:3:A:F :B:f :C:Ff :
1148I:4:A:G :B:g :C:Gg :
1149
1150Table SA.T, expecting 4 rows total:
1151I:0:A:A :B:a :
1152I:1:A:B :B:b :
1153I:4:A:C :B:c :
1154I:10:A:testA :B:INSERTED :
1155
1156testMerge10 complete
1157
1158.[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) entered
1159[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) exited
1160[Server@6a79c292]: [Thread[main,5,main]]: setDatabaseName(0,test)
1161[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) entered
1162[Server@6a79c292]: [Thread[main,5,main]]: checkRunning(false) exited
1163[Server@6a79c292]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1164Table T, expecting 2 rows total:
1165I:0:A:A :B:a :
1166I:1:A:B :B:b :
1167
1168Table T, expecting 6 rows total:
1169I:0:A:A :B:a :
1170I:1:A:B :B:b :
1171I:2:A:single1 :B:s1 :
1172I:3:A:single2 :B:s2 :
1173I:4:A:double1 :B:d1 :
1174I:5:A:double2 :B:d2 :
1175
1176Table T, expecting 9 rows total:
1177I:0:A:A :B:a :
1178I:1:A:B :B:b :
1179I:2:A:single1 :B:s1 :
1180I:3:A:single2 :B:s2 :
1181I:4:A:double1 :B:d1 :
1182I:5:A:double2 :B:d2 :
1183I:6:A:prepared1 :B:test1 :
1184I:7:A:prepared2 :B:test2 :
1185I:8:A:prepared3 :B:test3 :
1186
1187testMultiInsert complete
1188.[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) entered
1189[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) exited
1190[Server@37574691]: [Thread[main,5,main]]: setDatabaseName(0,test)
1191[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) entered
1192[Server@37574691]: [Thread[main,5,main]]: checkRunning(false) exited
1193[Server@37574691]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1194.[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) entered
1195[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) exited
1196[Server@25359ed8]: [Thread[main,5,main]]: setDatabaseName(0,test)
1197[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) entered
1198[Server@25359ed8]: [Thread[main,5,main]]: checkRunning(false) exited
1199[Server@25359ed8]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1200.[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) entered
1201[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) exited
1202[Server@21a947fe]: [Thread[main,5,main]]: setDatabaseName(0,test)
1203[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) entered
1204[Server@21a947fe]: [Thread[main,5,main]]: checkRunning(false) exited
1205[Server@21a947fe]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1206.[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) entered
1207[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) exited
1208[Server@5606c0b]: [Thread[main,5,main]]: setDatabaseName(0,test)
1209[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) entered
1210[Server@5606c0b]: [Thread[main,5,main]]: checkRunning(false) exited
1211[Server@5606c0b]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1212.[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) entered
1213[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) exited
1214[Server@57d5872c]: [Thread[main,5,main]]: setDatabaseName(0,test)
1215[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) entered
1216[Server@57d5872c]: [Thread[main,5,main]]: checkRunning(false) exited
1217[Server@57d5872c]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1218.[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) entered
1219[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) exited
1220[Server@667a738]: [Thread[main,5,main]]: setDatabaseName(0,test)
1221[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) entered
1222[Server@667a738]: [Thread[main,5,main]]: checkRunning(false) exited
1223[Server@667a738]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1224Testing DatabaseMetaData methods
12252
12263
1227HSQL Database Engine
12282.3.6
12292
12302
12313
1232HSQL Database Engine Driver
12332.3.6
1234
1235"
12364
12370
12380
1239128
12400
12410
12420
12430
12440
12450
1246128
12470
1248128
12490
1250128
12510
12520
1253128
1254128
1255ABS,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
1256PROCEDURE
12571
1258SCHEMA
1259\
1260Testing DatabaseMetaData.getSQLKeywords()
1261
12622
1263Testing DatabaseMetaData.getStringFunctions()
1264ASCII,CHAR,CONCAT,DIFFERENCE,HEXTORAW,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,RAWTOHEX,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTR,UCASE
1265Testing DatabaseMetaData.getSystemFunctions()
1266DATABASE,IFNULL,USER
1267Testing DatabaseMetaData.getTimeDateFunctions()
1268CURDATE,CURTIME,DATEDIFF,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,HOUR,MINUTE,MONTH,MONTHNAME,NOW,QUARTER,SECOND,SECONDS_SINCE_MIDNIGHT,TIMESTAMPADD,TIMESTAMPDIFF,TO_CHAR,WEEK,YEAR
1269jdbc:hsqldb:hsql://localhost/test
1270SA
12710
1272true
1273false
1274PUBLIC:PUBLIC:USER:USER_ID:1:SYS_PK_10093:
1275
12760:USER_ID:4:INTEGER:32:null:null:1:PUBLIC:PUBLIC:USER:0:TRUE:
1277
1278PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK:USER_ID:1:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
1279PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:CATEGORY_ID:PUBLIC:PUBLIC:ADDRESSBOOK:CATEGORY_ID:2:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
1280
1281PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK:USER_ID:1:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
1282PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:CATEGORY_ID:PUBLIC:PUBLIC:ADDRESSBOOK:CATEGORY_ID:2:3:0:FK_ADRBOOK1:SYS_PK_ADDRESSBOOK_CATEGORY:7:
1283
1284PUBLIC:PUBLIC:USER:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:1:3:0:FK_ADRBKCAT1:SYS_PK_10093:7:
1285
1286PUBLIC:PUBLIC:USER:USER_ID:PUBLIC:PUBLIC:ADDRESSBOOK_CATEGORY:USER_ID:1:3:0:FK_ADRBKCAT1:SYS_PK_10093:7:
1287
1288I:0:A:get_column_name :B:false :A:get_column_name :B:false :C6:1:
1289I:0:A:get_column_name :B:false :aliasA:get_column_name :aliasB:false :C6:1:
1290
1291first column identity: true
1292call identity(): 1
1293testMetaData complete
1294.[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) entered
1295[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) exited
1296[Server@36f0f1be]: [Thread[main,5,main]]: setDatabaseName(0,test)
1297[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) entered
1298[Server@36f0f1be]: [Thread[main,5,main]]: checkRunning(false) exited
1299[Server@36f0f1be]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1300.[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) entered
1301[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) exited
1302[Server@157632c9]: [Thread[main,5,main]]: setDatabaseName(0,test)
1303[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) entered
1304[Server@157632c9]: [Thread[main,5,main]]: checkRunning(false) exited
1305[Server@157632c9]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1306java.sql.SQLException: statement is invalid
1307 at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:418)
1308 at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)
1309 at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:2104)
1310 at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:620)
1311 at org.hsqldb.test.TestSql.testAny(TestSql.java:519)
1312 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1313 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1314 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1315 at java.lang.reflect.Method.invoke(Method.java:498)
1316 at junit.framework.TestCase.runTest(TestCase.java:154)
1317 at junit.framework.TestCase.runBare(TestCase.java:127)
1318 at junit.framework.TestResult$1.protect(TestResult.java:106)
1319 at junit.framework.TestResult.runProtected(TestResult.java:124)
1320 at junit.framework.TestResult.run(TestResult.java:109)
1321 at junit.framework.TestCase.run(TestCase.java:118)
1322 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1323 at junit.framework.TestSuite.run(TestSuite.java:203)
1324 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1325 at junit.framework.TestSuite.run(TestSuite.java:203)
1326 at junit.textui.TestRunner.doRun(TestRunner.java:116)
1327 at junit.textui.TestRunner.doRun(TestRunner.java:109)
1328 at junit.textui.TestRunner.run(TestRunner.java:72)
1329 at org.hsqldb.test.AllTests.main(AllTests.java:82)
1330TestSql.testAny() error: statement is invalid
1331testAny complete
1332.[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) entered
1333[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) exited
1334[Server@55040f2f]: [Thread[main,5,main]]: setDatabaseName(0,test)
1335[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) entered
1336[Server@55040f2f]: [Thread[main,5,main]]: checkRunning(false) exited
1337[Server@55040f2f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1338Max value for i: 2147483647
1339Max value for ID: 0
1340testDoubleNaN complete
1341.[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) entered
1342[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) exited
1343[Server@64c87930]: [Thread[main,5,main]]: setDatabaseName(0,test)
1344[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) entered
1345[Server@64c87930]: [Thread[main,5,main]]: checkRunning(false) exited
1346[Server@64c87930]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1347.
1348[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) entered
1349[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) exited
1350[Server@400cff1a]: [Thread[main,5,main]]: setDatabaseName(0,test)
1351[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) entered
1352[Server@400cff1a]: [Thread[main,5,main]]: checkRunning(false) exited
1353[Server@400cff1a]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1354.[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) entered
1355[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) exited
1356[Server@275710fc]: [Thread[main,5,main]]: setDatabaseName(0,test)
1357[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) entered
1358[Server@275710fc]: [Thread[main,5,main]]: checkRunning(false) exited
1359[Server@275710fc]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1360.[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) entered
1361[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) exited
1362[Server@525f1e4e]: [Thread[main,5,main]]: setDatabaseName(0,test)
1363[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) entered
1364[Server@525f1e4e]: [Thread[main,5,main]]: checkRunning(false) exited
1365[Server@525f1e4e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1366.[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) entered
1367[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) exited
1368[Server@75f9eccc]: [Thread[main,5,main]]: setDatabaseName(0,test)
1369[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) entered
1370[Server@75f9eccc]: [Thread[main,5,main]]: checkRunning(false) exited
1371[Server@75f9eccc]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1372.[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) entered
1373[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) exited
1374[Server@52aa2946]: [Thread[main,5,main]]: setDatabaseName(0,test)
1375[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) entered
1376[Server@52aa2946]: [Thread[main,5,main]]: checkRunning(false) exited
1377[Server@52aa2946]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1378.[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) entered
1379[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) exited
1380[Server@4de5031f]: [Thread[main,5,main]]: setDatabaseName(0,test)
1381[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) entered
1382[Server@4de5031f]: [Thread[main,5,main]]: checkRunning(false) exited
1383[Server@4de5031f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1384..Opened test script file: D:\DissProject\testrun\hsqldb\TestText01.txt
1385Processed 35 lines from D:\DissProject\testrun\hsqldb\TestText01.txt
1386Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
1387Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
1388..Opened test script file: D:\DissProject\testrun\hsqldb\TestText01.txt
1389Processed 35 lines from D:\DissProject\testrun\hsqldb\TestText01.txt
1390Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
1391Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
1392..2018-11-06T21:27:59.160+0000 WARNING Problem processing SET TABLE SOURCE
1393org.hsqldb.HsqlException: Header not allowed or too long
1394 at org.hsqldb.error.Error.error(Error.java:138)
1395 at org.hsqldb.error.Error.error(Error.java:107)
1396 at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
1397 at org.hsqldb.TextTable.setHeader(TextTable.java:270)
1398 at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
1399 at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
1400 at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
1401 at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
1402 at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
1403 at org.hsqldb.persist.Log.processScript(Log.java:758)
1404 at org.hsqldb.persist.Log.open(Log.java:144)
1405 at org.hsqldb.persist.Logger.open(Logger.java:389)
1406 at org.hsqldb.Database.reopen(Database.java:227)
1407 at org.hsqldb.Database.open(Database.java:209)
1408 at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
1409 at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
1410 at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
1411 at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
1412 at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
1413 at java.sql.DriverManager.getConnection(DriverManager.java:664)
1414 at java.sql.DriverManager.getConnection(DriverManager.java:247)
1415 at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
1416 at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
1417 at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
1418 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1419 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1420 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1421 at java.lang.reflect.Method.invoke(Method.java:498)
1422 at junit.framework.TestCase.runTest(TestCase.java:154)
1423 at junit.framework.TestCase.runBare(TestCase.java:127)
1424 at junit.framework.TestResult$1.protect(TestResult.java:106)
1425 at junit.framework.TestResult.runProtected(TestResult.java:124)
1426 at junit.framework.TestResult.run(TestResult.java:109)
1427 at junit.framework.TestCase.run(TestCase.java:118)
1428 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1429 at junit.framework.TestSuite.run(TestSuite.java:203)
1430 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1431 at junit.framework.TestSuite.run(TestSuite.java:203)
1432 at junit.textui.TestRunner.doRun(TestRunner.java:116)
1433 at junit.textui.TestRunner.doRun(TestRunner.java:109)
1434 at junit.textui.TestRunner.run(TestRunner.java:72)
1435 at org.hsqldb.test.AllTests.main(AllTests.java:82)
1436
14372018-11-06T21:27:59.162+0000 WARNING Problem processing SET TABLE SOURCE
1438org.hsqldb.HsqlException: Header not allowed or too long
1439 at org.hsqldb.error.Error.error(Error.java:138)
1440 at org.hsqldb.error.Error.error(Error.java:107)
1441 at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
1442 at org.hsqldb.TextTable.setHeader(TextTable.java:270)
1443 at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
1444 at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
1445 at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
1446 at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
1447 at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
1448 at org.hsqldb.persist.Log.processScript(Log.java:758)
1449 at org.hsqldb.persist.Log.open(Log.java:144)
1450 at org.hsqldb.persist.Logger.open(Logger.java:389)
1451 at org.hsqldb.Database.reopen(Database.java:227)
1452 at org.hsqldb.Database.open(Database.java:209)
1453 at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
1454 at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
1455 at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
1456 at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
1457 at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
1458 at java.sql.DriverManager.getConnection(DriverManager.java:664)
1459 at java.sql.DriverManager.getConnection(DriverManager.java:247)
1460 at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
1461 at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
1462 at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
1463 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1464 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1465 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1466 at java.lang.reflect.Method.invoke(Method.java:498)
1467 at junit.framework.TestCase.runTest(TestCase.java:154)
1468 at junit.framework.TestCase.runBare(TestCase.java:127)
1469 at junit.framework.TestResult$1.protect(TestResult.java:106)
1470 at junit.framework.TestResult.runProtected(TestResult.java:124)
1471 at junit.framework.TestResult.run(TestResult.java:109)
1472 at junit.framework.TestCase.run(TestCase.java:118)
1473 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1474 at junit.framework.TestSuite.run(TestSuite.java:203)
1475 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1476 at junit.framework.TestSuite.run(TestSuite.java:203)
1477 at junit.textui.TestRunner.doRun(TestRunner.java:116)
1478 at junit.textui.TestRunner.doRun(TestRunner.java:109)
1479 at junit.textui.TestRunner.run(TestRunner.java:72)
1480 at org.hsqldb.test.AllTests.main(AllTests.java:82)
1481
14822018-11-06T21:27:59.165+0000 WARNING Problem processing SET TABLE SOURCE
1483org.hsqldb.HsqlException: Header not allowed or too long
1484 at org.hsqldb.error.Error.error(Error.java:138)
1485 at org.hsqldb.error.Error.error(Error.java:107)
1486 at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
1487 at org.hsqldb.TextTable.setHeader(TextTable.java:270)
1488 at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
1489 at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
1490 at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
1491 at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
1492 at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
1493 at org.hsqldb.persist.Log.processScript(Log.java:758)
1494 at org.hsqldb.persist.Log.open(Log.java:144)
1495 at org.hsqldb.persist.Logger.open(Logger.java:389)
1496 at org.hsqldb.Database.reopen(Database.java:227)
1497 at org.hsqldb.Database.open(Database.java:209)
1498 at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
1499 at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
1500 at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
1501 at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
1502 at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
1503 at java.sql.DriverManager.getConnection(DriverManager.java:664)
1504 at java.sql.DriverManager.getConnection(DriverManager.java:247)
1505 at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
1506 at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
1507 at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
1508 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1509 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1510 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1511 at java.lang.reflect.Method.invoke(Method.java:498)
1512 at junit.framework.TestCase.runTest(TestCase.java:154)
1513 at junit.framework.TestCase.runBare(TestCase.java:127)
1514 at junit.framework.TestResult$1.protect(TestResult.java:106)
1515 at junit.framework.TestResult.runProtected(TestResult.java:124)
1516 at junit.framework.TestResult.run(TestResult.java:109)
1517 at junit.framework.TestCase.run(TestCase.java:118)
1518 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1519 at junit.framework.TestSuite.run(TestSuite.java:203)
1520 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1521 at junit.framework.TestSuite.run(TestSuite.java:203)
1522 at junit.textui.TestRunner.doRun(TestRunner.java:116)
1523 at junit.textui.TestRunner.doRun(TestRunner.java:109)
1524 at junit.textui.TestRunner.run(TestRunner.java:72)
1525 at org.hsqldb.test.AllTests.main(AllTests.java:82)
1526
15272018-11-06T21:27:59.167+0000 WARNING Problem processing SET TABLE SOURCE
1528org.hsqldb.HsqlException: Header not allowed or too long
1529 at org.hsqldb.error.Error.error(Error.java:138)
1530 at org.hsqldb.error.Error.error(Error.java:107)
1531 at org.hsqldb.persist.TextCache.setHeader(TextCache.java:421)
1532 at org.hsqldb.TextTable.setHeader(TextTable.java:270)
1533 at org.hsqldb.StatementCommand.getResult(StatementCommand.java:1183)
1534 at org.hsqldb.StatementCommand.execute(StatementCommand.java:237)
1535 at org.hsqldb.Session.executeCompiledStatement(Session.java:1395)
1536 at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:119)
1537 at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
1538 at org.hsqldb.persist.Log.processScript(Log.java:758)
1539 at org.hsqldb.persist.Log.open(Log.java:144)
1540 at org.hsqldb.persist.Logger.open(Logger.java:389)
1541 at org.hsqldb.Database.reopen(Database.java:227)
1542 at org.hsqldb.Database.open(Database.java:209)
1543 at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:259)
1544 at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
1545 at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3507)
1546 at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
1547 at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:233)
1548 at java.sql.DriverManager.getConnection(DriverManager.java:664)
1549 at java.sql.DriverManager.getConnection(DriverManager.java:247)
1550 at org.hsqldb.test.TestBase.newConnection(TestBase.java:167)
1551 at org.hsqldb.test.TestTextTables.partD(TestTextTables.java:353)
1552 at org.hsqldb.test.TestTextTables.testSectionFive(TestTextTables.java:126)
1553 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1554 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1555 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1556 at java.lang.reflect.Method.invoke(Method.java:498)
1557 at junit.framework.TestCase.runTest(TestCase.java:154)
1558 at junit.framework.TestCase.runBare(TestCase.java:127)
1559 at junit.framework.TestResult$1.protect(TestResult.java:106)
1560 at junit.framework.TestResult.runProtected(TestResult.java:124)
1561 at junit.framework.TestResult.run(TestResult.java:109)
1562 at junit.framework.TestCase.run(TestCase.java:118)
1563 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1564 at junit.framework.TestSuite.run(TestSuite.java:203)
1565 at junit.framework.TestSuite.runTest(TestSuite.java:208)
1566 at junit.framework.TestSuite.run(TestSuite.java:203)
1567 at junit.textui.TestRunner.doRun(TestRunner.java:116)
1568 at junit.textui.TestRunner.doRun(TestRunner.java:109)
1569 at junit.textui.TestRunner.run(TestRunner.java:72)
1570 at org.hsqldb.test.AllTests.main(AllTests.java:82)
1571
1572Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
1573Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
1574.Opened test script file: D:\DissProject\testrun\hsqldb\TestText02.txt
1575Processed 6 lines from D:\DissProject\testrun\hsqldb\TestText02.txt
1576....[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) entered
1577[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) exited
1578[Server@415b0b49]: [Thread[main,5,main]]: setDatabaseName(0,test)
1579[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) entered
1580[Server@415b0b49]: [Thread[main,5,main]]: checkRunning(false) exited
1581[Server@415b0b49]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
15821 TEST 1 1010
15832 TEST 2 1010
15843 TEST 3 1010
15854 TEST 4 1010
15865 TEST 5 1010
15876 TEST 6 1010
15887 TEST 7 1010
15898 TEST 8 1010
15909 TEST 9 1010
159112 TEST 12 1010
159213 TEST 13 1010
159314 TEST 14 1010
159415 TEST 15 1010
159516 TEST 16 1010
159617 TEST 17 1010
159718 TEST 18 1010
159819 TEST 19 1010
159920 TEST 20 1010
160010 UPDATE10 1010
16011011 INSERT1011 0101
16021012 def 1010
16031013 def 1111
1604.[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) entered
1605[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) exited
1606[Server@6d5620ce]: [Thread[main,5,main]]: setDatabaseName(0,test)
1607[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) entered
1608[Server@6d5620ce]: [Thread[main,5,main]]: checkRunning(false) exited
1609[Server@6d5620ce]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
16100 s
16111 s
16122 s
16133 s
16144 s
16155 s
16166 s
16177 s
16188 s
16199 s
1620.[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) entered
1621[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) exited
1622[Server@311bf055]: [Thread[main,5,main]]: setDatabaseName(0,test)
1623[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) entered
1624[Server@311bf055]: [Thread[main,5,main]]: checkRunning(false) exited
1625[Server@311bf055]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
1626Deleting row:0
1627Deleting row:7
1628Deleting row:14
1629Deleting row:21
1630Deleting row:28
1631Deleting row:35
1632Deleting row:42
1633Deleting row:49
1634Deleting row:56
1635Deleting row:63
1636Deleting row:70
1637Deleting row:77
1638Deleting row:84
1639Deleting row:91
1640Deleting row:98
1641.[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) entered
1642[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) exited
1643[Server@222a59e6]: [Thread[main,5,main]]: setDatabaseName(0,test)
1644[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) entered
1645[Server@222a59e6]: [Thread[main,5,main]]: checkRunning(false) exited
1646[Server@222a59e6]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
16471 s 1.0
16480 s 0.0
16491 s 1.0
16500 s 0.0
16510 s 0.0
16520 s 0.0
1653.[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) entered
1654[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) exited
1655[Server@6c7a164b]: [Thread[main,5,main]]: setDatabaseName(0,test)
1656[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) entered
1657[Server@6c7a164b]: [Thread[main,5,main]]: checkRunning(false) exited
1658[Server@6c7a164b]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true;sql.restrict_exec=true;hsqldb.tx=mvcc)
16592018-11-06 21:28:03.732 2 COMMIT
16602018-11-06 21:28:03.732 2 drop table t1 if exists
16612018-11-06 21:28:03.732 2 COMMIT
16622018-11-06 21:28:03.733 2 COMMIT
16632018-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))
16642018-11-06 21:28:03.733 2 COMMIT
16652018-11-06 21:28:03.734 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (1,16,0,30)
16662018-11-06 21:28:03.734 1 COMMIT
16672018-11-06 21:28:03.735 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,1)
16682018-11-06 21:28:03.735 1 COMMIT
16692018-11-06 21:28:03.736 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (2,3,0,40)
16702018-11-06 21:28:03.736 1 COMMIT
16712018-11-06 21:28:03.736 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,2)
16722018-11-06 21:28:03.736 1 COMMIT
16732018-11-06 21:28:03.737 2 insert into t1 values(?,?,?,?,?) (0,'0 s',X'002000',1,2)
16742018-11-06 21:28:03.737 2 COMMIT
16752018-11-06 21:28:03.738 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (3,16,0,30)
16762018-11-06 21:28:03.738 1 COMMIT
16772018-11-06 21:28:03.738 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,3)
16782018-11-06 21:28:03.739 1 COMMIT
16792018-11-06 21:28:03.739 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (4,3,0,40)
16802018-11-06 21:28:03.739 1 COMMIT
16812018-11-06 21:28:03.739 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,4)
16822018-11-06 21:28:03.739 1 COMMIT
16832018-11-06 21:28:03.739 2 insert into t1 values(?,?,?,?,?) (1,'1 s',X'012001',3,4)
16842018-11-06 21:28:03.739 2 COMMIT
16852018-11-06 21:28:03.739 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (5,16,0,30)
16862018-11-06 21:28:03.740 1 COMMIT
16872018-11-06 21:28:03.740 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,5)
16882018-11-06 21:28:03.740 1 COMMIT
16892018-11-06 21:28:03.740 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (6,3,0,40)
16902018-11-06 21:28:03.740 1 COMMIT
16912018-11-06 21:28:03.740 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,6)
16922018-11-06 21:28:03.741 1 COMMIT
16932018-11-06 21:28:03.743 2 insert into t1 values(?,?,?,?,?) (2,'2 s',X'022002',5,6)
16942018-11-06 21:28:03.743 2 COMMIT
16952018-11-06 21:28:03.744 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (7,16,0,30)
16962018-11-06 21:28:03.744 1 COMMIT
16972018-11-06 21:28:03.746 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,7)
16982018-11-06 21:28:03.746 1 COMMIT
16992018-11-06 21:28:03.746 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (8,3,0,40)
17002018-11-06 21:28:03.746 1 COMMIT
17012018-11-06 21:28:03.746 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,8)
17022018-11-06 21:28:03.746 1 COMMIT
17032018-11-06 21:28:03.747 2 insert into t1 values(?,?,?,?,?) (3,'3 s',X'032003',7,8)
17042018-11-06 21:28:03.747 2 COMMIT
17052018-11-06 21:28:03.748 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (9,16,0,30)
17062018-11-06 21:28:03.748 1 COMMIT
17072018-11-06 21:28:03.748 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,9)
17082018-11-06 21:28:03.748 1 COMMIT
17092018-11-06 21:28:03.748 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (10,3,0,40)
17102018-11-06 21:28:03.749 1 COMMIT
17112018-11-06 21:28:03.749 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,10)
17122018-11-06 21:28:03.749 1 COMMIT
17132018-11-06 21:28:03.749 2 insert into t1 values(?,?,?,?,?) (4,'4 s',X'042004',9,10)
17142018-11-06 21:28:03.749 2 COMMIT
17152018-11-06 21:28:03.750 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (11,16,0,30)
17162018-11-06 21:28:03.750 1 COMMIT
17172018-11-06 21:28:03.750 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,11)
17182018-11-06 21:28:03.750 1 COMMIT
17192018-11-06 21:28:03.751 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (12,3,0,40)
17202018-11-06 21:28:03.751 1 COMMIT
17212018-11-06 21:28:03.751 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,12)
17222018-11-06 21:28:03.751 1 COMMIT
17232018-11-06 21:28:03.751 2 insert into t1 values(?,?,?,?,?) (5,'5 s',X'052005',11,12)
17242018-11-06 21:28:03.751 2 COMMIT
17252018-11-06 21:28:03.752 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (13,16,0,30)
17262018-11-06 21:28:03.752 1 COMMIT
17272018-11-06 21:28:03.752 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,13)
17282018-11-06 21:28:03.752 1 COMMIT
17292018-11-06 21:28:03.752 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (14,3,0,40)
17302018-11-06 21:28:03.752 1 COMMIT
17312018-11-06 21:28:03.752 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,14)
17322018-11-06 21:28:03.752 1 COMMIT
17332018-11-06 21:28:03.752 2 insert into t1 values(?,?,?,?,?) (6,'6 s',X'062006',13,14)
17342018-11-06 21:28:03.753 2 COMMIT
17352018-11-06 21:28:03.753 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (15,16,0,30)
17362018-11-06 21:28:03.753 1 COMMIT
17372018-11-06 21:28:03.754 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,15)
17382018-11-06 21:28:03.754 1 COMMIT
17392018-11-06 21:28:03.754 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (16,3,0,40)
17402018-11-06 21:28:03.754 1 COMMIT
17412018-11-06 21:28:03.754 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,16)
17422018-11-06 21:28:03.754 1 COMMIT
17432018-11-06 21:28:03.754 2 insert into t1 values(?,?,?,?,?) (7,'7 s',X'072007',15,16)
17442018-11-06 21:28:03.754 2 COMMIT
17452018-11-06 21:28:03.754 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (17,16,0,30)
17462018-11-06 21:28:03.754 1 COMMIT
17472018-11-06 21:28:03.755 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,17)
17482018-11-06 21:28:03.755 1 COMMIT
17492018-11-06 21:28:03.755 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (18,3,0,40)
17502018-11-06 21:28:03.755 1 COMMIT
17512018-11-06 21:28:03.755 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,18)
17522018-11-06 21:28:03.755 1 COMMIT
17532018-11-06 21:28:03.755 2 insert into t1 values(?,?,?,?,?) (8,'8 s',X'082008',17,18)
17542018-11-06 21:28:03.755 2 COMMIT
17552018-11-06 21:28:03.755 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (19,16,0,30)
17562018-11-06 21:28:03.755 1 COMMIT
17572018-11-06 21:28:03.756 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,19)
17582018-11-06 21:28:03.756 1 COMMIT
17592018-11-06 21:28:03.756 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (20,3,0,40)
17602018-11-06 21:28:03.756 1 COMMIT
17612018-11-06 21:28:03.756 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,20)
17622018-11-06 21:28:03.756 1 COMMIT
17632018-11-06 21:28:03.756 2 insert into t1 values(?,?,?,?,?) (9,'9 s',X'092009',19,20)
17642018-11-06 21:28:03.756 2 COMMIT
17652018-11-06 21:28:03.756 2 COMMIT
17662018-11-06 21:28:03.757 2 select i, v, t, b, c from t1 where i > ? (-1)
17672018-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)
17682018-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)
17692018-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)
17702018-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)
17712018-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)
17722018-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)
17732018-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)
17742018-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)
17752018-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)
17762018-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)
17772018-11-06 21:28:03.761 2 select i, v, t, b, c from t1 where i > ? (-1)
17780 s0 s
17791 s1 s
17802 s2 s
17813 s3 s
17824 s4 s
17835 s5 s
17846 s6 s
17857 s7 s
17868 s8 s
17879 s9 s
17882018-11-06 21:28:03.761 2 ROLLBACK
17892018-11-06 21:28:03.762 2 select i, v, t, b, c from t1 where i > ? (-1)
17900 s
17911 s
17922 s
17933 s
17944 s
17955 s
17966 s
17977 s
17988 s
17999 s
18002018-11-06 21:28:03.762 2 COMMIT
18012018-11-06 21:28:03.762 2 select i, v, t, b, c from t1 where i > ? (-1)
18022018-11-06 21:28:03.763 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (21,15,0,40)
18032018-11-06 21:28:03.763 1 COMMIT
18042018-11-06 21:28:03.763 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,21)
18052018-11-06 21:28:03.763 1 COMMIT
18062018-11-06 21:28:03.763 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,21,1202590842880,NULL)
18072018-11-06 21:28:03.764 2 ROLLBACK
18082018-11-06 21:28:03.764 2 select i, v, t, b, c from t1 where i > ? (-1)
18092018-11-06 21:28:03.765 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (22,16,0,30)
18102018-11-06 21:28:03.765 1 COMMIT
18112018-11-06 21:28:03.765 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,22)
18122018-11-06 21:28:03.765 1 COMMIT
18132018-11-06 21:28:03.765 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,22,NULL,1202590842880,NULL)
18142018-11-06 21:28:03.766 2 ROLLBACK
18152018-11-06 21:28:03.766 2 select i, v, t, b, c from t1 where i > ? (-1)
18162018-11-06 21:28:03.766 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (23,15,0,40)
18172018-11-06 21:28:03.766 1 COMMIT
18182018-11-06 21:28:03.766 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,23)
18192018-11-06 21:28:03.766 1 COMMIT
18202018-11-06 21:28:03.766 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,23,1202590842880,NULL)
18212018-11-06 21:28:03.767 2 ROLLBACK
18222018-11-06 21:28:03.767 2 select i, v, t, b, c from t1 where i > ? (-1)
18232018-11-06 21:28:03.768 1 INSERT INTO SYSTEM_LOBS.LOB_IDS VALUES(?, ?, ?, ?) (24,5,0,40)
18242018-11-06 21:28:03.768 1 COMMIT
18252018-11-06 21:28:03.768 1 CALL SYSTEM_LOBS.ALLOC_BLOCKS(?, ?, ?) (1,0,24)
18262018-11-06 21:28:03.768 1 COMMIT
18272018-11-06 21:28:03.768 2 select i, v, t, b, c from t1 where i > ? (NULL,NULL,NULL,NULL,24,1202590842880,NULL)
18282018-11-06 21:28:03.768 2 ROLLBACK
18292018-11-06 21:28:03.769 2 ROLLBACK
18302018-11-06 21:28:03.769 0 ROLLBACK
18312018-11-06 21:28:03.769 1 ROLLBACK
1832.Opened test script file: D:\DissProject\testrun\hsqldb\TestTriggers.txt
1833Processed 29 lines from D:\DissProject\testrun\hsqldb\TestTriggers.txt
1834.[Server@5d43661b]: [Thread[main,5,main]]: putPropertiesFromString(): [database.0=mem:test;dbname.0=;silent=true;trace=false]
1835[Server@5d43661b]: Initiating startup sequence...
1836[Server@5d43661b]: Server socket opened successfully in 0 ms.
1837[Server@5d43661b]: Database [index=0, id=81, db=mem:test, alias=] opened successfully in 22 ms.
1838[Server@5d43661b]: Startup sequence completed in 22 ms.
1839[Server@5d43661b]: 2018-11-06 21:28:04.628 HSQLDB server 2.3.6 is online on port 9001
1840[Server@5d43661b]: To close normally, connect and execute SHUTDOWN SQL
1841[Server@5d43661b]: From command line, use [Ctrl]+[C] to abort abruptly
1842.[Server@5d43661b]: Initiating shutdown sequence...
1843[Server@12299890]: [Thread[main,5,main]]: putPropertiesFromString(): [database.0=mem:test;dbname.0=;silent=true;trace=false]
1844[Server@5d43661b]: Shutdown sequence completed in 0 ms.
1845[Server@5d43661b]: 2018-11-06 21:28:04.917 SHUTDOWN : System.exit() was not called
1846[Server@12299890]: Initiating startup sequence...
1847[Server@12299890]: Server socket opened successfully in 0 ms.
1848[Server@12299890]: Database [index=0, id=81, db=mem:test, alias=] opened successfully in 0 ms.
1849[Server@12299890]: Startup sequence completed in 0 ms.
1850[Server@12299890]: 2018-11-06 21:28:04.918 HSQLDB server 2.3.6 is online on port 9001
1851[Server@12299890]: To close normally, connect and execute SHUTDOWN SQL
1852[Server@12299890]: From command line, use [Ctrl]+[C] to abort abruptly
1853.[Server@12299890]: Initiating shutdown sequence...
1854[Server@12299890]: Shutdown sequence completed in 0 ms.
1855[Server@12299890]: 2018-11-06 21:28:05.253 SHUTDOWN : System.exit() was not called
1856. -- #0 -----------------------
1857 -- executing directly
1858<<<
1859drop table public.ivtest if exists cascade
1860>>>
1861
1862 ***** st.execute gave me false
1863 -- #1 -----------------------
1864 -- executing directly
1865<<<
1866create cached table ivtest(interval1 INTERVAL YEAR TO MONTH, interval2 INTERVAL DAY TO SECOND(3))
1867>>>
1868
1869 ***** st.execute gave me false
1870 -- #2 -----------------------
1871 -- executing directly
1872<<<
1873drop table public.dttest if exists cascade
1874>>>
1875
1876 ***** st.execute gave me false
1877 -- #3 -----------------------
1878 -- executing directly
1879<<<
1880create cached table dttest(adate date not null, atime time not null,bg int, primary key(adate,atime))
1881>>>
1882
1883 ***** st.execute gave me false
1884 -- #4 -----------------------
1885 -- executing directly
1886<<<
1887insert into dttest values(current_date - 10 day, current_time + 1 hour, 1)
1888>>>
1889
1890 ***** st.execute gave me false
1891 -- #5 -----------------------
1892 -- executing directly
1893<<<
1894insert into dttest values(current_date - 8 day, current_time - 5 hour, 2)
1895>>>
1896
1897 ***** st.execute gave me false
1898 -- #6 -----------------------
1899 -- executing directly
1900<<<
1901insert into dttest values(current_date - 7 day, current_time - 4 hour, 3)
1902>>>
1903
1904 ***** st.execute gave me false
1905 -- #7 -----------------------
1906 -- executing directly
1907<<<
1908insert into dttest values(current_date, '12:44:31', 4)
1909>>>
1910
1911 ***** st.execute gave me false
1912 -- #8 -----------------------
1913 -- executing directly
1914<<<
1915insert into dttest values(current_date + 3 day, current_time - 12 hour, 5)
1916>>>
1917
1918 ***** st.execute gave me false
1919 -- #9 -----------------------
1920 -- executing directly
1921<<<
1922insert into dttest values(current_date + 1 day, current_time - 1 hour, 6)
1923>>>
1924
1925 ***** st.execute gave me false
1926 -- #10 -----------------------
1927 -- preparing
1928<<<
1929select atime adate from dttest where atime = ? and adate = ?
1930>>>
1931
1932 -- setting 2 Args [12:44:31; 2018-11-06]
1933 -- executing
1934 ***** ps.execute returned result row count 1 -- #11 -----------------------
1935 -- preparing
1936<<<
1937insert into ivtest values ?, ?
1938>>>
1939
1940 -- setting 2 Args [1-10; 10 02:15:30.333]
1941 -- executing
1942 ***** ps.executeUpdate gave me 1
1943 -- #12 -----------------------
1944 -- preparing
1945<<<
1946insert into ivtest values CAST (? AS INTERVAL YEAR TO MONTH), CAST (? AS INTERVAL DAY TO SECOND)
1947>>>
1948
1949 -- setting 2 Args [1-10; 10 02:15:30.333]
1950 -- executing
1951 ***** ps.executeUpdate gave me 1
1952 -- #13 -----------------------
1953 -- preparing
1954<<<
1955script
1956>>>
1957
1958 -- executing
1959 ***** ps.execute returned result row count 46 -- #14 -----------------------
1960 -- executing directly
1961<<<
1962drop table public.bintest if exists cascade
1963>>>
1964
1965 ***** st.execute gave me false
1966 -- #15 -----------------------
1967 -- executing directly
1968<<<
1969create cached table bintest(val BIGINT, id BINARY(100))
1970>>>
1971
1972 ***** st.execute gave me false
1973 -- #16 -----------------------
1974 -- preparing
1975<<<
1976insert into bintest values ?, ?
1977>>>
1978
1979 -- setting 2 Args [10; [B@62833051]
1980 -- executing
1981 ***** ps.executeUpdate gave me 1
1982 -- #17 -----------------------
1983 -- preparing
1984<<<
1985select val from bintest where id = ?
1986>>>
1987
1988 -- setting 1 Args [[B@a37aefe]
1989 -- executing
1990 ***** ps.execute returned result row count 1...... -- #0 -----------------------
1991 -- executing directly
1992<<<
1993drop table a if exists cascade
1994>>>
1995
1996 ***** st.execute gave me false
1997 -- #1 -----------------------
1998 -- executing directly
1999<<<
2000create cached table a (a int identity,b int)
2001>>>
2002
2003 ***** st.execute gave me false
2004 -- #2 -----------------------
2005 -- executing directly
2006<<<
2007create index bIdx on a(b)
2008>>>
2009
2010 ***** st.execute gave me false
2011 -- #3 -----------------------
2012 -- preparing
2013<<<
2014insert into a(b) values(1)
2015>>>
2016
2017 -- setting 0 Args []
2018 -- executing
2019 ***** ps.executeUpdate gave me 1
2020 -- #4 -----------------------
2021 -- preparing
2022<<<
2023insert into a(b) values(2)
2024>>>
2025
2026 -- setting 0 Args []
2027 -- executing
2028 ***** ps.executeUpdate gave me 1
2029 -- #5 -----------------------
2030 -- preparing
2031<<<
2032insert into a(b) values(3)
2033>>>
2034
2035 -- setting 0 Args []
2036 -- executing
2037 ***** ps.executeUpdate gave me 1
2038 -- #6 -----------------------
2039 -- preparing
2040<<<
2041insert into a(b) values(4)
2042>>>
2043
2044 -- setting 0 Args []
2045 -- executing
2046 ***** ps.executeUpdate gave me 1
2047 -- #7 -----------------------
2048 -- preparing
2049<<<
2050insert into a(b) values(5)
2051>>>
2052
2053 -- setting 0 Args []
2054 -- executing
2055 ***** ps.executeUpdate gave me 1
2056 -- #8 -----------------------
2057 -- preparing
2058<<<
2059insert into a(b) values(6)
2060>>>
2061
2062 -- setting 0 Args []
2063 -- executing
2064 ***** ps.executeUpdate gave me 1
2065 -- #9 -----------------------
2066 -- preparing
2067<<<
2068update a set b=100 where b>(select b from a X where X.a=2)
2069>>>
2070
2071 -- setting 0 Args []
2072 -- executing
2073 ***** ps.executeUpdate gave me 3
2074 -- #10 -----------------------
2075 -- preparing
2076<<<
2077update a set b=200 where b>(select b from a where a=?)
2078>>>
2079
2080 -- setting 1 Args [2]
2081 -- executing
2082 ***** ps.executeUpdate gave me 3
2083 -- #11 -----------------------
2084 -- preparing
2085<<<
2086update a set b=300 where b>(select b from a X where X.a=?)
2087>>>
2088
2089 -- setting 1 Args [2]
2090 -- executing
2091 ***** ps.executeUpdate gave me 3
2092..........
2093...............Max value for i: 2147483647
2094Max value for ID: 0
2095testDoubleNaN complete
2096..String Type Object 1
2097String Type Object 1
2098String Type Object 1
2099String Type Object 1
2100Time: 30.025
2101There was 1 failure:
21021) testVerifyAvailability(org.hsqldb.test.TestCollation)junit.framework.AssertionFailedError: the following locales are not installed:
2103 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
2104 (55 out of 95)
2105 at org.hsqldb.test.TestCollation.testVerifyAvailability(TestCollation.java:160)
2106 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2107 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2108 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2109 at org.hsqldb.test.AllTests.main(AllTests.java:82)
2110
2111FAILURES!!!
2112Tests run: 140, Failures: 1, Errors: 0
2113
2114
2115Process finished with exit code 0