Ejemplo n.º 1
0
  @Test
  public void testXmlSelect() throws Exception {
    String input = "SELECT col as x, col1 as y from test"; // $NON-NLS-1$
    String output =
        "SELECT XMLSERIALIZE(test.col AS CLOB) AS x, test.col1 AS y FROM test"; //$NON-NLS-1$

    TranslationHelper.helpTestVisitor(
        "create foreign table test (col xml, col1 integer);", input, output, TRANSLATOR);

    input = "SELECT * from test"; // $NON-NLS-1$
    output = "SELECT XMLSERIALIZE(test.col AS CLOB), test.col1 FROM test"; // $NON-NLS-1$

    TranslationHelper.helpTestVisitor(
        "create foreign table test (col xml, col1 integer);", input, output, TRANSLATOR);
  }
Ejemplo n.º 2
0
  @Test
  public void testSelectWithNoFrom() throws Exception {
    String input = "select 1, 2"; // $NON-NLS-1$
    String output = "VALUES(1, 2)"; // $NON-NLS-1$

    TranslationHelper.helpTestVisitor(TranslationHelper.BQT_VDB, input, output, TRANSLATOR);
  }
Ejemplo n.º 3
0
  @Test
  public void testConcat_useLiteral() throws Exception {
    String input = "select concat(stringnum,'_xx') from BQT1.Smalla"; // $NON-NLS-1$
    String output = "SELECT {fn concat(SmallA.StringNum, '_xx')} FROM SmallA"; // $NON-NLS-1$

    TranslationHelper.helpTestVisitor(TranslationHelper.BQT_VDB, input, output, TRANSLATOR);
  }
Ejemplo n.º 4
0
  @Test
  public void testConcat2() throws Exception {
    String input = "select concat2(stringnum, stringnum) from BQT1.Smalla"; // $NON-NLS-1$
    String output =
        "SELECT CASE WHEN SmallA.StringNum IS NULL AND SmallA.StringNum IS NULL THEN NULL ELSE {fn concat(coalesce(SmallA.StringNum, ''), coalesce(SmallA.StringNum, ''))} END FROM SmallA"; //$NON-NLS-1$

    TranslationHelper.helpTestVisitor(TranslationHelper.BQT_VDB, input, output, TRANSLATOR);
  }
Ejemplo n.º 5
0
  @Test
  public void testOffset() throws Exception {
    String input = "select intkey from bqt1.smalla limit 50, 100"; // $NON-NLS-1$
    String output =
        "SELECT SmallA.IntKey FROM SmallA OFFSET 50 ROWS FETCH FIRST 100 ROWS ONLY"; //$NON-NLS-1$

    TranslationHelper.helpTestVisitor(TranslationHelper.BQT_VDB, input, output, TRANSLATOR);
  }
Ejemplo n.º 6
0
 @Test
 public void testTempTable() throws Exception {
   assertEquals(
       "declare global temporary table foo (COL1 integer, COL2 varchar(100)) not logged",
       TranslationHelper.helpTestTempTable(TRANSLATOR, true));
 }