home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / compare.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  357 b   |  13 lines  |  [TEXT/ttxt]
  1. #
  2. # Bug when using comparions of strings and integers.
  3. #
  4.  
  5. drop table if exists t1;
  6. CREATE TABLE t1 (id CHAR(12) not null, PRIMARY KEY (id));
  7. insert into t1 values ('000000000001'),('000000000002');
  8. explain select * from t1 where id=000000000001;
  9. select * from t1 where id=000000000001;
  10. delete from t1 where id=000000000002;
  11. select * from t1;
  12. drop table t1;
  13.