[mdb-dev] mdb-sql problem

[Dmitry V. <dm...@rs...>]

Hi!

There is a problem with mdb-sql and my mdb file - mdb-sql refers to wrong column while
executing sql "select PP_Info from PlatPor where PP_Info like '%q%'".
If you look to output below or if you open this mdb file with ms access, you will find that mdb-sql
actually compares 'Rec_INN' field, not 'PP_Info' with '%q%'.

It is very strange, because mdb-export produces correct column name bindings with this file (output
also shown below)

If someone interested in solving this problem, please contact me via email and I'll send you this
broken mdb file (400K zipped).

[dmitry@proxy paylist]$ export MDBOPTS=debug_like
[dmitry@proxy paylist]$ mdb-sql pp.mdb
1 => select PP_Info from PlatPor where PP_Info like '%q%'
2 => go

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|PP_Info                                                                                                                                                                                                                                                                                                                                                                                                         |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+


[dmitry@proxy paylist]$ mdb-export pp.mdb PlatPor
ID,Vyp_Date,Sum,PP_Info,IDRec,IDRecCat,Rec_Name,Rec_INN,WWW,PP_Date,DocIdFrom1C,PP_No
5956,"12/30/99 00:00:00",33,"eee","001973","000001","nnn","dfg",1,"06/30/05 00:00:00",19071,"00001275"
5957,"12/30/99 00:00:00",22,"www","001974","000023","bbb","dfg",0,"07/01/05 00:00:00",19072,"00001276"
5958,"12/30/99 00:00:00",11,"qqq","001803","000012","vvv","dfg",0,"07/02/05 00:00:00",19075,"00001277"

-- 
With Best Regards,
 Dmitry                          mailto:dm...@rs...