nullsqltext.out

derby database source code.good for you.

Test nullSQLText starting
Test prepareStatement with null argument
FAIL -- expected exception
Null SQL String Exception
Test execute with null argument
FAIL -- expected exception
Null SQL String Exception
Test executeQuery with null argument
FAIL -- expected exception
Null SQL String Exception
Test executeUpdate with null argument
FAIL -- expected exception
Null SQL String Exception
Starting test for DERBY-522.
[ Test Statement ]:
 --
[ EXPECTED ERROR ]: ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 2.
[ Test Statement ]:
 -- 
[ EXPECTED ERROR ]: ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 2.
[ Test Statement ]:
 -- This is a comment 
 --
[ EXPECTED ERROR ]: ERROR 42X01: Syntax error: Encountered "<EOF>" at line 2, column 3.
[ Test Statement ]:
 -- This is a comment
 --And another
 -- Andonemore
[ EXPECTED ERROR ]: ERROR 42X01: Syntax error: Encountered "<EOF>" at line 3, column 14.
[ Test Statement ]:
 --
values 2, 4, 8
[ Results ]:  2 4 8
[ Test Statement ]:
 -- This is 
 -- 
 --3 comments
values 8
[ Results ]:  8
[ Test Statement ]:
 -- This is a comment
 --And another
 -- Andonemore
values (2,3)
[ Results ]:  2
[ Test Statement ]:
 -- This is a comment
 select i from t1
[ Results ]:  1 2 3 4 5 6 7
[ Test Statement ]:
 --singleword
 insert into t1 values (8)
[ Results ]: (NO RESULT SET)
[ Test Statement ]:
 --singleword
call za()
[ Results ]: (NO RESULT SET)
[ Test Statement ]:
 -- leading comment
(
values 4, 8)
[ Results ]:  4 8
[ Test Statement ]:
 -- leading comment
(
values 4, 8)
[ Results ]:  4 8
[ Test Statement ]:
select i from t1 -- This is a comment
[ Results ]:  1 2 3 4 5 6 7 8
[ Test Statement ]:
select i from t1
 -- This is a comment
[ Results ]:  1 2 3 4 5 6 7 8
[ Test Statement ]:
values 8, 4, 2
 --
[ Results ]:  8 4 2
[ Test Statement ]:
values 8, 4,
 -- middle comment
2
 -- end
[ Results ]:  8 4 2
[ Test Statement ]:
values 8, 4,
 -- middle comment
2
 -- end
[ Results ]:  8 4 2
DERBY-522 test completed.
Test nullSQLText finished