Implement a testkit

[povder]

Common for all statements

Errors

• non-existent table
• non-existent column
• missing param value
• superfluous param
• syntactically incorrect
• timeout
• positional params ^
• can't mix positional with named params
• TODO don't forget to test all the cases above for executing batch

Selects - everything inside a tx and without an explicit tx

Streaming

• Select empty table
• Read fully at once
• Read fully by chunks
• Read some & cancel
• Cancel right away
• warnings
• rows affected count
• metadata

Result set

• Select empty table
• Select non-empty table
• warnings
• rows affected count
• metadata

For first row

• Empty table
• Single row
• Many rows

For value

• Empty table
• Single row
• Many rows
• Incorrect type
• null value

For value opt

• Empty table
• Single row
• Many rows
• Incorrect type
• null value

Streaming arguments

• TODO
• Don't forget about arg conversion errors and execution errors in the middle of streaming
• Test what happens when publisher fails: connection should roll back

Row

• opt/non opt

Data types

outbound

• ...

inbound

• ...

Param tests

Do select with different parameters and see if results show that parameters got applied

• no parameters
• one parameter
• many parameters
• the same parameter multiple times
• parameter at the end of sql

TX tests

...

Cross tests with JDBC

...