#109 mdb-sql & mdb-export returning rows of NULL data

open
nobody
5
2006-11-24
2006-11-24
Mike
No

After successfully installing mdbtools 0.6pre1, I tested things by running some queries on a table that has 14 rows of data in it.

However, mdb-sql returns the 14 rows, but with nothing (NULL) in them.

See:
1 => select * from Cash_Rates
2 => go

+-------+--------------------+----------+----------+----------+--------+--------------------+
|G_Code |E_Date |DailyRate |MvgAvg7 |AvgMat |Modified|ModDate |
+-------+--------------------+----------+----------+----------+--------+--------------------+
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
+-------+--------------------+----------+----------+----------+--------+--------------------+
14 Rows retrieved

The same happens with mdb-export:
root@jaguar# mdb-export ***.mdb Cash_Rates
G_Code,E_Date,DailyRate,MvgAvg7,AvgMat,Modified,ModDate
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""

All data is being returned as NULL, even though the correct number of rows are being reported.

Result of mdb-ver:
root@jaguar# mdb-ver ***.mdb
JET4

Here's the schema of that table:
DROP TABLE Cash_Rates;
CREATE TABLE Cash_Rates
(
G_Code Long Integer,
E_Date DateTime (Short),
DailyRate Double,
MvgAvg7 Double,
AvgMat Double,
Modified Boolean,
ModDate DateTime (Short)
);

System:
root@jaguar# uname -srm
FreeBSD 6.1-RELEASE-p7 i386

Discussion

  • Mike
    Mike
    2006-11-24

    • labels: --> cmd line utils
     
  • Chris
    Chris
    2006-12-15

    Logged In: YES
    user_id=1669094
    Originator: NO

    I receive exactly the same weird behaviour, also under FreeBSD 6.1-RELEASE. Only happens with Access 97 files.. if I convert them to Access 2000 or above the problem dissapears.

    Also the columns are listed in the wrong order every time... again this is limited to 97.. 2000 and above work correctly..

     
  • Brian Bruns
    Brian Bruns
    2007-03-05

    Logged In: YES
    user_id=11673
    Originator: NO

    Can I get a copy of a database that does this? You can send it directly to me. Reference bug #1602076 in the subject.

     
  • oc666
    oc666
    2009-12-27

    Hey
    Sorry to popup this bug, but it's still exists.
    It happends with the next unicode (utf-8) data:
    צמיחת התנועה הלאומית הערבית-הפלסטינאית 1929-1918
    It output NULL instead the data. Maybe it happends because of the hyphen, but I'm not sure about that.

     
  • oc666
    oc666
    2009-12-27

    OK. After some eximnation I think I got it.
    If column data contain two hypens it will return NULL.
    Hope that the developers would pay attention for this bug.
    I don't know on other cases that it return NULL instead of some data.