ID: 32208 Updated by: [EMAIL PROTECTED] Reported By: wolstena at sfu dot ca -Status: Feedback +Status: No Feedback Bug Type: MySQL related Operating System: Fedora Core 3 PHP Version: 4.3.10 New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2005-03-07 00:39:44] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip And if it still is crashing, provide the GDB backtrace. ------------------------------------------------------------------------ [2005-03-06 22:32:02] wolstena at sfu dot ca Description: ------------ The query below causes mysql_query() to crash without php without error. The original query: SELECT b189_start, b189_end, product_level1.Id AS id, product_level1.a001 AS a001, b014 AS description, FORMAT(price.j151, 2) AS price, images.Name AS product_image, CONCAT_WS(': ', b028, b029) AS title FROM product_level1 LEFT JOIN product_webcategory_x ON (product_level1.ID=product_webcategory_x.ID_product) LEFT JOIN codes ON (product_webcategory_x.ID_category=codes.ID) LEFT JOIN price ON (product_level1.a001=price.a001) LEFT JOIN images ON (product_level1.a001 = images.ProductID) WHERE ( b189_start >= -1 AND b189_start <= 3) AND (b189_end <= 3 ) AND ( price.j151 > 0 ) AND (price.j151 IS NOT NULL) AND ( xWebInactive < 1 ) GROUP BY product_level1.ID ORDER BY b028, b029 I have tracked the probelm down to the WHERE condition with ">" and negative numbers. For example, if I change "b189_start >= -1" to "b189_start = -1" or "b189_start < -1" The problem crash does not occur. Mysql info: mysql-shared-compat-3.23.58-9.1 php-mysql-4.3.10-3.2 mysql-client-4.1.9-0RH_FC mysql-devel-3.23.58-14 mysql-server-4.1.9-0RH_FC ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32208&edit=1
