/**
 * 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 {

    public static final TOverload INSTANCE = new MMaketime() {};
    
    @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 < 0 || minutes >= 60 || seconds < 0 || seconds >= 60) {
            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);
    }
}

@@ -1887,11 +1887,8 @@
 ric.
-BIG
 INT,
@@ -1898,16 +1898,16 @@
  1, 2);%0A
+
     %7D%0A%0A 
@@ -2084,20 +2084,19 @@
         
-long
+int
  hours =
@@ -2116,18 +2116,18 @@
 ).getInt
-64
+32
 (); %0A   
@@ -2131,20 +2131,19 @@
         
-long
+int
  minutes
@@ -2157,34 +2157,34 @@
 ts.get(1).getInt
-64
+32
 ();%0A        long
@@ -2179,20 +2179,19 @@
         
-long
+int
  seconds
@@ -2217,10 +2217,10 @@
 tInt
-64
+32
 ();%0A
@@ -2418,12 +2418,11 @@
     
-long
+int
  tim
@@ -2547,14 +2547,13 @@
 .put
-Object
+Int32
 (tim

Change input type to INT