gxTfweLe

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