Re: [RDBO] missing column aliases in recent version(s)

2007-06-30 Thread Michael Lackhoff
On 30 Jun 2007 at 17:10, John Siracusa wrote: > Tables are only aliased as tN when more than one table is involved in > the query. This "more than one" count does not include literal > subqueries like yours, however. I'm thinking of changing it in 0.765 > so that the tN aliases are always used,

Re: [RDBO] How to get transactions right

2007-06-30 Thread Darren Duncan
A few answers in this thread, replying to no one in particular ... 1. Nested transactions are very useful and should be supported at whatever levels possible. 2. SQLite does not currently support nested transactions, but support for this is on the cards for a near future version, following t

Re: [RDBO] missing column aliases in recent version(s)

2007-06-30 Thread John Siracusa
On 6/30/07, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > The subselect I use, relies on the aliasing of 'gruppen' to 't1'. Of > course I can just change the definition to use the original table > name but since I didn't find any mention in the change log, perhaps > this is a bug? Tables are only

[RDBO] missing column aliases in recent version(s)

2007-06-30 Thread Michael Lackhoff
Hello, I just stumbled upon a changed behaviour that causes my app to crash with RDBO 0.764 (works with 0.758). The problem occurs in a method that should give me all the groups a user (therapeut in my case) is not in: sub notingroups { my $self = shift; my $nr = $self->nr; # user id

Re: [RDBO] Two RDBO hierarchies interfering (with test)

2007-06-30 Thread Adrian Howard
You are a star :-) On 29 Jun 2007, at 22:02, John Siracusa wrote: > On 6/26/07, Adrian Howard <[EMAIL PROTECTED]> wrote: >> On 25 Jun 2007, at 16:33, John Siracusa wrote: >>> I'd like to see a small, self-contained, >>> reproducible test case. If you could post one and describe how >>> you'd >