Standalone GORM + H2 in memory is not creating tables

I created a sample minimalist project here.
https://github.com/aibolit/StandaloneGORM-Groovy3/tree/groovy2

To Run: `./gradlew run`

There is one domain class and some minimal setup for an H2 in-memory database.

I am seeing
```
[main] INFO org.hibernate.Version - HHH000412: Hibernate Core {5.4.10.Final}
[main] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.0.18.Final
[main] INFO org.hibernate.validator.internal.engine.ConfigurationImpl - HV000002: Ignoring XML configuration.
[main] INFO org.hibernate.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
[main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

Hibernate: drop table person if exists
Hibernate: create table person (id bigint generated by default as identity, version bigint not null, first_name varchar(255) not null, last_name varchar(255) not null, primary key (id))

[main] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 42102, SQLState: 42S02
[main] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Table "PERSON" not found; SQL statement:
```

This is weird because I can clearly see the `create table` statement run without error. My guess is that this is somehow running on the wrong schema (If I run SQL to manually using `new Sql(datastore.dataSource)` to create the table, it still doesn't work with the GORM entities but does work with more manual SQL create/select).

> Note - This same code works with the [comdb2](https://github.com/bloomberg/comdb2) database. I am trying to create a minimal in memory example.

Start with the linked StandaloneGORM-Groovy3 sample and run ./gradlew run to reproduce the H2 in-memory failure. Inspect the minimal domain class, GORM setup, and generated SQL around the table-creation and subsequent entity query; done means the GORM entities can use the created person table without a table-not-found error.

Written by the indexing model from the issue text.