MariaDbCompatibilityTest.java

package org.mariadb.jdbc;

import org.junit.BeforeClass;
import org.junit.Test;

import java.sql.*;

import static org.junit.Assert.*;

public class MariaDbCompatibilityTest extends BaseTest {
    @BeforeClass()
    public static void initClass() throws SQLException {
        createTable("datatypesTest", "type_longvarchar TEXT NULL");
        createTable("mysqlcompatibilitytest", "id int not null primary key auto_increment, test bit(1)");
    }

    /**
     * Conj-82: data type LONGVARCHAR not supported in setObject().
     *
     * @throws SQLException exception
     */
    @Test
    public void datatypesTest() throws SQLException {
        try (Statement stmt = sharedConnection.createStatement()) {
            try (PreparedStatement preparedStmt = sharedConnection.prepareStatement(
                    "INSERT INTO `datatypesTest` (`type_longvarchar`) VALUES ( ? )")) {
                preparedStmt.setObject(1, "longvarcharTest", Types.LONGVARCHAR);
                preparedStmt.executeUpdate();
            }

            ResultSet rs = stmt.executeQuery("SELECT * FROM datatypesTest");
            stmt.close();
            if (rs.next()) {
                assertEquals("longvarcharTest", rs.getString(1));
            } else {
                fail();
            }
        }
    }

    /**
     * The Mysql connector returns "0" or "1" for BIT(1) with ResultSet.getString().
     * CONJ-102: mariadb-java-client returned "false" or "true".
     *
     * @throws SQLException exception
     */
    @Test
    public void testBitConj102() throws SQLException {
        Statement stmt = sharedConnection.createStatement();
        stmt.execute("insert into mysqlcompatibilitytest values(null, b'0')");
        stmt.execute("insert into mysqlcompatibilitytest values(null, b'1')");
        ResultSet rs = stmt.executeQuery("select * from mysqlcompatibilitytest");
        assertTrue(rs.next());
        assertTrue("0".equalsIgnoreCase(rs.getString(2)));
        assertTrue(rs.next());
        assertTrue("1".equalsIgnoreCase(rs.getString(2)));
    }

}