Support PostgreSQL enum in DatabaseSetup

springtestdbunit / spring-test-dbunit

Integration between the Spring testing framework and DBUnit

http://springtestdbunit.github.com/spring-test-dbunit/

Apache License 2.0

476 stars 238 forks source link

Support PostgreSQL enum in DatabaseSetup #134

Open raderio opened 7 years ago

raderio commented 7 years ago

CREATE TYPE PRODUCT AS ENUM ('phone', 'laptop', 'mouse');

CREATE TABLE products (
    id BIGSERIAL NOT NULL PRIMARY KEY,
    title VARCHAR(20) NOT NULL,
    type PRODUCT NOT NULL
);

<dataset>
    <products id="1" title="Pixel" type="phone" />
</dataset>

Caused by: org.postgresql.util.PSQLException: ERROR: column "type" is of type product but expression is of type character varying Hint: You will need to rewrite or cast the expression.

alexandrezfs commented 7 years ago

rbsrcy commented 7 years ago

ChadBowman commented 7 years ago

dlopatin commented 6 years ago

raderio commented 6 years ago

https://stackoverflow.com/questions/37989786/dbunit-postgresqldatatypefactory-does-not-recognizes-enum-list

raderio commented 6 years ago

https://sourceforge.net/p/dbunit/feature-requests/204/

Rodac commented 5 years ago