@Test
  public void exceptionTest() {
    String errMsg =
        TSStatusCode.SEMANTIC_ERROR.getStatusCode() + ": " + "Unsupported Join creteria";
    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.num>t1.num", errMsg, DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.num!=t1.num", errMsg, DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.device=t1.device AND t0.num>t1.num",
        errMsg,
        DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.device=t1.device OR t0.num>t1.num",
        errMsg,
        DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.device=t1.device OR t0.time=t1.time",
        errMsg,
        DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 full join table1 t1 on t0.time=4000", errMsg, DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 left join table1 t1 on t0.time=4000", errMsg, DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 t0 right join table1 t1 on t0.time=4000", errMsg, DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 asof (tolerance 1s) left join table1 on table0.time<=table1.time",
        "Tolerance in ASOF JOIN only supports INNER type now",
        DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 asof right join table1 on table0.time<=table1.time",
        "ASOF JOIN does not support RIGHT type now",
        DATABASE_NAME);

    tableAssertTestFail(
        "select * from table0 asof full join table1 on table0.time<=table1.time",
        "ASOF JOIN does not support FULL type now",
        DATABASE_NAME);
  }
In this IT, table has more than one TAGs and Attributes.
integration-test/src/test/java/org/apache/iotdb/relational/it/db/it/IoTDBMultiTAGsWithAttributesTableIT.java