# Test inserting into tables using parameters
---
- Include: all-types-schema.yaml
---
- Statement: INSERT INTO all_types (varchar_field, integer_field) VALUES(?, ?)
- params: [['abc',1],['xyz',2]]
---
- Statement: SELECT varchar_field, integer_field from all_types
- output: [['abc',1],['xyz',2]]
...

# Test inserting into tables using parameters
---
- Include: all-types-schema.yaml
---
- Statement: INSERT INTO all_types (varchar_field, integer_field, smallint_field, boolean_field) VALUES(?,?,?,?)
- params: [['abc',1,1,true],['xyz',2,2,false]]
---
- Statement: SELECT varchar_field, integer_field, smallint_field, boolean_field from all_types
- output: [['abc',1,1,1],['xyz',2,2,0]]
...

Test more integer types: they don't work.
Test more integer types: they don't work.
