Mailing List Archive


Back to the month index Back to the list index
Bill Harris (billh@airmail.net)
Mon, 17 Nov 1997 16:22:37 -0600 

Message-ID: <3470C3AD.ABD322C@airmail.net>
Date: Mon, 17 Nov 1997 16:22:37 -0600
From: Bill Harris <billh@airmail.net>
Subject: Re: corrupted "real" and "money" values in 2.0.3

Dean Karres wrote:
>
> After some additional checking today it looks like this problem does not
> lie in the commandline interfaces to msql. Both "msql" and "msqldump"
> are reporting exactly what they are receiving from the "msql2d" daemon.
> I have not tracked anything down in the daemon code yet but I`m looking.
>
> Dean...K...
>
> --
> Dean Karres | http://www2.southwind.net/~karres
> karres@southwind.net |
> Southwind Internet Access | Programmer / Systems Administrator
> Wichita, KS | <Troll 2nd Class /w Clusters>

I'm able to dupliate the same problem from a w3-script, msql command
line both. I've found a temporary (ugly) workaround though.

The problem appears to be in the result cursor generated from a
query, since the problem stays in the first non-char column.

mSQL > select sub_amt,grand_total,tax_amt from sites\g

Query OK. 1 row(s) modified or retrieved.

 +----------+-------------+----------+
 | sub_amt | grand_total | tax_amt |
 +----------+-------------+----------+
 | .0 | .00 | .00 |
 +----------+-------------+----------+
   ^^^

Where mSQL > select _rowid,grand_total,tax_amt,sub_amt from sites \g

Query OK. 1 row(s) modified or retrieved.

 +----------+-------------+----------+----------+
 | _rowid | grand_total | tax_amt | sub_amt |
 +----------+-------------+----------+----------+
 | 19 | .0 | .00 | .00 |
 +----------+-------------+----------+----------+
              ^^^^ = problem

Querying for the same field again, gives you the correct value, eg:

mSQL > select _rowid,grand_total,grand_total,tax_amt,sub_amt from
sites\g

Query OK. 1 row(s) modified or retrieved.

 +----------+-------------+-------------+----------+----------+
 | _rowid | grand_total | grand_total | tax_amt | sub_amt |
 +----------+-------------+-------------+----------+----------+
 | 19 | .0 | .00 | .00 | .00 |
 +----------+-------------+-------------+----------+----------+
              ^^^ 1st ^^^ correct value

It looks like the first element isn't getting initialized correctly
somehow. Until they identify and get us patch, I'll just have to call
the first real or money column twice and go with the second value.

Bill 

-- 
----------------------------------------------------------------------
Bill Harris							KC5YZQ
Internet America (SYSTEMS)
From stephan@ecrc.de  Tue Nov 18 02:47:23 1997
Received: from ECRC.de (mail.ecrc.de [141.1.1.10])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id CAA27242
	for <msql-list@services.bunyip.com>; Tue, 18 Nov 1997 02:47:22 -0500 (EST)
Received: (qmail 19116 invoked from network); 18 Nov 1997 07:47:01 -0000
Received: from scorpio.ecrc.de (141.1.4.100)
  by mail.ecrc.de with SMTP; 18 Nov 1997 07:47:01 -0000
Received: from bartman (bartman.ecrc.de [141.1.7.52])
          by scorpio.ecrc.de (8.8.3/8.8.4/$Revision: 1.4 $) with SMTP
	  id IAA03995 for <msql-list@services.bunyip.com>; Tue, 18 Nov 1997 08:47:00 +0100 (MET)
Message-ID: <34715619.58E4@ecrc.de>
Date: Tue, 18 Nov 1997 08:47:21 +0000
From: Stephan Bauer <stephan@ecrc.de>
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: Experiences with threaded Msql-Version...?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

as some time has passed by since the last
release and discussion about the Thread-Msql-
Version, I would enjoy hearing about some
experiences....

Thanks,

Stephan Bauer
-----------------------------------------
ECRC Network Service GmbH
e-mail : stephan@ecrc.de
-----------------------------------------
play an internet-strategie-game at 
http://www.open-house.net/game/index.html
------------------------------------------
From msql@brazilinfo.com  Tue Nov 18 07:42:39 1997
Received: from brazilinfo.com (brazilinfo.com [192.41.14.84])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id HAA01800
	for <msql-list@services.bunyip.com>; Tue, 18 Nov 1997 07:42:38 -0500 (EST)
Received: from paulo (node45.mpc.com.br [200.246.0.45]) by brazilinfo.com (8.8.5) id FAA18481; Tue, 18 Nov 1997 05:42:45 -0700 (MST)
X-Authentication-Warning: brazilinfo.com: Host node45.mpc.com.br [200.246.0.45] claimed to be paulo
Message-ID: <34718CE6.5494@brazilinfo.com>
Date: Tue, 18 Nov 1997 10:41:10 -0200
From: Paulo Parola <msql@brazilinfo.com>
Reply-To: msql@brazilinfo.com
Organization: Infovox
X-Mailer: Mozilla 3.01 [pt] (Win95; I)
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: Problems after installing mSQL version 2
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,

Our ISP has recently installed version 2.0.1, which had some bugs, so I
worked trying to make them install version 2.0.3, now setup. But one of
the problems persist: I used to translate user input like 'aBc' to
'[Aa][Bb][Cc]' in order to perform case insensitive queries, but these
queries do not work anymore (they worked all right with version 1.0.16):

mSQL > select cod_htl, nom_htl from htl where htl.nom_htl like
`%[Aa][Rr][Ii][Aa]%`\g

See the output:

Query OK.  0 row(s) modified or retrieved.

+----------+-------------------------------------------------------------------
-----------------------------------+
| cod_htl  | nom_htl
                               |

+----------+-------------------------------------------------------------------
-----------------------------------+

+----------+-------------------------------------------------------------------
-----------------------------------+

But it should work, as you can see by the output of the following
command:

mSQL > select cod_htl, nom_htl from htl where htl.nom_htl like
`%Aria%`\g

Query OK.  1 row(s) modified or retrieved.

+----------+-------------------------------------------------------------------
-----------------------------------+
| cod_htl  | nom_htl
                               |

+----------+-------------------------------------------------------------------
-----------------------------------+
| 661      | Ariaś Jungle Tower
                               |

+----------+-------------------------------------------------------------------
-----------------------------------+

My configuration reads:

Version Details :-

        msqladmin version       2.0.3
        mSQL server version     2.0.3
        mSQL protocol version   23
        mSQL connection         127.0.0.1 via TCP/IP
        Target platform         BSD_OS-3.0-i386

Configuration Details :-

        Default config file     /usr/local/msql2/msql.conf
        TCP socket              1114
        UNIX socket             /usr/local/msql2/msql2.sock
        mSQL user               root
        Admin user              root
        Install directory       /usr/local/msql2
        PID file location       /var/run/msql2.pid
        Memory Sync Timer       0
        Hostname Lookup         True 

To get it working I had to change my sources to use 'clike' and stopped
converting the input strings to regular expressions. Anyway, am I doing
something wrong or in this version this thing with regular expressions
doesn't work anymore?

Thanks,
Paulo Parola
pparola@brazilinfo.com