Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
 /*
  * Licensed 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
  *
  *     http://www.apache.org/licenses/LICENSE-2.0
  *
  * 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 com.facebook.presto;
import static com.facebook.presto.SessionTestUtils.TEST_SESSION;
import static com.facebook.presto.spi.type.BooleanType.BOOLEAN;
import static com.facebook.presto.spi.type.VarcharType.VARCHAR;
import static org.testng.Assert.assertEquals;
public class TestHiddenColumns
    private LocalQueryRunner runner;
    public TestHiddenColumns()
    {
         = new LocalQueryRunner();
    }
    @AfterClass
    public void destroy()
    {
        if ( != null) {
            .close();
        }
    }
    @Test
    public void testDescribeTable()
            throws Exception
    {
        MaterializedResult expected = MaterializedResult.resultBuilder()
                .row("regionkey""bigint"truefalse"")
                .row("name""varchar"truefalse"")
                .row("comment""varchar"truefalse"")
                .build();
        assertEquals(.execute("DESC REGION"), expected);
    }
    @Test
    public void testSimpleSelect()
            throws Exception
    {
        assertEquals(.execute("SELECT * from REGION"), .execute("SELECT regionkey, name, comment from REGION"));
        assertEquals(.execute("SELECT *, row_number from REGION"), .execute("SELECT regionkey, name, comment, row_number from REGION"));
        assertEquals(.execute("SELECT row_number, * from REGION"), .execute("SELECT row_number, regionkey, name, comment from REGION"));
        assertEquals(.execute("SELECT *, row_number, * from REGION"), .execute("SELECT regionkey, name, comment, row_number, regionkey, name, comment from REGION"));
        assertEquals(.execute("SELECT row_number, x.row_number from REGION x"), .execute("SELECT row_number, row_number from REGION"));
    }
New to GrepCode? Check out our FAQ X