[Koha-devel] MySQL 5.0 problem

[Simon Mitchell]

I just did a quick install of mysql 5 to have a play with this one.
Without changing/adding quotes you can just add the table name to the column
name to create the a table with return .

In your case when creating the issues table just change

    return char(4) default NULL
to
   issues.return char(4) default NULL


The select will fail if use
    select return from issues;
but
    select * from issues;
and
    select issues.return from issues;
work.

If you are lucky maybe no perl code change is required, need to ask a Koha
expert/have a look at the code.

Regards,
Simon


On 08/12/05, Thomas D <koha at alinto.com> wrote:
>
> Please see my earlier reply to this thread.  There should be no need to
> change a perfectly appropriate column name.  Use ANSI compliant quoting of
> the column name instead.
>
>
> Thomas D
>
>
> Quoting Paul POULAIN <paul.poulain at free.fr> :
> > ---------------- Beginning of the original message ------------------
> >
>
> [snip]
>
> >
> > It's probably a reserved word for stored procs. that's a shame
> > & should
> > be cleaned for 3.0, even if we don't use mySQL immediatly.
> >
> > --
> > Paul POULAIN
> > Consultant indépendant en logiciels libres
> > responsable francophone de koha (SIGB libre
> > http://www.koha-fr.org)
> >
> >
> > _______________________________________________
> > Koha-devel mailing list
> > Koha-devel at nongnu.org
> > http://lists.nongnu.org/mailman/listinfo/koha-devel
> >
> > ------------------- End of the original message ---------------------
>
>
>
>
> ---------------------------------------------
> Protect your mails from viruses thanks to Alinto Premium services
> http://www.alinto.com
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at nongnu.org
> http://lists.nongnu.org/mailman/listinfo/koha-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20051209/d1c6c548/attachment-0002.htm>