From user-return-53602-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Thu Mar 29 21:02:01 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id E1EFB180645 for ; Thu, 29 Mar 2018 21:02:00 +0200 (CEST) Received: (qmail 84956 invoked by uid 500); 29 Mar 2018 19:01:54 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 84896 invoked by uid 99); 29 Mar 2018 19:01:54 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2018 19:01:54 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id BA22F1A173D for ; Thu, 29 Mar 2018 19:01:53 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.102 X-Spam-Level: X-Spam-Status: No, score=-0.102 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=marcospec.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id lzpEqkGCggaR for ; Thu, 29 Mar 2018 19:01:52 +0000 (UTC) Received: from mail-yb0-f172.google.com (mail-yb0-f172.google.com [209.85.213.172]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 0E8725F36F for ; Thu, 29 Mar 2018 19:01:52 +0000 (UTC) Received: by mail-yb0-f172.google.com with SMTP id x72-v6so2324789ybe.8 for ; Thu, 29 Mar 2018 12:01:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=marcospec.com; s=google; h=from:content-transfer-encoding:mime-version:subject:date:references :to:in-reply-to:message-id; bh=7AJ4wHUK7cpriFJq1kPF1bZdYI3C2bSM6Gy0PdtfSuw=; b=XG35bH/UPj2v5u5fqtK9XJJp7q1zK0uOdFx1cQTawGgybsm0xL/3gmY5W6s8WoP3UB yVU3LuyG5YQT56ZLVX4npAq7JpwY5Sc/j7ilB06p1jqC4AcwfdwSOCfAsSeYY9WMWqOk QgmMeVqQLelBjvMoTStVafMs/EDUNrgNUUOxC5CdUg4Japk2etxP+nb3LO/SbyvzV1S2 imFJ80Bb/iSAQbNoQMSJji/WINDFbukcB6PDdgvYEJmnSi2nXGnn8Jgzh7ley3vArsKa RK8ubyYkHgGVq824FCvvFbC9Zu+FEYAauKtizI0W7NeEZqmBvkMdXLlBJ7itbKMuxLga 4EOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:references:to:in-reply-to:message-id; bh=7AJ4wHUK7cpriFJq1kPF1bZdYI3C2bSM6Gy0PdtfSuw=; b=GvzY/uChjbPYwrOtqQjDQCI4suoYErkoSMq/vKwqny4eLEpmDg7vlGn/VyMhYEfTaf VwG2ws+xgP+M9Wzp9Ead2BPU6vPMvQhwzH0N5Czvvm3aUFujY4pTbnrG78eavVfiYFKw sAwkq2qF6YPQXZwQ6hG3yCGYuzx/vKlWmCtHLuRp/qaPdqBygP1oNkZM20wNYM2DKLBp PeMR5wsY/PsVVvqlBPJ/zpXkUxIATuKYVYeAwOy/YAFUmk+wCOGz7TrzC3lWsU0SwMk8 1AFaW78rMf0cPxP+SUhlhG1T1zIhM+3e4clkFhJMsUIhLVSTU5vlrohMfuHaZ+mqySy+ srvg== X-Gm-Message-State: AElRT7GutgunxWLpx65gyHfItiS/fPYcb7EpLTh6mSxjT5GDMleWFfqg 0YPI4tuisxTwRgV1F//QrbM25qRPSlc= X-Google-Smtp-Source: AIpwx4/G21It7FwZyxyRvRb5NScq2vSscmGTnRjNsURIZLC7F/AlFdsZf0nCB9IJek6W5AKjmQfx7Q== X-Received: by 2002:a25:5047:: with SMTP id e68-v6mr5569034ybb.165.1522350104959; Thu, 29 Mar 2018 12:01:44 -0700 (PDT) Received: from mandelbook.marcospec.local (rrcs-70-61-208-178.midsouth.biz.rr.com. [70.61.208.178]) by smtp.gmail.com with ESMTPSA id c21sm2300356ywb.51.2018.03.29.12.01.40 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 29 Mar 2018 12:01:41 -0700 (PDT) From: Paul Mandeltort Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\)) Subject: Re: A major bug in OFBiz Manufacturing MRP function Date: Thu, 29 Mar 2018 15:01:39 -0400 References: To: user@ofbiz.apache.org In-Reply-To: Message-Id: <95FE4455-B330-4FA8-9DEB-7A8022A011ED@marcospec.com> X-Mailer: Apple Mail (2.3445.5.20) Postgres is pretty much standard now, especially now that Amazon AWS has = support for it on Aurora. =20 =E2=80=94P=20 > On Mar 29, 2018, at 14:51, Rajesh Mallah = wrote: >=20 > Hi Schmann , >=20 > You may consider exploring PostgreSQL. >=20 > regds > mallah. >=20 > On Thu, Mar 29, 2018 at 8:58 PM, Schumann Ye = > wrote: >=20 >> Hi Rajesh, >>=20 >> According to the official website documents, it looks like that, = which is >> bad for the programmers and the end users. >> What is your suggestion for a production environment, mysql or mssql = or >> others? >> I am afraid of future potential similar traps. >>=20 >> B.R. >> Schumann >>=20 >> -----=E9=82=AE=E4=BB=B6=E5=8E=9F=E4=BB=B6----- >> =E5=8F=91=E4=BB=B6=E4=BA=BA: Rajesh Mallah >> =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2018=E5=B9=B43=E6=9C=8829=E6=97=A5= 23:24 >> =E6=94=B6=E4=BB=B6=E4=BA=BA: user@ofbiz.apache.org >> =E4=B8=BB=E9=A2=98: Re: =E7=AD=94=E5=A4=8D: A major bug in OFBiz = Manufacturing MRP function >>=20 >>> However, when MySQL stores a value into a column of any temporal = data >>> type, it discards any fractional part and does not store it.Kind >>> regards, >>>=20 >>=20 >> I thought MySQL had by now gotten over from the childhood disease of >> discarding data silently ;-) in many contexts it was like that even = 10 >> year back. >>=20 >> regds >> mallah. >>=20