Mailing List Archive


Back to the month index Back to the list index
Andreas Koppenhoefer (koppenas@koppenas.dialup.informatik.uni-stuttgart.de)
14 Jan 1997 11:52:04 +0100 

From: koppenas@koppenas.dialup.informatik.uni-stuttgart.de (Andreas Koppenhoefer)
Subject: [mSQL] msql2.0-B3 select clause broken with 'order by' and system variables
Date: 14 Jan 1997 11:52:04 +0100
Message-Id: <lre20boleaz.fsf@koppenas.dialup.informatik.uni-stuttgart.de>

-----BEGIN PGP SIGNED MESSAGE-----

Hello,

currently I'm trying to upgrade my applications for use with
msql-2. I've found a bug while testing the newest beta releases with
large bulk data in msql-2.0-B2 and msql-2.0-B3:

Select clause gives totally garbled output when used with "order by" and
some system variables.
A simple test case is shown below.

CREATE TABLE umsda (
  ortname_n CHAR(20),
  oname_sort_n CHAR(20)
) \g

INSERT INTO umsda VALUES ('Ackerfelde','ACKERFELDE')\g
INSERT INTO umsda VALUES ('Ackermannshof','ACKERMANNSHOF')\g

SELECT _rowid,_timestamp,ortname_n,oname_sort_n
  FROM umsda ORDER BY oname_sort_n \g

 +----------+------------+----------------------+----------------------+
 | _rowid | _timestamp | ortname_n | oname_sort_n |
 +----------+------------+----------------------+----------------------+
 | 0 | 853238065 | CKERFELDE | 1a[2 |
 | 1 | 853238065 | CKERMANNSHOF | 1a[2 |
 +----------+------------+----------------------+----------------------+

SELECT _rowid,_timestamp,ortname_n,oname_sort_n
  FROM umsda ORDER BY oname_sort_n \g

 +----------+------------+----------------------+----------------------+
 | _rowid | _timestamp | ortname_n | oname_sort_n |
 +----------+------------+----------------------+----------------------+
 | 0 | 853238065 | Ackerfelde | ACKERFELDE |
 | 1 | 853238065 | Ackermannshof | ACKERMANNSHOF |
 +----------+------------+----------------------+----------------------+

relshow on this:

Database = test
Table = umsda
 +-----------------+----------+--------+----------+--------------+
 | Field | Type | Length | Not Null | Unique Index |
 +-----------------+----------+--------+----------+--------------+
 | ortname_n | char | 20 | N | N/A |
 | oname_sort_n | char | 20 | N | N/A |
 +-----------------+----------+--------+----------+--------------+

Version Details :-

        msqladmin version 2.0 Beta 3
        mSQL server version 2.0 Beta 3
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Linux-2.0.14-i486

Configuration Details :-

        Default config file /backup/db/msql2/msql.conf
        TCP socket 1114
        UNIX socket /backup/db/msql2/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /backup/db/msql2
        PID file location /backup/db/msql2/msql2d.pid

-----BEGIN PGP SIGNATURE-----
Version: 2.6.2i
Comment: Processed by Mailcrypt 3.3, an Emacs/PGP interface

iQBVAwUBMttlHEVdjNvyndGpAQEIDgH/TZjX9wUCJFBNZvxQhhAvTQ75BYALRReP
IEMkSbfOtfFLb53abKEUQZkFuEs92He7O8zLtTDhOn0h+5wSalsZfQ==
=7Mz6
-----END PGP SIGNATURE----- 

-- 
Andreas Koppenhoefer, Student der Universitaet Stuttgart, BR Deutschland
Franz-Schubert-Str. 2, D-97616 Bad Neustadt; Phone +49 9771 7943, Fax/Data 7947
EMail: <koppenas@informatik.uni-stuttgart.de> or <akoppenhoefer@swin.baynet.de>
PGP-Key at <http://www.informatik.uni-stuttgart.de/menschen/ako/impressum.html>
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!