package org.apache.phoenix.expression;

import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertNull;
import static org.junit.Assert.assertTrue;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.Properties;

import org.apache.phoenix.query.BaseConnectionlessQueryTest;
import org.apache.phoenix.util.PropertiesUtil;
import org.junit.Test;

public class NullValueTest extends BaseConnectionlessQueryTest {
    
    @Test
    public void testComparisonExpressionWithNullOperands() throws Exception {
        String[] query = {"SELECT 'a' >= ''", 
                          "SELECT '' < 'a'", 
                          "SELECT '' = ''"};
        Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(getUrl(), props);
        try {
            for (String q : query) {
                ResultSet rs = conn.createStatement().executeQuery(q);
                assertTrue(rs.next());
                assertNull(rs.getObject(1));
                assertEquals(false, rs.getBoolean(1));
                assertFalse(rs.next());
            }
        } finally {
            conn.close();
        }       
    }
    
    @Test
    public void testAndExpressionWithNullOperands() throws Exception {
        String[] query = {"SELECT 'b' >= 'a' and '' < 'b'", 
                          "SELECT 'b' >= '' and 'a' < 'b'",
                          "SELECT 'a' >= 'b' and 'a' < ''",
                          "SELECT '' >= 'a' and 'b' < 'a'",
                          "SELECT 'a' >= '' and '' < 'a'"};
        Boolean[] result = {null,
                            null,
                            Boolean.FALSE,
                            Boolean.FALSE,
                            null};
        Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(getUrl(), props);
        try {
            for (int i = 0; i < query.length; i++) {
                ResultSet rs = conn.createStatement().executeQuery(query[i]);
                assertTrue(rs.next());
                assertEquals(result[i], rs.getObject(1));
                assertEquals(false, rs.getBoolean(1));
                assertFalse(rs.next());
            }
        } finally {
            conn.close();
        }       
    }
    
    @Test
    public void testOrExpressionWithNullOperands() throws Exception {
        String[] query = {"SELECT 'b' >= 'a' or '' < 'b'", 
                          "SELECT 'b' >= '' or 'a' < 'b'",
                          "SELECT 'a' >= 'b' or 'a' < ''",
                          "SELECT '' >= 'a' or 'b' < 'a'",
                          "SELECT 'a' >= '' or '' < 'a'"};
        Boolean[] result = {Boolean.TRUE,
                            Boolean.TRUE,
                            null,
                            null,
                            null};
        Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(getUrl(), props);
        try {
            for (int i = 0; i < query.length; i++) {
                ResultSet rs = conn.createStatement().executeQuery(query[i]);
                assertTrue(rs.next());
                assertEquals(result[i], rs.getObject(1));
                assertEquals(Boolean.TRUE.equals(result[i]) ? true : false, rs.getBoolean(1));
                assertFalse(rs.next());
            }
        } finally {
            conn.close();
        }       
    }

}

@@ -1,8 +1,810 @@
+/*%0A * Licensed to the Apache Software Foundation (ASF) under one%0A * or more contributor license agreements.  See the NOTICE file%0A * distributed with this work for additional information%0A * regarding copyright ownership.  The ASF licenses this file%0A * to you under the Apache License, Version 2.0 (the%0A * %22License%22); you may not use this file except in compliance%0A * with the License.  You may obtain a copy of the License at%0A *%0A * http://www.apache.org/licenses/LICENSE-2.0%0A *%0A * Unless required by applicable law or agreed to in writing, software%0A * distributed under the License is distributed on an %22AS IS%22 BASIS,%0A * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.%0A * See the License for the specific language governing permissions and%0A * limitations under the License.%0A */%0A
 package 

Add Apache license header