Bug: MySQL WebDNA 6 int bigint fail case
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59440
interpreted = N
texte = Hi, Narrowed down a bug with numbers, WebDNA 6 and MySQL.I found it by wanting to store a CART num in a bigint field.Note: WebDNA Linux and WebDNA OSX return different Values.Using Webmin to test MySQL, shows the MySQL is correct.= = = = = = = = = =-- Using this as input:---- MySQL dump 9.11---- Host: localhost Database: test-- -------------------------------------------------------- Server version4.0.21-standard---- Table structure for table `test`--DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `testint` int(11) unsigned NOT NULL default '0', `testbigint` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`testint`)) TYPE=MyISAM;---- Dumping data for table `test`--INSERT INTO `test` VALUES (4294967295,1095711250141);= = = = = = = = = =On both Linux and OSX: Output from SQL commandselect * from test ;testint 4294967295testbigint 1095711250141Works as it should.= = = = = = = = = =from WebCat 6 Linux RHES 3.0 using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 494589661= = = = = = = = = =from WebCat 6 OSX using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 2147483647-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi, Narrowed down a bug with numbers, WebDNA 6 and MySQL.I found it by wanting to store a CART num in a bigint field.Note: WebDNA Linux and WebDNA OSX return different Values.Using Webmin to test MySQL, shows the MySQL is correct.= = = = = = = = = =-- Using this as input:---- MySQL dump 9.11---- Host: localhost Database: test-- -------------------------------------------------------- Server version4.0.21-standard---- Table structure for table `test`--DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `testint` int(11) unsigned NOT NULL default '0', `testbigint` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`testint`)) TYPE=MyISAM;---- Dumping data for table `test`--INSERT INTO `test` VALUES (4294967295,1095711250141);= = = = = = = = = =On both Linux and OSX: Output from SQL commandselect * from test ;testint 4294967295testbigint 1095711250141Works as it should.= = = = = = = = = =from WebCat 6 Linux RHES 3.0 using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 494589661= = = = = = = = = =from WebCat 6 OSX using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 2147483647-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Jim Lanford
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Writing encrypted files causes errors ... (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
Emailer and encryption (1997)
New site announcement + Showing once on a founditems (1997)
[WebDNA] 2nd pair of eyes on redirect please (2011)
more info on [setlineitems] (1997)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
WebCat2 - storing unformatted date data? (1997)
restarting service remotely on NT (1997)
Online reference (1997)
Protect (1997)
"Advanced" Search Algorithm (2008)
Grep support request for SMSI ... (2003)
URGENT: BUG, woFIELDdata & FIELDword=ww (2002)
Sort Order on a page search (1997)
[OT] Who's got a cool link (2002)
add to cart within a page? (1997)
Security problems (2000)
Satistics (1999)
Checking Webdna is running (2007)