in a new project I encountered a strange problem when trying to use Arquillian and the Persistence extension to test some things. When the embedded DBUnit tries to compare the database with a the dataset provided by ShouldMatchDataset DBUnit tries to use non existing columns in the query. The table specification is
create table USERS (
USER_ID int8 not null,
UUID varchar(38) not null,
primary key (USER_ID)
DBUnit tries to use this query when comparing the table with the dataset:
select NAME, ADMIN, REMARKS, ID, USER_ID, EMAIL, ENABLED, PASSWORD, ROLE_OF_USER, UUID, CUSTOMER_ID from USERS order by USER_ID
As you can see there are several non existing columns in this query. Does have an idea where DBUnit gets these columns from?