field name:errors

------=_NextPart_000_0005_01C358C8.9E6AF8E0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

Hi:

In an older version of the database I had a field called errors.

When I tried to recreate the database in version 4.1, the create table =
statement that had the field errors showed me an error.

I changed the create statement to create a field _errors and it worked =
o.k.

I used an alter table statement to change the name of the field to =
errors again and worked o.k., but now select queries calling the field =
(select errors from ....) doesn't work.


thanks,
Ruth Nisenbaum

------=_NextPart_000_0005_01C358C8.9E6AF8E0--
Ruth Nisenbaum [ Sa, 02 August 2003 07:35 ] [ ID #76128 ]

Re: field name:errors

Hi!

On Aug 02, Ruth Nisenbaum wrote:
> Hi:
>
> In an older version of the database I had a field called errors.
>
> When I tried to recreate the database in version 4.1, the create table
> statement that had the field errors showed me an error.
>
> I changed the create statement to create a field _errors and it worked
> o.k.
>
> I used an alter table statement to change the name of the field to
> errors again and worked o.k., but now select queries calling the
> field (select errors from ....) doesn't work.

Check

http://bugs.mysql.com/bug.php?id=724

as this is related issue.
Both will be resolved (in that or another way) at the same time.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org
Sergei Golubchik [ Sa, 02 August 2003 09:36 ] [ ID #76129 ]
Datenbanken » gmane.comp.db.mysql.bugs » field name:errors

Vorheriges Thema: MySQL Date/Time Problem
Nächstes Thema: MySQL 4.1.0 crash every running with tis620 charset