On 02/18/2016 08:44 AM, Phil Stracchino wrote:
> On 02/18/16 09:38, Dimitri Maziuk wrote:
>> MySQL can disagree with whatever it wants, but INTERVAL is an ANSI 
>> SQL-92 *datatype* and the link you posted describes a bunch of 
>> *functions* with no hint of standards compliance. There is a difference.
> 
> I'm sorry, I misunderstood.  I didn't realize we were talking about
> different things.

Specifically, I believe #3 below won't work in mysql:

1. User asked for ExpiresIn column to display something more useful than
an integer.

2. Bacula would do it if there was a way that worked in all supported
databases.

3. The standard way is to "CREATE TABLE media (... lastwritten
timestamp, volretention INTERVAL, ..." and then "SELECT ... lastwritten
+ volretention as ExpiresOn ..."

4. The intersection of "databases that support that part of the
standard" and "databases supported by bacula" is postgresql.

AFAIK, ICBW, and all that.
-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users