Skip to content
#

h2

Star

Here are 492 public repositories matching this topic...

Language: All
Filter by language
All 492 Java 361 JavaScript 15 Kotlin 15 TypeScript 15 HTML 14 Scala 10 Shell 9 Python 7 CSS 6 C 4
Sort: Best match
Sort options
Best match Most stars Fewest stars Most forks Fewest forks Recently updated Least recently updated

scalikejdbc / scalikejdbc

Star 1.2k
Open

QueryDSL doesn't correctly union SELECT...ORDER BY/LIMIT statements for PostgreSQL

1
du-stripe
du-stripe commented Dec 7, 2021

When using UNION, with ORDER BY or LIMIT within a subexpression's SELECT statement, PostgreSQL requires the SELECT statement be enclosed in parentheses: https://stackoverflow.com/a/24024639 However, the following QueryDSL code causes a syntax error against Postgres because it doesn't generate those parentheses:

val i = Item.syntax("i")
selectFrom(Item.as(i)).orderBy(i.id).u
Read more
core interpolation good first issue
Find more good first issues

Improve this page

Add a description, image, and links to the h2 topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the h2 topic, visit your repo's landing page and select "manage topics."

Learn more