prepStmt Test Starts
executeUpdate() without parameters
Update count is: 0
executeUpdate() with parameters
Update count is: 1
execute() with parameters, no result set returned
Update count is: 2
executQuery() without parameters
got row:  99 5 9
got row:  2 6 10
got row:  7 5 8
end of rows
executQuery() with parameters
got row:  99 5 9
got row:  7 5 8
end of rows
execute() with parameters with result set returned
got row:  99 5 9
got row:  7 5 8
end of rows
test different data types for input parameters of a Prepared Statement
Update count is: 0
Update count is: 1
test setObject on different data types for input  parameters of a Prepared Statement
Update count is: 1
test setNull on different data types for input  parameters of a Prepared Statement
Update count is: 1
got row:  1 2 3 4.0 5.0 6.0 77.77 8.100 column9string        column10vcstring column11lvcstring 0123456789abcdef10111213202020 0123456789abcdef10111213 0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0
Timestamp match!
got row:  1 2 3 4.0 5.0 6.0 77.77 8.100 column11string       column10vcstring column11lvcstring 0123456789abcdef10111213202020 0123456789abcdef10111213 0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0
Timestamp match!
got row:  0 0 0 0.0 0.0 0.0 null null null null null null null null null null xxxxxxFILTERED-TIMESTAMPxxxxx
After first Timestamp!
end of rows
SQLState: 07000 message: At least one parameter to the current statement is uninitialized.
SQLState: 07000 message: At least one parameter to the current statement is uninitialized.
insertTab ( bigtab,50)
insertTab ( bigtab,200)
insertTab ( bigtab,300)
insertTab ( bigtab,500)
insertTab ( bigtab,1000)
select * from bigtab
Col # 500 = null  Col 1000 = null
Col # 500 = null  Col 1000 = null
Col # 500 = null  Col 1000 = null
Col # 500 = 500  Col 1000 = null
Col # 500 = 500  Col 1000 = 1000
Insert wrong column name
insertTab ( bigtab,1001)
SQLState: 42X14 message: 'C1001' is not a column in table or VTI 'APP.BIGTAB'.
Expected Syntax error 
insertTab ( bigtab,0)
SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 29.
Expected Table does not exist 
insertTab ( wrongtab,1000)
SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
CREATE TABLE doubletab (i int, doubleVal DOUBLE)
testBigDecimalToDoubleConversion().
 Check that values are preserved when BigDecimal 
 values which have more than 31 digits are converted 
 to Double with setObject
PASS: Actual value 1.0E-130 matches expected value: 1.0E-130
PASS: Actual value 1.0E125 matches expected value: 1.0E125
PASS: Actual value -1.0E124 matches expected value: -1.0E124
PASS: Actual value 1.2345678901234567E31 matches expected value: 1.2345678901234567E31
PASS: Actual value 1.2345678901234567 matches expected value: 1.2345678901234567
testBigDecimalSetObjectWithScale(). 
Pass scale parameter of setObject
PASS: Actual value 2.330000 matches expected value: 2.33
Minimum BigDecimal Value: 0.000000000000001
Prepared Statement String: update Numeric_Tab set NULL_VAL=?
Select NULL_VAL from Numeric_Tab
Returned BigDecimal Value after Updation: 0.000000000000001
Value returned from stmt: 0.000000000000001
setObject Method sets the designated parameter with the Object
Negative test setString with Invalid Timestamp:20
SQLState: 22007 message: The syntax of the string representation of a datetime value is incorrect.
Test jira614 completed successfully -- no Distributed Protocol Exception occurred
Jira170: caught expected table not found
Iteration 1 successful: 555 parameter markers successfully prepared and executed.
Test jira125 successful: 557 parameter markers successfully prepared and executed.
JIRA-1454 repro with c2 len=12748
Fetched a row, c2.length=12748
JIRA-1454 repro with c2 len=12750
Fetched a row, c2.length=12750
JIRA-1454 repro with c2 len=12749
Fetched a row, c2.length=12749
JIRA Test 1533(a) successful (no exception)
JIRA Test 1533(b) successful (no exception)
prepStmt Test Ends