Re: [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 <ko...@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.p...@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-...@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-...@nongnu.org
http://lists.nongnu.org/mailman/listinfo/koha-devel