mdbtools-dev

[mdb-dev] Re: mdbtools-0.5rc1 - Build

[Stefan L. <lu...@rs...>]

Hello !

Now this is the new output of mdb-sql and of isql

1 =3D> list tables
2 =3D> go
+------------------------------+
|Tables                        |
+------------------------------+
|CourseInfo                    |
+------------------------------+

1 =3D> select * from CourseInfo
2 =3D> go

+-------+----------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------+---------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------+--------------------+------=
--------------+--------------------------------------------------+-------=
-------------------------------------------+-----------------------------=
---------------------+--------------------------------------------------+=
----------+--------------------------------------------------+-----------=
---------------------------------------+---------------------------------=
-----------------+--------------------------------------------------+----=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
--------------------------------+----------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------------+
|ID     |CourseName                                                      =
                                                                         =
                                                               =
|CourseNameRus                                                           =
                                                                         =
                                                       |From             =
   |To                  |CrsCode                                         =
  |OrgCode                                           |OrgCodeRus         =
                               |ShortCourseName                          =
         |WeeksDurat|Language                                          =
|LanguageRus                                       |ApplicationDeadline  =
                             |ApplicationDeadlineRus                     =
       |CourseDescription                                                =
                                                                         =
                                                                         =
                                            |CourseDescriptionRus        =
                                                                         =
                                                                         =
                                                                         =
        |
+-------+----------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------+---------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------+--------------------+------=
--------------+--------------------------------------------------+-------=
-------------------------------------------+-----------------------------=
---------------------+--------------------------------------------------+=
----------+--------------------------------------------------+-----------=
---------------------------------------+---------------------------------=
-----------------+--------------------------------------------------+----=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
--------------------------------+----------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------------+
|535    |Applied Economic Policy Course                                  =
                                                                         =
                                                               =
|=CF=F0=E8=EA=EB=E0=E4=ED=E0=FF =FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=E0=FF =
=EF=EE=EB=E8=F2=E8=EA=E0                                                 =
                                                                         =
                                             |01/22/01 00:00:00   =
|04/27/01 00:00:00   |01AE05                                            =
|JVI                                               |=CE=C2=C8            =
                                   |AEP                                  =
             |14.000000 |English                                         =
  |=C0=ED=E3=EB=E8=E9=F1=EA=E8=E9                                        =
|Application Deadline: November 1, 2000            |1 =ED=EE=FF=E1=F0=FF =
2000                                     |The Applied Economic Policy =
(AEP) course is intended primarily for young officials (normally between =
25 and 35 years of age) from transition countries in Europe and Asia. =
The purpose of the AEP is to strengthen the potential of participants to =
formulate e|=CA=F3=F0=F1 =EF=EE =EF=F0=E8=EA=EB=E0=E4=ED=EE=E9 =
=FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=EE=E9 =EF=EE=EB=E8=F2=E8=EA=E5 =
=EF=F0=E5=E4=ED=E0=E7=ED=E0=F7=E5=ED =E2 =EF=E5=F0=E2=F3=FE =
=EE=F7=E5=F0=E5=E4=FC =E4=EB=FF
=EC=EE=EB=EE=E4=FB=F5 =F1=EF=E5=F6=E8=E0=EB=E8=F1=F2=E2=EE=E2 (=EA=E0=EA =
=EF=F0=E0=E2=E8=EB=EE, =E2 =E2=EE=E7=F0=E0=F1=F2=E5 =EE=F2 25 =E4=EE 35 =
=EB=E5=F2) =E8=E7 =F1=F2=F0=E0=ED =C5=E2=F0=EE=EF=FB =E8 =C0=E7=E8=E8,
=E8=EC=E5=E2=F8=E8=F5 =E2 =EF=F0=EE=F8=EB=EE=EC  =
=EF=EB=E0=ED=EE=E2=F3=FE  =FD=EA=EE=ED=EE=EC=E8=EA=F3. =CA=F3=F0=F1 =
=CF=DD=CF =ED=E0=EF=F0=E0=E2=EB=E5=ED =ED=E0 =F0=E0=E7=E2=E8=F2=E8=E5 =
=F1=EF=EE=F1=EE=E1=ED=EE=F1=F2=E8=20
=F1=EB=F3=F8|
|563    |Advanced Macroeconomic and Financial Management                 =
                                                                         =
                                                               =
|=D3=E3=EB=F3=E1=EB=E5=ED=ED=FB=E9 =EA=F3=F0=F1 =EF=EE =
=E2=EE=EF=F0=EE=F1=E0=EC =F3=EF=F0=E0=E2=EB=E5=ED=E8=FF =
=EC=E0=EA=F0=EE=FD=EA=EE=ED=EE=EC=E8=EA=EE=E9 =E8 =
=F4=E8=ED=E0=ED=F1=E0=EC=E8                                              =
                                                                         =
              |02/12/01 00:00:00   |02/23/01 00:00:00   |01IM08          =
                                  |IMF                                   =
            |=CC=C2=D4                                               =
|AMFM                                              |2.000000  =
|English/Russian                                   =
|=C0=ED=E3=EB./=D0=F3=F1=F1=EA=E8=E9                                     =
|By Invitation Only                                |=D2=EE=EB=FC=EA=EE =
=EF=EE =EF=F0=E8=E3=EB=E0=F8=E5=ED=E8=FE                             =
|This course is aimed at mid-level and senior officials who participate =
in the formulation and implementation of macroeconomic and financial =
policies in their countries. Since this is a relatively advanced course, =
a prerequisite is that the participants ha|=C4=E0=ED=ED=FB=E9 =
=EA=F3=F0=F1 =F0=E0=F1=F1=F7=E8=F2=E0=ED =ED=E0 =
=E3=EE=F1=F3=E4=E0=F0=F1=F2=E2=E5=ED=ED=FB=F5 =F1=EB=F3=E6=E0=F9=E8=F5 =
=F1=F0=E5=E4=ED=E5=E3=EE =E8 =F1=F2=E0=F0=F8=E5=E3=EE =E7=E2=E5=ED=E0
=F3=EF=F0=E0=E2=EB=E5=ED=E8=FF, =E7=E0=ED=E8=EC=E0=FE=F9=E8=F5=F1=FF =
=F0=E0=E7=F0=E0=E1=EE=F2=EA=EE=E9 =E8 =
=EE=F1=F3=F9=E5=F1=F2=E2=EB=E5=ED=E8=E5=EC =
=EC=E0=EA=F0=EE=FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=EE=E9 =E8 =
=F4=E8=ED=E0=ED=F1=EE=E2=EE=E9
=EF=EE=EB=E8=F2=E8=EA=E8 =E2 =F1=E2=EE=E8=F5 =F1=F2=F0=E0=ED=E0=F5. =
=CF=EE=F1=EA=EE=EB=FC=EA=F3 =EA=F3=F0=F1 =
=EE=F2=ED=EE=F1=E8=F2=E5=EB=FC=ED=EE =F3=E3=EB=F3=E1=EB=E5=ED=ED=FB=E9, =
=EF=F0=E5=E4=E2=E0=F0=E8=F2=E5=EB=FC=ED=FB=EC
=F3=F1=EB=EE=E2=E8=E5|
+-------+----------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------+---------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------+--------------------+------=
--------------+--------------------------------------------------+-------=
-------------------------------------------+-----------------------------=
---------------------+--------------------------------------------------+=
----------+--------------------------------------------------+-----------=
---------------------------------------+---------------------------------=
-----------------+--------------------------------------------------+----=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
--------------------------------+----------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------------+
2 Rows retrieved
1 =3D> q
2 =3D> quit
rsweb01:~/mdbtools-0.5rc1 # isql INS
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from CourseInfo
+---------+--------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------+------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------+-----------+-----------=
+---------------------------------------------------+--------------------=
-------------------------------+-----------------------------------------=
----------+---------------------------------------------------+----------=
----+---------------------------------------------------+----------------=
-----------------------------------+-------------------------------------=
--------------+---------------------------------------------------+------=
------------+---------------------+
| ID      | CourseName                                                   =
                                                                         =
                                                                  | =
CourseNameRus                                                            =
                                                                         =
                                                      | From      | To   =
     | CrsCode                                           | OrgCode       =
                                    | OrgCodeRus                         =
               | ShortCourseName                                   | =
WeeksDuration| Language                                          | =
LanguageRus                                       | ApplicationDeadline  =
                             | ApplicationDeadlineRus                    =
        | CourseDescription| CourseDescriptionRus|
+---------+--------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------+------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------+-----------+-----------=
+---------------------------------------------------+--------------------=
-------------------------------+-----------------------------------------=
----------+---------------------------------------------------+----------=
----+---------------------------------------------------+----------------=
-----------------------------------+-------------------------------------=
--------------+---------------------------------------------------+------=
------------+---------------------+
| 535     | Applied Economic Policy Course                               =
                                                                         =
                                                                  | =
=CF=F0=E8=EA=EB=E0=E4=ED=E0=FF =FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=E0=FF =
=EF=EE=EB=E8=F2=E8=EA=E0                                                 =
                                                                         =
                                             | 01/22/01 0| 04/27/01 0| =
01AE05                                            | JVI                  =
                             | =CE=C2=C8                                 =
              | AEP                                               | =
14.000000    | English                                           | =
=C0=ED=E3=EB=E8=E9=F1=EA=E8=E9                                        | =
Application Deadline: November 1, 2000            | 1 =ED=EE=FF=E1=F0=FF =
2000                                     | The Applied Econo|           =
|


Segmentation fault

Re: [mdb-dev] Re: mdbtools-0.5rc1 - Build

[Brian B. <ca...@ai...>]

Ok, now we are getting somewhere.

Can you post the results of 'describe table CourseInfo' in mdb-sql, and I=
=20
need a backtrace from isql...just run

gdb isql
gdb> run INS
... run your select ...
segfault
gdb> bt

and post the output, or if it's easier, send me your database in private=20
email, and I can look at it directly.

Brian

On Wed, 15 Jan 2003, Stefan Lueger wrote:

> Hello !
>=20
> Now this is the new output of mdb-sql and of isql
>=20
> 1 =3D> list tables
> 2 =3D> go
> +------------------------------+
> |Tables                        |
> +------------------------------+
> |CourseInfo                    |
> +------------------------------+
>=20
> 1 =3D> select * from CourseInfo
> 2 =3D> go
>=20
> +-------+--------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------+------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------+--------------------+---=
-----------------+--------------------------------------------------+----=
----------------------------------------------+--------------------------=
------------------------+------------------------------------------------=
--+----------+--------------------------------------------------+--------=
------------------------------------------+------------------------------=
--------------------+--------------------------------------------------+-=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-----------------------------------+-------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------------+
> |ID     |CourseName                                                    =
                                                                         =
                                                                 |CourseN=
ameRus                                                                   =
                                                                         =
                                               |From                |To  =
                |CrsCode                                           |OrgCo=
de                                           |OrgCodeRus                 =
                       |ShortCourseName                                  =
 |WeeksDurat|Language                                          |LanguageR=
us                                       |ApplicationDeadline            =
                   |ApplicationDeadlineRus                            |Co=
urseDescription                                                          =
                                                                         =
                                                                         =
                                  |CourseDescriptionRus                  =
                                                                         =
                                                                         =
                                                                       |
> +-------+--------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------+------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------+--------------------+---=
-----------------+--------------------------------------------------+----=
----------------------------------------------+--------------------------=
------------------------+------------------------------------------------=
--+----------+--------------------------------------------------+--------=
------------------------------------------+------------------------------=
--------------------+--------------------------------------------------+-=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-----------------------------------+-------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------------+
> |535    |Applied Economic Policy Course                                =
                                                                         =
                                                                 |=CF=F0=E8=
=EA=EB=E0=E4=ED=E0=FF =FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=E0=FF =EF=EE=EB=E8=
=F2=E8=EA=E0                                                             =
                                                                         =
                                 |01/22/01 00:00:00   |04/27/01 00:00:00 =
  |01AE05                                            |JVI                =
                               |=CE=C2=C8                                =
               |AEP                                               |14.000=
000 |English                                           |=C0=ED=E3=EB=E8=E9=
=F1=EA=E8=E9                                        |Application Deadline=
: November 1, 2000            |1 =ED=EE=FF=E1=F0=FF 2000                 =
                    |The Applied Economic Policy (AEP) course is intended=
 primarily for young officials (normally between 25 and 35 years of age) =
from transition countries in Europe and Asia. The purpose of the AEP is t=
o strengthen the potential of participants to formulate e|=CA=F3=F0=F1 =EF=
=EE =EF=F0=E8=EA=EB=E0=E4=ED=EE=E9 =FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=EE=E9=
 =EF=EE=EB=E8=F2=E8=EA=E5 =EF=F0=E5=E4=ED=E0=E7=ED=E0=F7=E5=ED =E2 =EF=E5=
=F0=E2=F3=FE =EE=F7=E5=F0=E5=E4=FC =E4=EB=FF
> =EC=EE=EB=EE=E4=FB=F5 =F1=EF=E5=F6=E8=E0=EB=E8=F1=F2=E2=EE=E2 (=EA=E0=EA=
 =EF=F0=E0=E2=E8=EB=EE, =E2 =E2=EE=E7=F0=E0=F1=F2=E5 =EE=F2 25 =E4=EE 35 =
=EB=E5=F2) =E8=E7 =F1=F2=F0=E0=ED =C5=E2=F0=EE=EF=FB =E8 =C0=E7=E8=E8,
> =E8=EC=E5=E2=F8=E8=F5 =E2 =EF=F0=EE=F8=EB=EE=EC  =EF=EB=E0=ED=EE=E2=F3=FE=
  =FD=EA=EE=ED=EE=EC=E8=EA=F3. =CA=F3=F0=F1 =CF=DD=CF =ED=E0=EF=F0=E0=E2=EB=
=E5=ED =ED=E0 =F0=E0=E7=E2=E8=F2=E8=E5 =F1=EF=EE=F1=EE=E1=ED=EE=F1=F2=E8=20
> =F1=EB=F3=F8|
> |563    |Advanced Macroeconomic and Financial Management               =
                                                                         =
                                                                 |=D3=E3=EB=
=F3=E1=EB=E5=ED=ED=FB=E9 =EA=F3=F0=F1 =EF=EE =E2=EE=EF=F0=EE=F1=E0=EC =F3=
=EF=F0=E0=E2=EB=E5=ED=E8=FF =EC=E0=EA=F0=EE=FD=EA=EE=ED=EE=EC=E8=EA=EE=E9=
 =E8 =F4=E8=ED=E0=ED=F1=E0=EC=E8                                         =
                                                                         =
                   |02/12/01 00:00:00   |02/23/01 00:00:00   |01IM08     =
                                       |IMF                              =
                 |=CC=C2=D4                                              =
 |AMFM                                              |2.000000  |English/R=
ussian                                   |=C0=ED=E3=EB./=D0=F3=F1=F1=EA=E8=
=E9                                     |By Invitation Only              =
                  |=D2=EE=EB=FC=EA=EE =EF=EE =EF=F0=E8=E3=EB=E0=F8=E5=ED=E8=
=FE                             |This course is aimed at mid-level and se=
nior officials who participate in the formulation and implementation of m=
acroeconomic and financial policies in their countries. Since this is a r=
elatively advanced course, a prerequisite is that the participants ha|=C4=
=E0=ED=ED=FB=E9 =EA=F3=F0=F1 =F0=E0=F1=F1=F7=E8=F2=E0=ED =ED=E0 =E3=EE=F1=
=F3=E4=E0=F0=F1=F2=E2=E5=ED=ED=FB=F5 =F1=EB=F3=E6=E0=F9=E8=F5 =F1=F0=E5=E4=
=ED=E5=E3=EE =E8 =F1=F2=E0=F0=F8=E5=E3=EE =E7=E2=E5=ED=E0
> =F3=EF=F0=E0=E2=EB=E5=ED=E8=FF, =E7=E0=ED=E8=EC=E0=FE=F9=E8=F5=F1=FF =F0=
=E0=E7=F0=E0=E1=EE=F2=EA=EE=E9 =E8 =EE=F1=F3=F9=E5=F1=F2=E2=EB=E5=ED=E8=E5=
=EC =EC=E0=EA=F0=EE=FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=EE=E9 =E8 =F4=E8=ED=E0=
=ED=F1=EE=E2=EE=E9
> =EF=EE=EB=E8=F2=E8=EA=E8 =E2 =F1=E2=EE=E8=F5 =F1=F2=F0=E0=ED=E0=F5. =CF=
=EE=F1=EA=EE=EB=FC=EA=F3 =EA=F3=F0=F1 =EE=F2=ED=EE=F1=E8=F2=E5=EB=FC=ED=EE=
 =F3=E3=EB=F3=E1=EB=E5=ED=ED=FB=E9, =EF=F0=E5=E4=E2=E0=F0=E8=F2=E5=EB=FC=ED=
=FB=EC
> =F3=F1=EB=EE=E2=E8=E5|
> +-------+--------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------+------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------+--------------------+---=
-----------------+--------------------------------------------------+----=
----------------------------------------------+--------------------------=
------------------------+------------------------------------------------=
--+----------+--------------------------------------------------+--------=
------------------------------------------+------------------------------=
--------------------+--------------------------------------------------+-=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
-----------------------------------+-------------------------------------=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
------------------------------------------------------------------------+
> 2 Rows retrieved
> 1 =3D> q
> 2 =3D> quit
> rsweb01:~/mdbtools-0.5rc1 # isql INS
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> select * from CourseInfo
> +---------+------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------------+---=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
----------------------------------------------------+-----------+--------=
---+---------------------------------------------------+-----------------=
----------------------------------+--------------------------------------=
-------------+---------------------------------------------------+-------=
-------+---------------------------------------------------+-------------=
--------------------------------------+----------------------------------=
-----------------+---------------------------------------------------+---=
---------------+---------------------+
> | ID      | CourseName                                                 =
                                                                         =
                                                                    | Cou=
rseNameRus                                                               =
                                                                         =
                                                   | From      | To      =
  | CrsCode                                           | OrgCode          =
                                 | OrgCodeRus                            =
            | ShortCourseName                                   | WeeksDu=
ration| Language                                          | LanguageRus  =
                                     | ApplicationDeadline               =
                | ApplicationDeadlineRus                            | Cou=
rseDescription| CourseDescriptionRus|
> +---------+------------------------------------------------------------=
-------------------------------------------------------------------------=
---------------------------------------------------------------------+---=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
----------------------------------------------------+-----------+--------=
---+---------------------------------------------------+-----------------=
----------------------------------+--------------------------------------=
-------------+---------------------------------------------------+-------=
-------+---------------------------------------------------+-------------=
--------------------------------------+----------------------------------=
-----------------+---------------------------------------------------+---=
---------------+---------------------+
> | 535     | Applied Economic Policy Course                             =
                                                                         =
                                                                    | =CF=
=F0=E8=EA=EB=E0=E4=ED=E0=FF =FD=EA=EE=ED=EE=EC=E8=F7=E5=F1=EA=E0=FF =EF=EE=
=EB=E8=F2=E8=EA=E0                                                       =
                                                                         =
                                       | 01/22/01 0| 04/27/01 0| 01AE05  =
                                          | JVI                          =
                     | =CE=C2=C8                                         =
      | AEP                                               | 14.000000    =
| English                                           | =C0=ED=E3=EB=E8=E9=F1=
=EA=E8=E9                                        | Application Deadline: =
November 1, 2000            | 1 =ED=EE=FF=E1=F0=FF 2000                  =
                   | The Applied Econo|           |
>=20
>=20
> Segmentation fault
>=20
>=20