Lukas Eder
Lukas Eder
Here's how: ``` SQL -- ROLLUP() with one argument SELECT AUTHOR_ID, COUNT(*) FROM T_BOOK GROUP BY ROLLUP(AUTHOR_ID) -- ROLLUP() with two arguments SELECT AUTHOR_ID, PUBLISHED_IN, COUNT(*) FROM T_BOOK GROUP BY...
We can emulate ```sql SELECT * FROM a FULL JOIN b ON p ``` as ```sql SELECT t.* FROM ( SELECT * FROM a LEFT JOIN b ON p UNION...
See also #595. See the section about pivot / unpivot clauses here: http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_10002.htm
**Describe the solution you'd like** I'd like to be able to run: ``` jbang org.jooq:jooq:3.15.4 --class org.jooq.ParserCLI [args...] ``` There are several classes containing a `main()` method, and none of...
I made a mistake when setting up jshell, not closing and re-opening the entire Windows Terminal window. I just closed tabs, instead: https://github.com/jbangdev/jbang/issues/939 This resulted in multiple identical path entries...
In jOOQ, one of the most re-occurring ideas is that jOOQ should tightly couple Testcontainers, Flyway/Liquibase and jOOQ's code generation. See e.g. https://github.com/jOOQ/jOOQ/issues/6551 This coupling is obviously a bad idea,...
Consider this example snippet ```java System.out.println( Flux.from(cf.create()) .flatMap(c -> Mono.from(c.createStatement("select ?p1, true").bind(0, true).execute())) .flatMap(it -> it.map((r, m) -> r.get(0) + ":" + r.get(1))) .blockFirst() ); ``` It prints: ``` java.nio.HeapByteBuffer[pos=0...
When browsing to http://aozora.github.io/bootmetro/demo/hub.html, there is a "Wikipedia Featured" dropdown with lots of dead links. It looks like the pages exist, but some path might have been renamed...
Thanks for doing this comparison. I've stumbled upon this query here: https://github.com/bwajtr/java-persistence-frameworks-comparison/blob/f6b33960c911e19790044f99cd44326ebe0e79c7/src/main/java/com/clevergang/dbtests/repository/impl/jooq/JooqDataRepositoryImpl.java#L227-L263 I'm sure there's an easier way to write this with jOOQ (or with all other solutions, as the...
## Bug Report #### Versions - Driver: 0.8.4.RELEASE - SPI: 0.9.0.M1 - Database: 1.4.200 - Java: openjdk version "11.0.9.1" 2020-11-04 - OS: Microsoft Windows [Version 10.0.19042.867] #### Current Behavior The...