Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#69 mdb-export quotes col 1 int type unnecessarily

closed
nobody
5
2005-09-08
2004-10-19
adolling2
No

mdb-export (built from current cvs) quotes column 1
unnecessarily when it is an int type. I suspect the first
column's col_type may not be set correctly in
src/libmdb/table.c.

I first noticed this for an auto-increment column, but it
may be more general. In this case, the offending column
is attachid, shown quoted in the exported row.

$ mdb-schema -T attachments mysql-migrator.mdb mysql
...
DROP TABLE attachments;
CREATE TABLE attachments
(
attachid int,
linkid int,
attachurl varchar (200),
author varchar (100),
attachtitle varchar (200),
attachdate date
);
-- CREATE ANY INDEXES ...
-- CREATE ANY Relationships ...

$ mdb-export mysql-migrator.mdb attachments
attachid,linkid,attachurl,author,attachtitle,attachdate
"1",-1,"./emails/20021218_cp.html","C J XXXXXX","email:
18/Dec/2002","12/18/02 00:00:00"

Discussion

  • Brian Bruns
    Brian Bruns
    2005-09-08

    Logged In: YES
    user_id=11673

    This happens under mdbtools 0.5, but does not happen in CVS.
    Closing.

     
  • Brian Bruns
    Brian Bruns
    2005-09-08

    • status: open --> closed