[Koha-devel] Ambiguous column names

Galen Charlton gmc at esilibrary.com
Wed Nov 12 19:39:22 CET 2014


Hi,

On Wed, Nov 12, 2014 at 10:35 AM, Chris Cormack
<chris at bigballofwax.co.nz> wrote:
> I think we don't need to make columns unique across the whole db just when
> selecting do select borrowers.timestamp as something.
> DBIx::Class helps us with this also

I agree with Chris.  In legacy code, doing a "select *" from a join on
multiple tables is should be discouraged, so using the addition of a
new column to locate cases of these to stamp out is preferable.  The
alternative of using a distinct column name has the problem of making
the writing of more general templates and classes more difficult.

Regards,

Galen
-- 
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org


More information about the Koha-devel mailing list