Bug #4716 Floating point exception when trying to view empty table in Catalogs
Submitted: 23 Jul 2004 7:09 Modified: 23 Jul 2004 22:01
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.7 OS:Linux (Debian)
Assigned to: Alfredo Kojima CPU Architecture:Any

[23 Jul 2004 7:09] [ name withheld ]
Description:
Divide by zero,

Program received signal SIGFPE, Arithmetic exception.
[Switching to Thread 1089065216 (LWP 12805)]
0x40ac17a0 in __divdi3 () from /lib/libgcc_s.so.1
(gdb) bt
#0  0x40ac17a0 in __divdi3 () from /lib/libgcc_s.so.1
#1  0x0812babc in MACatalogsPanel::refresh_table_info (this=0x82d4fe8, schema=@0x0) at treeiter.h:299
#2  0x0812daec in MACatalogsPanel::display_schema (this=0x82d4fe8, schema=@0xbfffe660, refresh=false)
    at MACatalogsPanel.cc:804
#3  0x0812d8fe in MACatalogsPanel::schema_selected (this=0x82d4fe8, sender=0x84c1d80, node=@0x1)
    at MACatalogsPanel.cc:783
#4  0x08133e2c in SigC::ObjectSlot2_<void, MGBrowserList*, Gtk::TreeIter const&, MACatalogsPanel>::proxy (p1=@0x1,
    p2=@0x1, s=0x0) at object_slot.h:138
#5  0x081531a3 in SigC::Signal2<void, MGBrowserList*, Gtk::TreeIter const&, SigC::Marshal<void> >::emit_ (
    p1=@0xbfffe71c, p2=@0xbfffe720, data=0x1) at signal.h:761

How to repeat:
Create an emtpy table in a database and try to view it in the Catalog->{database},

MySQL dump 9.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       4.0.20-log

--
-- Table structure for table `empty`
--

CREATE TABLE empty (
  a varchar(64) NOT NULL default '',
  b int(11) default NULL,
  PRIMARY KEY  (a)
) TYPE=MyISAM;

--
-- Dumping data for table `empty`
--

Suggested fix:
Don't know the cause, so don't know the answer..
[23 Jul 2004 22:01] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html