Re: forum vs email

2014-12-17 Thread Ruben Safir
they are no indexing usenet any longer which is a real problem because of volumns of archival information on them from everything from SQL theory to networking commands. It is depressing almost as depressing as the university library with stacks of books on the floors pushed away to make ro

Re: DB redolog

2014-12-17 Thread shawn l.green
Hi Frank, On 12/17/2014 2:11 AM, xiangdongzou wrote: HI all: As we know,when we shutdown the database cleanly,the database can do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can restart normaly.But oracle database also need redo log group(current), why? While s

Re: Function

2014-12-17 Thread shawn l.green
On 12/12/2014 2:38 PM, Alexander Syvak wrote: Hello! How is actually a function done internally in MySQL after CREATE FUNCTION statement? Why can't there be a dynamic SQL inside a function? Sorry for the delay. The answer is embedded in this description of what is or is not allowed with

Re: mysql float data type

2014-12-17 Thread Hartmut Holzgraefe
On 17 December 2014 14:21:40 CET, Patrick Sherrill wrote: >We always store as strings to avoid rounding issues and then convert >for calcs to whatever precision we need. >Pat... So you'll still be affected by rounding errors during conversion and calculation, two problems you'd avoid when us

Re: mysql float data type

2014-12-17 Thread Patrick Sherrill
We always store as strings to avoid rounding issues and then convert for calcs to whatever precision we need. Pat... Sent from my iPhone > On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti wrote: > >> On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: >>> On 16.12.2014 15:16, xiangdongzou wrote: >>>

Re: mysql float data type

2014-12-17 Thread Lucio Chiappetti
On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: On 16.12.2014 15:16, xiangdongzou wrote: Can anyone tell me why 531808.11 has been changed to 531808.12 ? typical decimal->binary->decimal conversion/rounding error. never used DECIMAL nor intend to, but the issue is typical of precision issu

ANN: Advanced Data Generator 3.3.0 released

2014-12-17 Thread Martijn Tonies (Upscene Productions)
day trial version on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=news&id=20141217 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com