ORA-01795: maximum number of expressions in a list is 1000
As I understand, there are several options to fix this issue
(e.g.
https://groups.google.com/forum/#!searchin/sqlalchemy/maximum$20number$20of$20expressions/sqlalchemy/Oa6YWNE0-IQ/6GVmy27B-FAJ
or split in_ to several or_)
Why not
On 6/17/14, 4:32 AM, Ofir Herzas wrote:
ORA-01795: maximum number of expressions in a list is 1000
As I understand, there are several options to fix this issue
(e.g.
https://groups.google.com/forum/#!searchin/sqlalchemy/maximum$20number$20of$20expressions/sqlalchemy/Oa6YWNE0-IQ/6GVmy27B-FAJ
This can be done only for Oracle and only if the number of expressions is
higher than 1000 (which would otherwise produce an exception)
Regarding complex queries, I guess the several or_'s fix should work:
or_(x.in_(1...1000), x.in_(1001...2000))
How can this be done locally? (override in_
On 6/17/14, 9:30 AM, Ofir Herzas wrote:
This can be done only for Oracle and only if the number of expressions
is higher than 1000 (which would otherwise produce an exception)
Regarding complex queries, I guess the several or_'s fix should work:
or_(x.in_(1...1000), x.in_(1001...2000))
How
On Monday, June 16, 2014 10:35:27 PM UTC-4, Michael Bayer wrote:
it's unlikely we can do much about that, jython is hardly used at all
and is not a well-maintained platform; it regularly has subtle
interpreter bugs and such. pg8000 is in better shape these days but
tracking down
Hi:
It seems that the fact describes a procedure to get a string to create
a table:
http://docs.sqlalchemy.org/en/latest/faq.html#how-can-i-get-the-create-table-drop-table-output-as-a-string
However, this does not work correctly when a table has a
server_default which is a function that takes
I may have spoken too soon. It seems that metadata.create_all() does not
handle this correctly either. I'm trying to see if this affects the latest
version of SQLAlchemy.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this