I have noticed this also, Sami. The R:Base data dictionary functions seem to stop at the data type, and do not include the expressions. I have taken to doing a LIST COLUMNS and checking that all the definitions are identical.
--- Sami Aaron <[EMAIL PROTECTED]> wrote: > Hmmm ... I just submitted this as a bug - two different tables, same column > names but the computed columns have different expressions. > > CREATE TABLE `Computed1` + > (`col1` INTEGER , + > `col2` INTEGER , + > `col3` INTEGER , + > `colComputed`= + > (col1+ col2) INTEGER ) > > CREATE TABLE `Computed2` + > (`col1` INTEGER , + > `col2` INTEGER , + > `col3` INTEGER , + > `colComputed`= + > (col2+ col3) INTEGER ) > > The RDCC response is that it was that way in 6.5++ - which is true so it > won't be treated as a bug. > > But why do I think it shouldn't be that way? I always was under the > impression that the R:BASE engine was set up to prevent this. I'd be > interested in other's opinions on this as to why it's NOT that way or why it > SHOULDN'T be that way. > > Sami > > ------------------------------------------ > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > 913-915-1971 > mailto:[EMAIL PROTECTED] > www.softwaremgmt.com > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
