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...

Emulate FULL OUTER JOIN using LEFT/RIGHT OUTER JOINs and UNIONs

1

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

jbang group-id:artifact-id:version call syntax should offer selecting the main class in the referenced jar file

13

**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...

When calling setup multiple times in the same shell, multiple path entries are created

1

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...

Container lifecycle management as Maven and Gradle plugins

1

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...

Dead links in "Wikipedia Featured" dropdown

2

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...