test-DBItest-Derby.R

jdbc_register_driver(
  'org.apache.derby.jdbc.EmbeddedDriver',
  resolve(
    module('org.apache.derby:derby:10.12.1.1'),
    repositories = list(maven_local, maven_central)
  )
)

DBItest::make_context(
  dbj::driver(),
  list(url = "jdbc:derby:memory:dbi-test;create=true", user = 'sa'),
  tweaks = DBItest::tweaks(constructor_name = "driver"),
  name = "Derby"
)

DBItest::test_all(skip = c(
  # Driver independent
  dbj_skips_global,

  # Derby specific

  "temporary_table", # TODO: temporary tables must be accessed in the SESSSION schema (http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html)

  # Not an error: Syntax not supported (WHERE clause is mandatory in SELECT expressions) 
  "quote_string",
  "trivial_query",
  "clear_result_return",
  "command_query",
  "fetch_.*",
  "get_query_.*",
  "data_.*",
  "quote_identifier.*",
  "is_valid_result",
  "get_statement",
  "row_count",
  "get_info_result",

  # Not an error: DBItest does not quote identifiers in select expressions. https://github.com/rstats-db/DBItest/issues/64
  "write_table",
  "read_table",
  "table_visible_in_other_connection",
  "roundtrip_numeric_special",
  "rows_affected",

  NULL
))

test_bdj_extras(skip = c()
)