Jooq fetchInto with default value if field is null

by

The reason is that JSON_ARRAYAGG() (like most aggregate functions) produces NULL for empty sets, instead of a more “reasonable” empty []. Clearly, you never want this behaviour. So, you could use COALESCE, instead, see also this question:

coalesce(
  jsonArrayAgg(jsonObject(book.ID, book.PRICE)),
  jsonArray()
)

I’ll make sure to update all the other answers I’ve given on Stack Overflow to point this out. A future jOOQ version might offer NULL safe aggregate functions in case there exists a reasonable identity for aggregation (e.g. []) to make this more discoverable: https://github.com/jOOQ/jOOQ/issues/11994

More Related Contents:

  1. Kotlin data class: how to read the value of property if I don’t know its name at compile time?
  2. How to make clickable listview in android using kotlin
  3. What is the difference between var and val in Kotlin?
  4. What is a “receiver” in Kotlin?
  5. Single exclamation mark in Kotlin
  6. Kotlin and Immutable Collections?
  7. Kotlin’s Iterable and Sequence look exactly same. Why are two types required?
  8. What does the suspend function mean in a Kotlin Coroutine?
  9. How to check if a “lateinit” variable has been initialized?
  10. How to run Kotlin class from the command line?
  11. Kotlin static methods and variables
  12. serializable in desired format in kotlin
  13. Example of when should we use run, let, apply, also and with on Kotlin
  14. How to convert String to Int in Kotlin?
  15. How can I suppress unchecked cast warnings?
  16. Why not use GlobalScope.launch?
  17. Why does this Kotlin method have enclosing backticks?
  18. kotlin data class + bean validation jsr 303
  19. How to make “inappropriate blocking method call” appropriate?
  20. Cross references in type parameters
  21. Swift ‘if let’ statement equivalent in Kotlin
  22. How do I initialize Kotlin’s MutableList to empty MutableList?
  23. warning: Kotlin runtime JAR files in the classpath should have the same version
  24. Difference between ArrayList() and mutableListOf() in Kotlin
  25. What’s the difference between !! and ? in Kotlin?
  26. How do I replace duplicate whitespaces in a String in Kotlin?
  27. Kotlin Foo::class.java “Unresolved Reference: Java” error
  28. kotlin program error: no main manifest attribute in jar file
  29. Configure Kotlin extension for Gradle subprojects
  30. Why do we use “companion object” as a kind of replacement for Java static fields in Kotlin?

Leave a Comment