You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Schumann Ye <Sc...@hotmail.com> on 2018/03/29 15:28:06 UTC

答复: 答复: A major bug in OFBiz Manufacturing MRP function

Hi Rajesh,

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.

B.R.
Schumann

-----邮件原件-----
发件人: Rajesh Mallah <ma...@gmail.com> 
发送时间: 2018年3月29日 23:24
收件人: user@ofbiz.apache.org
主题: Re: 答复: A major bug in OFBiz Manufacturing MRP function

> 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,
>

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.

regds
mallah.

答复: A major bug in OFBiz Manufacturing MRP function

Posted by Schumann Ye <Sc...@hotmail.com>.
Dear Rajesh and Paul,

Thanks for your comments.
Will have a check on Postgres later.

B.R.
Schumann

-----邮件原件-----
发件人: Paul Mandeltort <pa...@marcospec.com> 
发送时间: 2018年3月30日 3:02
收件人: user@ofbiz.apache.org
主题: Re: A major bug in OFBiz Manufacturing MRP function

Postgres is pretty much standard now, especially now that Amazon AWS has support for it on Aurora.  
—P 

> On Mar 29, 2018, at 14:51, Rajesh Mallah <ma...@gmail.com> wrote:
> 
> Hi Schmann ,
> 
> You may consider exploring PostgreSQL.
> 
> regds
> mallah.
> 
> On Thu, Mar 29, 2018 at 8:58 PM, Schumann Ye 
> <Sc...@hotmail.com>
> wrote:
> 
>> Hi Rajesh,
>> 
>> 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.
>> 
>> B.R.
>> Schumann
>> 
>> -----邮件原件-----
>> 发件人: Rajesh Mallah <ma...@gmail.com>
>> 发送时间: 2018年3月29日 23:24
>> 收件人: user@ofbiz.apache.org
>> 主题: Re: 答复: A major bug in OFBiz Manufacturing MRP function
>> 
>>> 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,
>>> 
>> 
>> 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.
>> 
>> regds
>> mallah.
>> 


Re: A major bug in OFBiz Manufacturing MRP function

Posted by Paul Mandeltort <pa...@marcospec.com>.
Postgres is pretty much standard now, especially now that Amazon AWS has support for it on Aurora.  
—P 

> On Mar 29, 2018, at 14:51, Rajesh Mallah <ma...@gmail.com> wrote:
> 
> Hi Schmann ,
> 
> You may consider exploring PostgreSQL.
> 
> regds
> mallah.
> 
> On Thu, Mar 29, 2018 at 8:58 PM, Schumann Ye <Sc...@hotmail.com>
> wrote:
> 
>> Hi Rajesh,
>> 
>> 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.
>> 
>> B.R.
>> Schumann
>> 
>> -----邮件原件-----
>> 发件人: Rajesh Mallah <ma...@gmail.com>
>> 发送时间: 2018年3月29日 23:24
>> 收件人: user@ofbiz.apache.org
>> 主题: Re: 答复: A major bug in OFBiz Manufacturing MRP function
>> 
>>> 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,
>>> 
>> 
>> 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.
>> 
>> regds
>> mallah.
>> 


Re: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Schmann ,

You may consider exploring PostgreSQL.

regds
mallah.

On Thu, Mar 29, 2018 at 8:58 PM, Schumann Ye <Sc...@hotmail.com>
wrote:

> Hi Rajesh,
>
> 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.
>
> B.R.
> Schumann
>
> -----邮件原件-----
> 发件人: Rajesh Mallah <ma...@gmail.com>
> 发送时间: 2018年3月29日 23:24
> 收件人: user@ofbiz.apache.org
> 主题: Re: 答复: A major bug in OFBiz Manufacturing MRP function
>
> > 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,
> >
>
> 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.
>
> regds
> mallah.
>