scnProps.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(MetaDataProtocol.MIN_SYSTEM_TABLE_TIMESTAMP));

                scnProps.remove(PhoenixRuntime.TENANT_ID_ATTRIB);

                metaConnection = new PhoenixConnection(this, url, scnProps, newEmptyMetaData());

                try {

                } catch (TableAlreadyExistsException ignore) {

                    // Ignore, as this will happen if the SYSTEM.TABLE already exists at this fixed timestamp.

                    // A TableAlreadyExistsException is not thrown, since the table only exists *after* this fixed timestamp.

                }

                try {

                    // Ignore, as this will happen if the SYSTEM.TABLE already exists at this fixed timestamp.

                    // A TableAlreadyExistsException is not thrown, since the table only exists *after* this fixed timestamp.

                }

                try {

                } catch (NewerTableAlreadyExistsException ignore) {

                    // Ignore, as this will happen if the SYSTEM.SEQUENCE already exists at this fixed timestamp.

                    // A TableAlreadyExistsException is not thrown, since the table only exists *after* this fixed timestamp.

                }

            } catch (SQLException e) {

        Statement stmt = null;

        try {

            metaConnection = new PhoenixConnection(conn.getQueryServices(), url, props, metaData);

            try {

                stmt.executeUpdate("ALTER TABLE SYSTEM.\"TABLE\" ADD IF NOT EXISTS " + columnDef);

                return metaConnection;

            } finally {

                if(stmt != null) {

                    stmt.close();

        // Cannot go through DriverManager or you end up in an infinite loop because it'll call init again

        PhoenixConnection metaConnection = new PhoenixConnection(this, oldMetaConnection.getURL(), props, oldMetaConnection.getMetaDataCache());

        SQLException sqlE = null;

        try {

        } catch (SQLException e) {

            logger.warn("addColumnsIfNotExists failed due to:" + e);

            sqlE = e;

        } finally {

            try {

                            scnProps.remove(PhoenixRuntime.TENANT_ID_ATTRIB);

                            metaConnection = new PhoenixConnection(

                                    ConnectionQueryServicesImpl.this, url, scnProps, newEmptyMetaData());

                            try {

                            } catch (NewerTableAlreadyExistsException ignore) {

                                // Ignore, as this will happen if the SYSTEM.CATALOG already exists at this fixed timestamp.

                                // A TableAlreadyExistsException is not thrown, since the table only exists *after* this fixed timestamp.

                            } catch (TableAlreadyExistsException ignore) {

                                // This will occur if we have an older SYSTEM.CATALOG and we need to update it to include

                                  PhoenixDatabaseMetaData.INDEX_TYPE + " " + PDataType.UNSIGNED_TINYINT.getSqlTypeName() +

                                  ", " + PhoenixDatabaseMetaData.INDEX_DISABLE_TIMESTAMP + " " + PDataType.LONG.getSqlTypeName());

                            }

                            try {

                            } catch (NewerTableAlreadyExistsException ignore) {

                                // Ignore, as this will happen if the SYSTEM.SEQUENCE already exists at this fixed timestamp.

                                // A TableAlreadyExistsException is not thrown, since the table only exists *after* this fixed timestamp.

                            } catch (TableAlreadyExistsException ignore) {

                                // This will occur if we have an older SYSTEM.SEQUENCE, so we need to update it to include

    @Test

    public void testSingleFixedFullPkSalted() throws SQLException {

        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), PropertiesUtil.deepCopy(TEST_PROPERTIES)).unwrap(PhoenixConnection.class);

        String query = "select * from t where k=" + 1;

        PhoenixPreparedStatement pstmt = new PhoenixPreparedStatement(pconn, query);

        QueryPlan plan = pstmt.optimizeQuery();

        Scan scan = plan.getContext().getScan();

        Filter filter = scan.getFilter();

    @Test

    public void testSingleVariableFullPkSalted() throws SQLException {

        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), PropertiesUtil.deepCopy(TEST_PROPERTIES)).unwrap(PhoenixConnection.class);

        String query = "select * from t where k='a'";

        PhoenixPreparedStatement pstmt = new PhoenixPreparedStatement(pconn, query);

        QueryPlan plan = pstmt.optimizeQuery();

        Scan scan = plan.getContext().getScan();

        Filter filter = scan.getFilter();

    @Test

    public void testMultiFixedFullPkSalted() throws SQLException {

        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), PropertiesUtil.deepCopy(TEST_PROPERTIES)).unwrap(PhoenixConnection.class);

        String query = "select * from t where k in (1,3)";

        PhoenixPreparedStatement pstmt = new PhoenixPreparedStatement(pconn, query);

        QueryPlan plan = pstmt.optimizeQuery();

        Scan scan = plan.getContext().getScan();

        Filter filter = scan.getFilter();

    public void assertViewType(String[] views, ViewType viewType) throws Exception {

        Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

        PhoenixConnection conn = DriverManager.getConnection(getUrl(), props).unwrap(PhoenixConnection.class);

        String ct = "CREATE TABLE t (k1 INTEGER NOT NULL, k2 VARCHAR, v VARCHAR, CONSTRAINT pk PRIMARY KEY (k1,k2))";

       

        for (String view : views) {

            conn.createStatement().execute(view);

        }