Timeline for Rewrite SQL query in CTE query
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2019 at 17:30 | comment | added | Peter Penzov | I updated MariaDB to version 10.3 and it works! Thanks! | |
| Feb 5, 2019 at 16:42 | comment | added | Peter Penzov |
Unfortunately I use 10.0.36-MariaDB-0ubuntu0.16.04.1 from official Ubuntu repository and I get You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'recursive cte as ( select t.* from payment_transactions t whe' at line 1
|
|
| Feb 5, 2019 at 15:58 | vote | accept | Peter Penzov | ||
| Feb 5, 2019 at 15:57 | comment | added | ypercubeᵀᴹ | Yes , exactly . | |
| Feb 5, 2019 at 15:37 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 656 characters in body
|
| Feb 5, 2019 at 15:16 | comment | added | Peter Penzov | Which one will be faster CTE of the first solution with Joins? | |
| Feb 5, 2019 at 15:15 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 254 characters in body
|
| Feb 5, 2019 at 15:15 | comment | added | Peter Penzov | Thanks, I have 2 additional questions: 1 Can I somehow use it in JPA? 2. Do you know what will be the performance impact for very large table? | |
| Feb 5, 2019 at 15:10 | history | answered | Randi Vertongen | CC BY-SA 4.0 |