Re: [sqlalchemy] Re: CTE and @hybrid_property.expression

2018-06-13 Thread HP3
Hmmm - makes sense. I'll switch to plain @property instead. Thank you very much again Mike! On Tuesday, June 12, 2018 at 3:32:35 PM UTC-5, Mike Bayer wrote: > > On Tue, Jun 12, 2018 at 12:20 PM, HP3 > > wrote: > > Hmmm > > > > In my testing, the class level functionality doesn't seem to be

[sqlalchemy] newbie question: best way to factor and group data when only some columns change

2018-06-13 Thread Robert Henry
I have a tester that controls 30 independent variables. Each variable can have about 40 different values. Periodically, I run a test. I choose 2 of the 30 independent variables, and over the next few minutes, fully iterate those 2 variables relative to each other, visiting each point in a

Re: [sqlalchemy] Any way to suppress CASTs during Concrete Inheritance unions on Oracle ?

2018-06-13 Thread Mike Bayer
On Wed, Jun 13, 2018 at 10:15 PM, Peter Lai wrote: > > > On Wednesday, June 13, 2018 at 8:28:32 PM UTC-4, Mike Bayer wrote: >> >> On Wed, Jun 13, 2018 at 7:44 PM, Peter Lai wrote: >> > I've implemented a Concrete inheritance model and Oracle 11g is balking >> > on >> > `CAST(NULL AS CLOB) as

[sqlalchemy] Any way to suppress CASTs during Concrete Inheritance unions on Oracle ?

2018-06-13 Thread Peter Lai
I've implemented a Concrete inheritance model and Oracle 11g is balking on `CAST(NULL AS CLOB) as fieldn` during the pjoin union query execution with: ORA-00932: inconsistent datatypes: expected - got CLOB This happens when the unioned tables representing the 2 subclasses have different `Text`

Re: [sqlalchemy] Any way to suppress CASTs during Concrete Inheritance unions on Oracle ?

2018-06-13 Thread Mike Bayer
On Wed, Jun 13, 2018 at 7:44 PM, Peter Lai wrote: > I've implemented a Concrete inheritance model and Oracle 11g is balking on > `CAST(NULL AS CLOB) as fieldn` during the pjoin union query execution with: > > ORA-00932: inconsistent datatypes: expected - got CLOB > > This happens when the unioned

Re: [sqlalchemy] Any way to suppress CASTs during Concrete Inheritance unions on Oracle ?

2018-06-13 Thread Peter Lai
On Wednesday, June 13, 2018 at 8:28:32 PM UTC-4, Mike Bayer wrote: > > On Wed, Jun 13, 2018 at 7:44 PM, Peter Lai > wrote: > > I've implemented a Concrete inheritance model and Oracle 11g is balking > on > > `CAST(NULL AS CLOB) as fieldn` during the pjoin union query execution > with: > >