/**
 * Licensed to Apereo under one or more contributor license agreements. See the NOTICE file
 * distributed with this work for additional information regarding copyright ownership. Apereo
 * licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use
 * this file except in compliance with the License. You may obtain a copy of the License at the
 * following location:
 *
 * <p>http://www.apache.org/licenses/LICENSE-2.0
 *
 * <p>Unless required by applicable law or agreed to in writing, software distributed under the
 * License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either
 * express or implied. See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.apereo.portal.utils;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Types;
import org.hibernate.dialect.MySQL5InnoDBDialect;
import org.hibernate.type.descriptor.ValueBinder;
import org.hibernate.type.descriptor.WrapperOptions;
import org.hibernate.type.descriptor.java.JavaTypeDescriptor;
import org.hibernate.type.descriptor.sql.BasicBinder;
import org.hibernate.type.descriptor.sql.DoubleTypeDescriptor;
import org.hibernate.type.descriptor.sql.SqlTypeDescriptor;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * Uses the COMPRESSED row format in an InnoDB engine, needed for long index support with UTF-8
 *
 * @author Raymond Bourges
 */
public class MySQL5InnoDBCompressedDialect extends MySQL5InnoDBDialect {

    public MySQL5InnoDBCompressedDialect() {
        super();
    }

    public String getTableTypeString() {
        return " ENGINE=InnoDB ROW_FORMAT=COMPRESSED";
    }

    @Override
    protected SqlTypeDescriptor getSqlTypeDescriptorOverride(int sqlCode) {
        switch (sqlCode) {
            case Types.DOUBLE:
                {
                    return MySqlDoubleTypeDescriptor.INSTANCE;
                }
            default:
                {
                    return super.getSqlTypeDescriptorOverride(sqlCode);
                }
        }
    }

    private static class MySqlDoubleTypeDescriptor extends DoubleTypeDescriptor {
        private static final Logger LOGGER =
                LoggerFactory.getLogger(MySqlDoubleTypeDescriptor.class);
        private static final long serialVersionUID = 1L;

        public static final MySqlDoubleTypeDescriptor INSTANCE = new MySqlDoubleTypeDescriptor();

        public <X> ValueBinder<X> getBinder(final JavaTypeDescriptor<X> javaTypeDescriptor) {
            return new BasicBinder<X>(javaTypeDescriptor, this) {
                @Override
                protected void doBind(
                        PreparedStatement st, X value, int index, WrapperOptions options)
                        throws SQLException {
                    Double unwrappedValue = javaTypeDescriptor.unwrap(value, Double.class, options);
                    if (unwrappedValue == Double.NEGATIVE_INFINITY) {
                        LOGGER.debug("Converting double from NEGATIVE_INFINITY to MIN_VALUE");
                        unwrappedValue = Double.MIN_VALUE;
                    } else if (unwrappedValue == Double.POSITIVE_INFINITY) {
                        LOGGER.debug("Converting double from POSITIVE_INFINITY to MAX_VALUE");
                        unwrappedValue = Double.MAX_VALUE;
                    } else if (unwrappedValue == Double.NaN) {
                        LOGGER.debug("Converting double from NaN to 0");
                        unwrappedValue = 0d;
                    }
                    st.setDouble(index, unwrappedValue);
                }
            };
        }
    }
}

@@ -3452,22 +3452,16 @@
 alue
- == Double.
+.is
 NaN
+()
 ) %7B%0A

Use Double.isNaN in comparison, since NaN != NaN