6.6.2 can't retrieve complete fields list from MySQL 5.0

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
singalen
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 13.01.2008, 11:28

6.6.2 can't retrieve complete fields list from MySQL 5.0

Post by singalen »

For a table described below, MySQL table retrieves only first 5 fields, both in field editor or runtime.
BCB 6.0, Windows Vista russian, MySQL 5.0.18.

Frustrating 8-\\\\

Code: Select all

CREATE TABLE person (
  id_person int(5) unsigned NOT NULL auto_increment,
  pass varchar(50) NOT NULL,
  familia varchar(100) NOT NULL,
  name varchar(100) NOT NULL,
  otch varchar(100) NOT NULL,
  passport varchar(10) NOT NULL,
  passport2 varchar(100) NOT NULL,
  nik varchar(100) default NULL,
  date_bthd date NOT NULL,
  id_gorod int(3) NOT NULL default 0,
  email varchar(100) NOT NULL,
  addres varchar(100) default NULL,
  telefon varchar(30) NOT NULL,
  god_rol int(4) NOT NULL,
  bolezn varchar(200) default NULL,

  id_grp tinyint(3) NOT NULL default 1,
  tar1 enum("0","1") NOT NULL default '0',
  tar2 enum("0","1") NOT NULL default '0',
  tar3 enum("0","1") NOT NULL default '0',
  tar4 varchar(200) NOT NULL,
  activ  varchar(200) NOT NULL,
  zaezd   tinyint(1) NOT NULL default 1,
  procent tinyint(3) NOT NULL,
  status  tinyint(1) NOT NULL default 0,
  is08 enum("0","1") NOT NULL default '0',
  is09 enum("0","1") NOT NULL default '0',
  is10 enum("0","1") NOT NULL default '0',

  ip char(15) NOT NULL,
  dtime datetime NOT NULL,

  PRIMARY KEY  (id_person),
  KEY name (name,familia,nik,id_gorod)
)  ENGINE=MyISAM DEFAULT CHARSET='cp1251';
upd:
I wonder if it's a coincience, but the maximum number if fields I got is 5, same as in resultset retrieved by "SHOW COLUMNS", while LoadColumns for my table recursively calls LoadColumns for metadata resultset.
Looks like some global data stuck, or even worse, local object data not initialized and older value used.
Might be a good idea to run it through memory debugger... Sorry that I won't do it, too little time for that.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Is it only for this table?

Mark
Image
Post Reply