Thanks for your answers, it now builds, runs and passes all our integrations tests!
I tried to reproduce the misleading "Unused forcedType" INFO log by creating few tables with different kind of columns, but failed, look like it's not that easy.. There isn't any redundant forcedType configuration in our work project either, but a complex and old database on which we used liquibase to generate a legacy changelog.xml years ago to start using liquibase. If you think of any hints, I could give it another try. About H2, thank you for noticing, I didn't check the issue today. For H2 future upgrade, the dependency is managed by Spring Boot, I hope it won't break our build some day. Anyway I am pretty happy that it works! It should avoid us some issues we had because we used the same database for our development environment and our production builds. Mostly when we forgot to rollback the database schema used and there has been some new columns in development which shouldn't go to production. Thank you again Lukas! Le mardi 15 septembre 2020 à 16:21:42 UTC+2, [email protected] a écrit : > On Tuesday, September 15, 2020 at 1:08:27 PM UTC+2 Lukas Eder wrote: > >> >> >>> I was actually creating a starting project with Spring Boot/Liquibase to >>> test a column creation. But I am not familiar at all with H2. Without your >>> answer I would have based my thinking it was a number because in the left >>> panel of the console it appears as a NUMBER(1, 0). >>> >>> [image: Capture d’écran 2020-09-14 à 16.50.13.png] >>> >> >> I've been discussing the various INFORMATION_SCHEMA tables with the H2 >> maintainers for quite a while. There is a lot of legacy in them. I'm not >> sure what the rationale for each one of these things is, and why they're >> being kept the way they are. What you're seeing in the menu seems to be the >> COLUMN_TYPE column, which doesn't contain valid data types, but some >> formatted version of the data type. >> > > Here's some interesting insight into what's going to change between H2 > 1.4.200 and H2 2.0: > https://github.com/jOOQ/jOOQ/issues/10231#issuecomment-692736218 > >> -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/fb9b4612-f4ce-42d2-be79-462328293f58n%40googlegroups.com.
