Re: death knell for Informix

SELECT * FROM TABLE WHERE integer_column = '1'; i would really be carefull using above.... it may bite you one day. the above can cause a sequential scan even when there are indexes on integer_column. Superboer. On 26 apr, 14:56, Philip Nelson <team...@scotdb.com> wrote: > Serge Rielau wrote: > > Data Cruncher wrote: > > http://www.computerworld.com/action/article.do?command=viewArticleBas... > > > > > > >> IBM to open its midrange systems to MySQL's database > > What does that have to do with IDS? > > IDS doesn't run on iSeries. > > There are exactly 2 things at work here: > > 1. Enabling of mySQL on iSeries (good for iSeries) > > 2. Enabling of mySQL directly on DB2 for iSeries (without dependency on > > another storage engine) (still good for iSeries) > > > Depending how one reads the articles one may suspect that IBM will > > provide soem help to get mySQL closer to the SQL Standard. > > I sure would love to see mySQL users stop nagging: DB2 is bad because > > "SELECT 1+2" returns an syntax error ... ;-) > > > Cheers > > Serge > > Or even - > > SELECT * FROM TABLE WHERE integer_column = '1';> > Came across this during my work on Ruby on Rails !!! > > You can put quotes around the literals for any data type in MySQL and it > works. > > Phil