I'm a developer on a large, old project that has a lot of old, poorly structured SQL where table aliases are specified but not consistently used (ex. "SELECT MY_TABLE.COLUMN1 FROM MY_TABLE MT WHERE MT.COLUMN2='value';"). This works fine in Production because we're using Firebird with RelaxedAliasChecking enabled ( https://firebirdsql.org/rlsnotesh/rnfb210-fbconf-relax.html).
For our unit tests, however, we are using an H2 Database instead (because it's a whole lot faster to spin up new H2 databases than Firebird databases). Since H2 (correctly) requires proper alias usage, this means we need to either... 1. Not have unit test coverage for a large portion of our codebase 2. Spend a lot of time fixing our old SQL that works perfectly fine outside of unit tests 3. Drastically slow down unit tests by using Firebird instead of H2 for tests #2 is definitely our long-term goal, but not going to happen any time soon. Any chance H2 could gain support for a RelaxedAliasChecking (or is there one already that I'm overlooking, or any thoughts on an alternative)? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/fe1f189e-fb6d-4811-8903-bacdc37c514d%40googlegroups.com.
