/**
 * 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.common.DateExtractor;
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;
import org.joda.time.MutableDateTime;

public abstract class MUnixTimestamp extends TOverloadBase {

    private static final int DATE_INDEX = 0; 
    
    public static MUnixTimestamp NOARG = new MUnixTimestamp() {

            @Override
            protected void buildInputSets(TInputSetBuilder builder) {
            }

            @Override
            protected void doEvaluate(TExecutionContext context, LazyList<? extends PValueSource> inputs, PValueTarget output) {
                output.putInt32((int)System.currentTimeMillis());
            }
        };
    
    public static MUnixTimestamp ONEARG = new MUnixTimestamp() {
         @Override
            protected void buildInputSets(TInputSetBuilder builder) {
                builder.covers(MDatetimes.DATETIME, 0);
            }

            @Override
            protected void doEvaluate(TExecutionContext context, LazyList<? extends PValueSource> inputs, PValueTarget output) {
                long input = inputs.get(0).getInt64();

                long[] datetime = DateExtractor.getDatetime(input);
                MutableDateTime date = (MutableDateTime) context.exectimeObjectAt(DATE_INDEX);
                if (date == null) {
                    context.putExectimeObject(DATE_INDEX, date = new MutableDateTime());
                }
                date.setDateTime((int)datetime[0], (int)datetime[1], (int)datetime[2], 
                            (int)datetime[3], (int)datetime[4], (int)datetime[5], 0);
                int millis = (int) date.getMillis();
                output.putInt32(millis <= 0 ? 0 : millis);
            }
    };

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

    @Override
    public TOverloadResult resultType() {
        return TOverloadResult.fixed(MNumeric.INT.instance());
    }
}

@@ -1884,448 +1884,32 @@
 tic 
-MUnixTimestamp NOARG = new MUnixTimestamp() %7B%0A%0A            @Override%0A            protected void buildInputSets(TInputSetBuilder builder) %7B%0A            %7D%0A%0A            @Override%0A            protected void doEvaluate(TExecutionContext context, LazyList%3C? extends PValueSource%3E inputs, PValueTarget output) %7B%0A                output.putInt32((int)System.currentTimeMillis());%0A            %7D%0A        %7D;%0A    %0A    public static MUnixTimestamp ONEARG
+final TOverload INSTANCE
  = n

Remove noarg instance of unix_timestamp