CrateSettingsIntegrationTest.java

package io.crate.integrationtests;


import io.crate.testing.SQLResponse;
import io.crate.testing.UseJdbc;
import org.junit.Test;

import java.util.Locale;

@UseJdbc
public class CrateSettingsIntegrationTest extends SQLTransportIntegrationTest {

    @Test
    public void testAllSettingsAreSelectable() throws Exception {
        SQLResponse res = execute("select table_schema, table_name, column_name " +
                                  "from information_schema.columns " +
                                  "where column_name like 'settings%'");
        for (Object[] row : res.rows()) {
            execute(String.format(Locale.ENGLISH, "select %s from %s.%s ", row[2], row[0], row[1]));
        }
    }
}