Hi,

I'm running a 5.0.16 instance on a Debian box (2.6.13 kernel). The following statement causes a signal 11 without fail, and each time when mysqld_safe restarts the daemon, no socket file is created:

UPDATE X_Products.product_details AS pd , X_Products.tblMaxProductStockDisplay AS sd SET pd.allocated = IF( pd.stock_level>sd.intMaxStockDisplay , (pd.stock_level-sd.intMaxStockDisplay) , 0 ) WHERE pd.product_uid = sd.intProductID;

I can find no reference to unsupported syntax or a bug. Has anyone else had the same happen to them?

- ian

--
+-------------------------------------------------------------------+
| Ian Sales                                  Database Administrator |
|                                                                   |
|                              "All your database are belong to us" |
| ebuyer                                      http://www.ebuyer.com |
+-------------------------------------------------------------------+


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to