Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql.true() does not work for IBM DB2 #157

Closed
GoogleCodeExporter opened this issue Mar 16, 2015 · 3 comments
Closed

sql.true() does not work for IBM DB2 #157

GoogleCodeExporter opened this issue Mar 16, 2015 · 3 comments
Labels
auto-migrated

Comments

@GoogleCodeExporter
Copy link 

Details are here:

https://bitbucket.org/zzzeek/sqlalchemy/issue/3120/sqltrue-does-not-work-for-ibm
-db2

What version of the product are you using? On what operating system?

ibm-db-sa at this commit: a945be56a4ff07f14b944bd654babbde79539a17

Original issue reported on code.google.com by mattrie...@gmail.com on 10 Jul 2014 at 12:09
@GoogleCodeExporter
Copy link
Author 

We're running against sqlalchemy 0.7.9 and RHEL 6.5.

Original comment by mattrie...@gmail.com on 10 Jul 2014 at 12:43

@GoogleCodeExporter
Copy link
Author 

Hitting this on sqla 0.8.4 too.  I discussed this with Mike Bayer in openstack 
IRC and it sounds like any sa backend that doesn't support native boolean will 
fail on a construct like this if using sqla < 0.9.

So my solution is to just patch the DB2Compiler class to override 
visit_true/visit_false.  The patch is attached.

The patch is based on commit a945be56a4ff07f14b944bd654babbde79539a17.

Original comment by mattrie...@gmail.com on 11 Jul 2014 at 7:18

Attachments:

@GoogleCodeExporter
Copy link
Author

Original comment by rahul.pr...@in.ibm.com on 15 Jul 2014 at 12:16

  • Changed state: Duplicate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
auto-migrated
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kadler @GoogleCodeExporter