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:
WebCatalog for LinuxPPC/SusePPC? (2000)
MAC versions of WebCatalog 2.1 and WebMerchant 2.1 (1998)
WebCat2: multiple currency support (1997)
Re1000002: Setting up shop (1997)
Add a field to the error log? (1997)
[carts] and databases (1997)
Fedora Core 3 and WebDNA (2005)
[WebDNA] How to get a screen size (2009)
Interfacing WebMerchant to www.fedex.com (1997)
WCf2 and nested tags (1997)
Crashing bug setting an array value to blank (2003)
Multiple Pulldowns (1997)
[showif] question (2000)
[date format] w/in sendmail (1997)
Reminder... (2003)
Unceremonious Unwanted Unsubscription (1999)
New commands in Final candidate (1997)
Micro-managing External Links (2006)
Here's an example of an applet in a tpl (1997)
Repeating Fields (1997)