Hi
We are trying to use 'WITH' clause to deal with situation of 'recursive' search
according to below guide in db2
http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.a
psg/src/tpc/db2z_xmprecursivecte.dita
Different to other SQL (mysql, postgre), IBM DB2 does not support to have a key
word 'RECURSIVE' after 'WITH'. However, current version of sqlalchemy generate
this key word 'RECURSIVE', so in sqlalchemy we can notice DB2 throws error
message like 'An unexpected token "included_parts" was found following "WITH
RECURSIVE ". Expected tokens may include: "<space>".'
This issue affected Oracle as well but SQLAlchemy owner fixed it in
https://bitbucket.org/zzzeek/sqlalchemy/issue/3220.
SQLAlchemy owner recommend me to contact you to fix this. Could you help?
Thanks in advance
What is the expected output? What do you see instead?
The sql state generated by sqlalchemy cte method does not have key word
'RECURSIVE'
http://docs.sqlalchemy.org/en/rel_0_9/orm/query.html#sqlalchemy.orm.query.Query.
cte
What version of the product are you using? On what operating system?
0.3.0
Please provide any additional information below.
Original issue reported on code.google.com by godsarm...@gmail.com on 20 Mar 2015 at 3:01
Original issue reported on code.google.com by
godsarm...@gmail.com
on 20 Mar 2015 at 3:01