#23061: Oracle SQL compiler adding outer pagination selects causing ORA-00907: missing right parenthesis when used with select_for_update. -------------------------------------+------------------------------------- Reporter: michael.miller@… | Owner: shai Type: Bug | Status: assigned Component: Database layer | Version: 1.7-rc-1 (models, ORM) | Resolution: Severity: Release blocker | Triage Stage: Accepted Keywords: oracle sql compiler | Needs documentation: 0 ORA-00907 | Patch needs improvement: 0 Has patch: 0 | UI/UX: 0 Needs tests: 0 | Easy pickings: 0 | -------------------------------------+-------------------------------------
Comment (by ramiro): Replying to [comment:4 michael.miller@…]: > I have tried this with Django 1.7rc2 and the problem still exists. I can confirm that with Django 1.6.5 the problem does not happen. > > Thank you for accepting this, hopefully you can get to it before the release of Django 1.7. This bug is a blocker for us as we use select_for_update with a get as part of our concurrency control system. Thanks for your report. The hardware requirements, licensing woes, changing versions, and the general difficulty in setting it up make a working Oracle development environment a scarce resource. Considering that from what you express this ticket has such a high impact for you I'd like to ask you to test the following and report back with the results: 1. Please verify if 1.6 is affected by the issue. 2. If it isn't then please apply bisection method using git between the good version (the 1.6 git tag) and the closest bad one (e.g. the 1.7rc1 git tag). This should give you the ID of the commit where the regression got introduced. This information could greatly enhance the possibility of a solution being found before 1.7 gets released. Thanks again. -- Ticket URL: <https://code.djangoproject.com/ticket/23061#comment:6> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To post to this group, send email to django-updates@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/084.91a2ce10703e05ca1db721956cde1399%40djangoproject.com. For more options, visit https://groups.google.com/d/optout.