message: Missing appender tests
diff: @@ -267,3 +267,31 @@ TEST_CASE("Test appender with string lengths", "[appender]") {
  result = con.Query("SELECT * FROM my_table");
  REQUIRE(CHECK_COLUMN(result, 0, {"asd"}));
  }
  +
  +TEST_CASE("Test various appender types", "[appender]") {
  + unique_ptr<QueryResult> result;
  + DuckDB db(nullptr);
  + Connection con(db);
  +
  + REQUIRE_NO_FAIL(con.Query("CREATE TABLE type_table(a BOOL, b UINT8, c UINT16, d UINT32, e UINT64, f FLOAT)"));
  + {
  + Appender appender(con, "type_table");
  + appender.AppendRow(true, 1, 2, 3, 4, 5);
  + }
  + result = con.Query("SELECT * FROM type_table");
  + REQUIRE(CHECK_COLUMN(result, 0, {true}));
  + REQUIRE(CHECK_COLUMN(result, 1, {1}));
  + REQUIRE(CHECK_COLUMN(result, 2, {2}));
  + REQUIRE(CHECK_COLUMN(result, 3, {3}));
  + REQUIRE(CHECK_COLUMN(result, 4, {4}));
  + REQUIRE(CHECK_COLUMN(result, 5, {5}));
  + // too many rows
  + {
  + Appender appender(con, "type_table");
  + REQUIRE_THROWS(appender.AppendRow(true, 1, 2, 3, 4, 5, nullptr));
  + }
  + {
  + Appender appender(con, "type_table");
  + REQUIRE_THROWS(appender.AppendRow(true, 1, 2, 3, 4, 5, 1));
  + }
  +}
  