#32208 [Opn->Fbk]: WHERE column > -1 crashes but WHERE column < -1 or WHERE column = 1 are fine

ID: 32208 Updated by: sniper@php.net Reported By: wolstena at sfu dot ca -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Fedora Core 3 PHP Version: 4.3.10 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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