[rt-devel] Re: MySQL use of 'Data'

[Jesse]

Frans,
       the version of mysql I've been developing against hasn't been enforcing
reserved words.  Just after the release of Alpha 1, I started to redo some of
them.  Somehow Transaction->Data didn't make it onto my list.   It should
be fixed the next time I get a few moments.
        Thanks for the bugreport,
        -j


On Mon, Sep 18, 2000 at 10:55:49AM +0200, Frans Stekelenburg wrote:
> Dear Jesse,
> 
> A MySQL user question about RT....:
> At some point the data model and source has been changed so that the
> 'Transactions' table now
> requires a row 'Data'.  Our MySQL (Ver 6.2 Distrib 3.22.21, for
> sun-solaris2.6 (sparc))
> refuses this fieldname, likely cause it's an internal one.
> 
> Thereby, now all through the code one sees 'Data' beeing used, but it
> seems not allways
> for the same purpose/data type, which makes it VERY confusing and hard
> to follow the source code.
> We labeled the tablefield Transactions->Data1 (instead of Data), and
> tried to figure out which Data in the code to change to Data1 to make it
> work. It works (partly) now, but I'm bot sure that we got 'em all....
> 
> Probably your MySQL didn't complain about 'Data'?
> 
> Still, can you address this matter?
> 
> 
> Kind regards,
> 
> Frans Stekelenburg
> Acriter, the Netherlands
> 
> 
> 

-- 
jesse reed vincent --- root at eruditorum.org --- jesse at fsck.com 
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
-------------------------------------------------------------
"Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"