yXcn2V9e

1/Library/Java/JavaVirtualMachines/jdk-9.0.1.jdk/Contents/Home/bin/java "-javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=50947:/Applications/IntelliJ IDEA.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath "/Users/jacekzawodny/IdeaProjects/PO07/out/production/PO07:/Applications/IntelliJ IDEA.app/Contents/lib/junit-4.12.jar:/Applications/IntelliJ IDEA.app/Contents/lib/hamcrest-core-1.3.jar" Start
2
3--------------------------------------------------------
4Test dla: > KlasaZKluczem
5--------------------------------------------------------
6E> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEM(BASICKEY INTEGER NOT NULL PRIMARY KEY,STH INTEGER);
7R> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEM(BASICKEY INTEGER NOT NULL PRIMARY KEY,STH INTEGER);
8 ---- OK
9
10--------------------------------------------------------
11Test dla: > KlasaZKluczemAI
12--------------------------------------------------------
13E> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMAI(AUTOINCREMENKEY INTEGER PRIMARY KEY AUTOINCREMENT,STH INTEGER);
14R> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMAI(AUTOINCREMENKEY INTEGER PRIMARY KEY AUTOINCREMENT,STH INTEGER);
15 ---- OK
16
17--------------------------------------------------------
18Test dla: > KlasaZKluczemDoZignorowania
19--------------------------------------------------------
20E> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMDOZIGNOROWANIA(STH INTEGER);
21R> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMDOZIGNOROWANIA(STH INTEGER);
22 ---- OK
23
24--------------------------------------------------------
25Test dla: > KlasaZKluczemObcym
26--------------------------------------------------------
27E> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMOBCYM(BASICKEY INTEGER NOT NULL PRIMARY KEY,STH INTEGER,CONSTRAINT STH FOREIGN KEY(STH)REFERENCES S(IDX));
28R> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMOBCYM(BASICKEY INTEGER NOT NULL PRIMARY KEY,STH INTEGER);
29#### BLAD: Roznica: );
30A> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMOBCYM(BASICKEY INTEGER NOT NULL PRIMARY KEY,STH INTEGER,FOREIGN KEY(STH)REFERENCES S(IDX));
31#### BLAD: Roznica: );
32O> CREATE TABLE IF NOT EXISTS KlasaZKluczemObcym (basicKey INTEGER NOT NULL PRIMARY KEY, sth INTEGER );
33
34--------------------------------------------------------
35Test dla: > KlasaZKluczemObcymDoZignorowania
36--------------------------------------------------------
37E> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMOBCYMDOZIGNOROWANIA(BASICKEY INTEGER NOT NULL PRIMARY KEY);
38R> CREATE TABLE IF NOT EXISTS KLASAZKLUCZEMOBCYMDOZIGNOROWANIA(BASICKEY INTEGER NOT NULL PRIMARY KEY);
39 ---- OK
40
41--------------------------------------------------------
42Test dla: > KlasaZIndeksem
43--------------------------------------------------------
44E> CREATE TABLE IF NOT EXISTS KLASAZINDEKSEM(I1 INTEGER,I2 INTEGER,I3 INTEGER);CREATE INDEX I1I2 ON KLASAZINDEKSEM(I1,I2);CREATE UNIQUE INDEX I3 ON KLASAZINDEKSEM(I3);
45R> CREATE TABLE IF NOT EXISTS KLASAZINDEKSEM);
46#### BLAD: Roznica: );
47O> CREATE TABLE IF NOT EXISTS KlasaZIndeksem );
48
49--------------------------------------------------------
50Test dla: > KlasaDoInsertAutoincrement
51--------------------------------------------------------
52E> INSERT INTO KLASADOINSERTAUTOINCREMENT(VALUEI,VALUEF)VALUES(10,'20,0');
53R> INSERT INTO KLASADOINSERTAUTOINCREMENT(KLUCZYK,VALUEI,VALUEF)VALUES(0,10,20,0);
54#### BLAD: Roznica: KLUCZYK,VALUEI,VALUEF)VALUES(0,1
55O> INSERT INTO KlasaDoInsertAutoincrement ( kluczyk, valueI, valueF ) VALUES ( 0, 10, 20.0);
56
57--------------------------------------------------------
58Test dla: > KlasaDoZwyklegoInsert
59--------------------------------------------------------
60E> INSERT INTO KLASADOZWYKLEGOINSERT(KLUCZYK,VALUEI,VALUEF)VALUES(10,10,'20,0');
61R> INSERT INTO KLASADOZWYKLEGOINSERT(KLUCZYK,VALUEI,VALUEF)VALUES(10,10,20,0);
62#### BLAD: Roznica: 20,0);
63A> INSERT INTO KlasaDoZwyklegoInsert VALUES(10,10,'20.0');
64#### BLAD: Roznica: LASAOWYKLEGONSERT(KLUCZYK,VALUEI,VALUEF
65O> INSERT INTO KlasaDoZwyklegoInsert ( kluczyk, valueI, valueF ) VALUES ( 10, 10, 20.0);
66
67--------------------------------------------------------
68Test dla: > KlasaDoZwyklegoInsert2
69--------------------------------------------------------
70E> INSERT INTO KLASADOZWYKLEGOINSERT2(VALUEI,VALUEF)VALUES(10,'20,0');
71R> INSERT INTO KLASADOZWYKLEGOINSERT2(VALUEI,VALUEF)VALUES(10,20,0);
72#### BLAD: Roznica: 20,0);
73A> INSERT INTO KLASADOZWYKLEGOINSERT2 VALUES(10,'20,0');
74#### BLAD: Roznica: (I,VALUEF)VALU
75O> INSERT INTO KlasaDoZwyklegoInsert2 ( valueI, valueF ) VALUES ( 10, 20.0);
76
77--------------------------------------------------------
78Test dla: > KlasaDoUpdate
79--------------------------------------------------------
80E> UPDATE KLASADOUPDATE SET VALUEI=10,VALUEF='20,0' WHERE KLUCZYK=10;
81R> INSERT INTO KLASADOUPDATE(KLUCZYK,VALUEI,VALUEF)VALUES(10,10,20,0);
82#### BLAD: Roznica: INSERTINTO KLASADOUPDAE(KCZYK,VALUEI,VALUEF)VALUES(10,10,20,)
83O> INSERT INTO KlasaDoUpdate ( kluczyk, valueI, valueF ) VALUES ( 10, 10, 20.0);
84 ########## BLAD ##########
85
86Process finished with exit code 0