[Erp5-report] r16770 - /erp5/trunk/products/ERP5/Tool/SimulationTool.py
nobody at svn.erp5.org
nobody at svn.erp5.org
Tue Oct 2 11:34:53 CEST 2007
Author: vincent
Date: Tue Oct 2 11:34:52 2007
New Revision: 16770
URL: http://svn.erp5.org?rev=16770&view=rev
Log:
Add a notice about ill-looking SQL generated which is actually harmless.
Modified:
erp5/trunk/products/ERP5/Tool/SimulationTool.py
Modified: erp5/trunk/products/ERP5/Tool/SimulationTool.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/Tool/SimulationTool.py?rev=16770&r1=16769&r2=16770&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/Tool/SimulationTool.py (original)
+++ erp5/trunk/products/ERP5/Tool/SimulationTool.py Tue Oct 2 11:34:52 2007
@@ -959,6 +959,12 @@
# XXX: uggly duplicated query generation code
# XXX: duplicates SQL variable formatting present in
# ERP5Type/patches/sqlvar.py about datetime SQL columns.
+ # Note: This code can generate queries like:
+ # date = 2000/01/01 and date >= 2001/01/01
+ # When latest full inventory is at 2000/01/01 and given
+ # from_date is 2001/01/01.
+ # It is not a serious problem since MySQL detects incompatible
+ # conditions and immediately returns (with 0 rows).
equal_date_query_list = []
greater_than_date_query_list = []
EQUAL_DATE_TABLE_ID = 'inventory_stock'
More information about the Erp5-report
mailing list