#12 ZZZZZ database error with MySQL 4.1.2 alpha

[Jürgen Lange]

after a succesful install of MySQL 4.1.2 alpha from the
BitKeeper development tree - i.e. I can connect from a
mysql client on the same host (i.e. unix socket) or
another host (i.e. tcp/ip socket) - I'm faced with the
following error message when I try to send any SELECT
query to the db-server:
REXX/SQL-1 Database Error (ZZZZZ)

Weird is that some SQL commands do work:
- the SQLConnect succeeds
- DROP TABLE works
- CREATE TEMPORARY TABLE works

but as soon as I do a SELECT... the message above is
the only thing I see.
The error is probably on the MySQL side but what
exactly happens if this error msg is issued.

[Jürgen Lange]

Logged In: YES
user_id=901941

I was not completely right in my above problem description:

First i execute the following query (as a test) without
error message:
'SELECT examcode AS "exm",COUNT(examcode) AS "cnt"
FROM examiner WHERE directorate="1234"
GROUP BY examcode'
this succeeds - i can access the returned data.

then i execute the following query:
'CREATE TEMPORARY TABLE $tstdistrib
SELECT examcode AS "exm",COUNT(examcode) AS "cnt"
FROM examiner WHERE directorate="1234"
GROUP BY examcode'
- this succeeds as well.

thereafter i run into the ZZZZZ message with the following
query:
'SELECT MAX(cnt) AS "max" FROM $tstdistrib'
the complete error output is:
sqlca.interrm=REXX/SQL-1: Database Error
sqlca.sqlerrm=(ZZZZZ) You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server
version for the right syntax to use near '' at line 1

the 'SELECT MAX ...' SQL query works perfectly well from the
MySQL client (any of 4.0.14, 4.1.1, 4.1.2) and also with
Rexx/SQL + MySQL 4.1.1

[Jürgen Lange]

Logged In: YES
user_id=901941

I tried a few other things:
re-configured and installed RexxSQL (2.4) (what I should
have done before !)
(./configure --with-rexx=regina
--with-rexxincdir=/usr/share/rexx/Regina-3.2/
--with-db=mysql
--with-dbincdir=/usr/local/mysql-4.1.2-alpha-pc-linux-i686/include
--with-dblibdir=/usr/local/mysql-4.1.2-alpha-pc-linux-i686/lib
--no-create --no-recursion)
compiling and installing gives no apparent problems - but
now I cannot even connect to the DB server:
the samples/simple.cmd demo program gives:
sh: line 1: SQLLOADFUNCS: command not found
sh: line 1: SQLCONNECT: command not found
Program failed: connecting
SQLCA.INTERRM
(SQLCA.SQLSTATE) SQLCA.SQLERRM
sh: line 1: SQLDROPFUNCS: command not found
How can I check what's wrong with the new rexxmy, rexxsql,
librexxmy.so and librexxsql.so ?

something's strange - the newly built files have only about
1/4 of the size the old ones (configured for MySQL 4.0.15):
-rwxr-xr-x 1 root root 45892 /usr/bin/rexxmy-4.1.2
-rwxr-xr-x 1 root root 45892
/usr/bin/rexxsql-4.1.2
-rwxr-xr-x 1 root root 216459 /usr/bin/rexxmy
-rwxr-xr-x 1 root root 216511 /usr/bin/rexxsql
-rwxr-xr-x 1 root root 53896
/usr/lib/librexxmy.so-4.1.2
-rwxr-xr-x 1 root root 53896
/usr/lib/librexxsql.so-4.1.2
-rwxr-xr-x 1 root root 244914 /usr/lib/librexxmy.so
-rwxr-xr-x 1 root root 244934
/usr/lib/librexxsql.sql

[Jürgen Lange]

Logged In: YES
user_id=901941

When the MySQL 4.1.2 version was released officially (still
being alpha) I was eager to test the mentioned problem.
result: even with a re-configured and re-compiled RexxSQL
(for mysql-standard-4.1.2-alpha-pc-linux-i686) I still get
the "ZZZZZ database error". The connection to the DB can be
via /tmp/mysql.sock or via port 3306 (it's not possible to
specify different sockets or ports). For the time being I'm
forced to run two DB servers one with 4.1.2 providing
subqueries, etc. and one with 4.0.20 providing Rexx/SQL
connectivity ...

[Jürgen Lange]

Logged In: YES
user_id=901941

still the same story with mysql-standard-4.1.3-beta and
mysql-standard-4.1.4-gamma !