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 command select * from test ; testint 4294967295 testbigint 1095711250141 Works as it should. = = = = = = = = = = from WebCat 6 Linux RHES 3.0 using select * from test ; Host: localhost Server Version: 4.0.21-standard Client Version: 3.23.58 1 records found testint 2147483647 testbigint 494589661 = = = = = = = = = = from WebCat 6 OSX using select * from test ; Host: localhost Server Version: 4.0.21-standard Client Version: 3.23.58 1 records found testint 2147483647 testbigint 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:

    
  1. Re: Bug: MySQL WebDNA 6 int bigint fail case ( "Steve Contreras" 2004)
  2. Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
  3. Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004)
  4. Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
  5. Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004)
  6. Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
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 command select * from test ; testint 4294967295 testbigint 1095711250141 Works as it should. = = = = = = = = = = from WebCat 6 Linux RHES 3.0 using select * from test ; Host: localhost Server Version: 4.0.21-standard Client Version: 3.23.58 1 records found testint 2147483647 testbigint 494589661 = = = = = = = = = = from WebCat 6 OSX using select * from test ; Host: localhost Server Version: 4.0.21-standard Client Version: 3.23.58 1 records found testint 2147483647 testbigint 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)