Mailing List Archive


Back to the month index Back to the list index
Mike (mike@inc-g.com)
Wed, 2 Apr 1997 14:34:14 -0800 (PST) 

Date: Wed, 2 Apr 1997 14:34:14 -0800 (PST)
From: Mike <mike@inc-g.com>
Subject: [mSQL] Problem with UINT data type
Message-Id: <Pine.BSI.3.91.970402142831.17409A-100000@val.i-link-2.net>

If I run the following commands:

create table test( item uint )\g
insert into test values( 4294900000 )\g
select * from test\g

via "msql test <test" I get the following output:

Welcome to the miniSQL monitor. Type \h for help.

mSQL > -> -> ->
Query OK. 1 row(s) modified or retrieved.

mSQL > ->
Query OK. 1 row(s) modified or retrieved.

mSQL > ->
Query OK. 1 row(s) modified or retrieved.

 +----------+
 | item |
 +----------+
 | 2147483647|
 +----------+

mSQL > ->
Bye!

This is running on BSDI 3.0. Is anyone else experiencing UINT problems?

Mike

--------------------------------------------------------------------------
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!