[Dbix-class] Announcing 0.08099_07 (0.08100_RC1)

[Rob Kinyon]

On Sat, Feb 28, 2009 at 04:39, Ash Berlin <ash_cpan at firemirror.com> wrote:
> What's your definition of schema here? What mysql calls a database, and Pg
> calls a schema?

Yes, that's exactly what a schema is. It's also what Oracle, Sybase,
SQL*Server, and DB2 call a schema. :-) What MySQL calls it is ...
well, it's irrelevant. :-)

> If so at work we use ->table("schema.foo") just fine with 0.0801x on Pg.

Except, as groditi said, that breaks with quoting turned on. I very
strongly believe that quoting should be turned on by default, so every
feature DBIC has should, when used properly, work properly with
quoting turned on.

> We already do, dont we: "SELECT me.id ....";

In the SELECT clause we do, but not in the other clauses. So, you end up with:
SELECT me.id, ... FROM some_table me WHERE id = 5;

That really should be "WHERE me.id = 5" to help with disambiguation.

Rob