|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-03-07 00:39 UTC] sniper@php.net
[2005-03-20 18:01 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 06:00:01 2025 UTC |
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