Test dataset with queries

[schoenja]

Motivation

Having a dataset together with queries that cover a good part of the functionality of Polypheny would make testing things like new adapters easier.

What would be needed

• Dataset consisting of multiple tables that have dependencies on each other.
• SQL(?) Code that inserts the dataset into Polypheny with an easy way of setting up the store locations for each table.
• Queries and the expected result to them.

Queries that seem useful

This list is incomplete; you can help by expanding it.:

• Basic SQL
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • INSERT
  • UPDATE
  • SELECT
  • Joins
• Store related
  • CREATE TABLE ON STORE x
  • ALTER TABLE ADD PLACEMENT
  • ALTER TABLE DROP PLACEMENT
  • Cross store joins
  • Inserts across stores