Gavin Ray comments

Results 181 comments of


                                            Gavin Ray

Scala import cannot be resolved in Java project

https://marketplace.visualstudio.com/items?itemName=scalameta.metals https://scalameta.org/metals/docs/editors/vscode/

Emulate SNOWFLAKE correlated subqueries by using LATERAL

Commenting here so it doesn't get lost on Twitter From experience implementing/emulating correlated subqueries in Snowflake, there are limitations with its `LATERAL` support that made it unusable for us and...

Support MULTISET and MULTISET_AGG in Snowflake using SQL/JSON functions

Currently in early days of Snowflake integration, trying to put a good/maintainable approach together 👍 > the most important operator is JSON_ARRAYAGG(), which Snowflake doesn't have, I think? I think...

The API for DSL.case_() makes dynamically generated statements cumbersome

Fair enough

DSL.execute() for dynamic procedural code uses invalid DSL.name() quoting for MySQL, causing errors

> You can work around this limitation by attaching a Configuration to your Query, i.e. replace DSL.insertInto(...) by ctx.insertInto(...) if you have a DSLContext available. You can also just construct...

Emulating `INSERT ... RETURNING` in MySQL for multiple rows, in the absence of AUTO_INCREMENT and/or primary key

Some notes from discussions: ``` Relevant links: https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html From what I can tell using MAX to determine next auto id may not work. IDs can get skipped. Also assuming that...

Emulating `INSERT ... RETURNING` in MySQL for multiple rows, in the absence of AUTO_INCREMENT and/or primary key

Okay, so the below seems to work for both tables with and without an auto-increment primary key. The one hangup I can see with this is tables that have randomly...

Emulating `INSERT ... RETURNING` in MySQL for multiple rows, in the absence of AUTO_INCREMENT and/or primary key

The below seems to roughly do it, FWIW, for tables without auto-inc PK's: ```kt fun createTempTableLike(tempTable: org.jooq.Name, table: org.jooq.Name): CustomStatement { return CustomStatement.of { ctx -> ctx.visit(DSL.field("CREATE TEMPORARY TABLE {0}...

Emulating `INSERT ... RETURNING` in MySQL for multiple rows, in the absence of AUTO_INCREMENT and/or primary key

Thanks so much for the comprehensive feedback Lukas 🙏 To address the one first comment: - There's an identity / auto_increment column in the actual table We have the misfortune...

Emulating `INSERT ... RETURNING` in MySQL for multiple rows, in the absence of AUTO_INCREMENT and/or primary key

Also I can't seem to cast between `Procedure` and `ResultQuery`, when appending the SELECT to the end :thinking: ```java java.lang.ClassCastException: class org.jooq.impl.BlockImpl cannot be cast to class org.jooq.ResultQuery (org.jooq.impl.BlockImpl and...