Jacques Le Roux wrote: > Hi Adam, > > Beginning at this commit (actually I had to use a dichotomic research > between 949599 and 949628, the joy of git bursting when you use svn on > your end ;o), I get the error below
git bisect helps for that too. :) > > 2010-06-01 22:11:30,656 (http-0.0.0.0-8443-5) [ > ServiceDispatcher.java:543:ERROR] Error in Service [executeFind]: Error > running Find on the [ProductSearchNoNotInUse] entity: SQL Exception > while executing the > following:SELECT DISTINCT PR.PRODUCT_ID, PR.PRODUCT_TYPE_ID, > PR.PRIMARY_PRODUCT_CATEGORY_ID, PR.PRODUCT_NAME FROM public.PRODUCT PR > LEFT OUTER JOIN public.SUPPLIER_PRODUCT SP ON PR.PRODUCT_ID = SP.PRODUCT_ID > WHERE AND ((PR.PRODUCT_TYPE_ID <> ? OR PR.PRODUCT_TYPE_ID IS NULL)) > ORDER BY PR.PRODUCT_NAME ASC (ERREUR: erreur de syntaxe sur ou prÞs de ½ > AND + > Position: 206) > > If I simply revert it, it looks ok. As it begins to be late here, for > now I have simply reverted it at r950237 Thanks for finding a bug, and the exact revision that causes it. Plus, giving me the web link(ProductSearchNoNotInUse) to cause it to happen. I haven't yet had time to replicate.
