At 2:33 PM -0800 02-02-2000, sasha@stripped wrote:
>Paul DuBois wrote:
>>
>> At 12:00 PM -0800 02-02-2000, sasha@stripped wrote:
>> >Paul DuBois wrote:
>> >>
>> >> I take it that the addition of the "source" command in 3.23.9 makes
>> >> "source" a reserved word?
>> >>
>> >> I noticed this when an attempt to dump a 3.22 database into a
>>3.23 database
>> >> dies on my three tables that have a column named "source".
>> >> (As in "source and destination", "source of data", etc.)
>> >>
>> >> --
>> >> Paul DuBois, paul@stripped
>> >>
>> >
>> >Paul:
>> >
>> >Could you post a full example.
>> >
>> >SOURCE is a new command in the command line client that will execute the
>> >commands in the given file. I've just tried create table source(n
>> >int) on 3.23.9
>> >-- worked fine.
>> >
>> >--
>> >Sasha Pachev
>>
>> Sure. The effect is sensitive to how you write your statement. This one
>> fails:
>>
>> DROP TABLE IF EXISTS t;
>> CREATE TABLE t (
>> source int
>> );
>>
>> So will yours if you write it like this:
>>
>> create table
>> source
>> (n int);
>>
>> Seems to bomb out when source is the first word on the line -- sometimes!
>> If you write your statement like this, it works:
>>
>> create table
>> source (n int);
>
>This is a bug in the command line client -- the same is true for
>"help" -- we'll
>fix it when we get around to it -- mysqld obviously has much higher priority.
I guess I can see your point, but the proper functioning of existing databases
seems to me a higher priority than the addition of a nonessential feature
that breaks those databases.
--
Paul DuBois, paul@stripped
