Do not use alias in returning expression
SQLite does not support alias in RETURNING
expression: https://www.sqlite.org/forum/forumpost/368b626208
And any way the expression can only use the columns of the table.
This would solve tryton#12288 (closed)
- Show closed items
Activity
-
Newest first Oldest first
-
Show all activity Show comments only Show history only
- Cédric Krier added type::behavior label
added type::behavior label
- Cédric Krier assigned to @ced
assigned to @ced
- Cédric Krier mentioned in commit 3af6e0288aed
mentioned in commit 3af6e0288aed
- Cédric Krier mentioned in merge request !10 (merged)
mentioned in merge request !10 (merged)
- Cédric Krier closed with merge request !10 (merged)
closed with merge request !10 (merged)
- Cédric Krier closed with commit 3af6e0288aed
closed with commit 3af6e0288aed
- Author Owner
As https://discuss.tryton.org/t/upgrade-to-python-sql-1-4-1-breaks-tryton-worker-in-trytond-5-0-38/6275 shows, this change break some statements. I think we should revert the changeset and not try to make returning working with SQLite because the implementation of this PostgreSQL extension is not complete: https://www.sqlite.org/lang_returning.html#limitations_and_caveats Otherwise it would mean to either limit the usage to only the common part implemented between both databases. But the problem with such choice is that this common part may evolve over time.
1 - Cédric Krier reopened
reopened
- Cédric Krier mentioned in issue tryton#12288 (closed)
mentioned in issue tryton#12288 (closed)
- Cédric Krier mentioned in commit 7fe217411735
mentioned in commit 7fe217411735
- Cédric Krier mentioned in merge request !11 (merged)
mentioned in merge request !11 (merged)
- Cédric Krier mentioned in commit 6de2fdac02a6
mentioned in commit 6de2fdac02a6
- Cédric Krier marked tryton#12334 (closed) as a duplicate of this issue
marked tryton#12334 (closed) as a duplicate of this issue
- Cédric Krier marked this issue as related to tryton#12334 (closed)
marked this issue as related to tryton#12334 (closed)
- Cédric Krier closed with commit 6de2fdac02a6
closed with commit 6de2fdac02a6
- Cédric Krier closed with merge request !11 (merged)
closed with merge request !11 (merged)
- Cédric Krier marked #87 (closed) as a duplicate of this issue
marked #87 (closed) as a duplicate of this issue
- Cédric Krier marked this issue as related to #87 (closed)
marked this issue as related to #87 (closed)