/**
 * END USER LICENSE AGREEMENT (“EULA”)
 *
 * READ THIS AGREEMENT CAREFULLY (date: 9/13/2011):
 * http://www.akiban.com/licensing/20110913
 *
 * BY INSTALLING OR USING ALL OR ANY PORTION OF THE SOFTWARE, YOU ARE ACCEPTING
 * ALL OF THE TERMS AND CONDITIONS OF THIS AGREEMENT. YOU AGREE THAT THIS
 * AGREEMENT IS ENFORCEABLE LIKE ANY WRITTEN AGREEMENT SIGNED BY YOU.
 *
 * IF YOU HAVE PAID A LICENSE FEE FOR USE OF THE SOFTWARE AND DO NOT AGREE TO
 * THESE TERMS, YOU MAY RETURN THE SOFTWARE FOR A FULL REFUND PROVIDED YOU (A)
 * DO NOT USE THE SOFTWARE AND (B) RETURN THE SOFTWARE WITHIN THIRTY (30) DAYS
 * OF YOUR INITIAL PURCHASE.
 *
 * IF YOU WISH TO USE THE SOFTWARE AS AN EMPLOYEE, CONTRACTOR, OR AGENT OF A
 * CORPORATION, PARTNERSHIP OR SIMILAR ENTITY, THEN YOU MUST BE AUTHORIZED TO
 * SIGN FOR AND BIND THE ENTITY IN ORDER TO ACCEPT THE TERMS OF THIS AGREEMENT.
 * THE LICENSES GRANTED UNDER THIS AGREEMENT ARE EXPRESSLY CONDITIONED UPON
 * ACCEPTANCE BY SUCH AUTHORIZED PERSONNEL.
 *
 * IF YOU HAVE ENTERED INTO A SEPARATE WRITTEN LICENSE AGREEMENT WITH AKIBAN FOR
 * USE OF THE SOFTWARE, THE TERMS AND CONDITIONS OF SUCH OTHER AGREEMENT SHALL
 * PREVAIL OVER ANY CONFLICTING TERMS OR CONDITIONS IN THIS AGREEMENT.
 */
package com.akiban.server.types3.mcompat.mfuncs;

import com.akiban.server.types3.*;
import com.akiban.server.types3.mcompat.mtypes.MDatetimes;
import com.akiban.server.types3.mcompat.mtypes.MNumeric;
import com.akiban.server.types3.pvalue.PValueSource;
import com.akiban.server.types3.pvalue.PValueTarget;
import com.akiban.server.types3.texpressions.TInputSetBuilder;
import com.akiban.server.types3.texpressions.TOverloadBase;

public class MMaketime extends TOverloadBase {

    @Override
    protected void buildInputSets(TInputSetBuilder builder) {
        builder.covers(MNumeric.BIGINT, 0, 1, 2);
    }

    @Override
    protected void doEvaluate(TExecutionContext context, LazyList<? extends PValueSource> inputs, PValueTarget output) {
        // Time input format HHMMSS
        long hours = inputs.get(0).getInt64(); 
        long minutes = inputs.get(1).getInt64();
        long seconds = inputs.get(2).getInt64();
        
        // Check for valid input
        if (minutes >= 60 || minutes < 0) {
            output.putNull();
            return;
        }
        if (seconds >= 60 || seconds < 0) {
            output.putNull();
            return;
        }
        
        long time = hours < 0 ? -1 : 1;
        hours *= time;
        time *= seconds + minutes * 100 + hours * 10000;
        output.putObject(time);     
    }

    @Override
    public String overloadName() {
        return "MAKETIME";
    }

    @Override
    public TOverloadResult resultType() {
        return TOverloadResult.fixed(MDatetimes.TIME);
    }
}

@@ -1705,16 +1705,86 @@
 Base %7B%0A%0A
+    public static final TOverload INSTANCE = new MMaketime() %7B%7D;%0A    %0A
     @Ove
@@ -2287,20 +2287,18 @@
 minutes 
-%3E= 6
+%3C 
 0 %7C%7C min
@@ -2306,95 +2306,25 @@
 tes 
-%3C 0) %7B%0A            output.putNull();%0A            return;%0A        %7D%0A        if (
+%3E= 60 %7C%7C 
 seconds 
 %3E= 6
@@ -2319,20 +2319,18 @@
 seconds 
-%3E= 6
+%3C 
 0 %7C%7C sec
@@ -2334,18 +2334,20 @@
 seconds 
-%3C 
+%3E= 6
 0) %7B%0A   

Create instance of MAKETIME, simplify logic