@Test public void testFilterOnValuesAndFilter() throws Exception { TestMatchFunctionFactory.clear(); assertQuery("a\tb\tk\n" + "11.427984775756228\t\t1970-01-01T00:00:00.000000Z\n" + "32.881769076795045\t\t1970-01-01T01:23:20.000000Z\n" + "12.026122412833129\tHYRX\t1970-01-01T02:30:00.000000Z\n" + "26.922103479744898\t\t1970-01-01T03:03:20.000000Z\n" + "49.00510449885239\tPEHN\t1970-01-01T04:10:00.000000Z\n" + "45.6344569609078\t\t1970-01-01T05:00:00.000000Z\n" + "40.455469747939254\t\t1970-01-01T05:16:40.000000Z\n", "select * from x o where o.b in ('HYRX','PEHN', null) and a < 50 and test_match()", "create table x as (" + "select" + " rnd_double(0)*100 a," + " rnd_symbol(5,4,4,1) b," + " timestamp_sequence(0, 1000000000) k" + " from long_sequence(20)" + ")," + " index(b)", null, "insert into x (a,b)" + " select" + " rnd_double(0)*100," + " rnd_symbol(5,4,4,1)" + " from" + " long_sequence(10)", "a\tb\tk\n" + "11.427984775756228\t\t1970-01-01T00:00:00.000000Z\n" + "32.881769076795045\t\t1970-01-01T01:23:20.000000Z\n" + "12.026122412833129\tHYRX\t1970-01-01T02:30:00.000000Z\n" + "26.922103479744898\t\t1970-01-01T03:03:20.000000Z\n" + "49.00510449885239\tPEHN\t1970-01-01T04:10:00.000000Z\n" + "45.6344569609078\t\t1970-01-01T05:00:00.000000Z\n" + "40.455469747939254\t\t1970-01-01T05:16:40.000000Z\n" + "44.80468966861358\t\t\n"); Assert.assertTrue(TestMatchFunctionFactory.assertAPI()); }
@Override public void clear() { whereClauseParser.clear(); }
SqlCodeGenerator implements Mutable { @Override public void clear() { whereClauseParser.clear(); } }
SqlCodeGenerator implements Mutable { @Override public void clear() { whereClauseParser.clear(); } SqlCodeGenerator(
            CairoEngine engine,
            CairoConfiguration configuration,
            FunctionParser functionParser
    ); }
SqlCodeGenerator implements Mutable { @Override public void clear() { whereClauseParser.clear(); } SqlCodeGenerator(
            CairoEngine engine,
            CairoConfiguration configuration,
            FunctionParser functionParser
    ); @Override void clear(); @NotNull Function compileFilter(ExpressionNode expr, RecordMetadata metadata, SqlExecutionContext executionContext); }
SqlCodeGenerator implements Mutable { @Override public void clear() { whereClauseParser.clear(); } SqlCodeGenerator(
            CairoEngine engine,
            CairoConfiguration configuration,
            FunctionParser functionParser
    ); @Override void clear(); @NotNull Function compileFilter(ExpressionNode expr, RecordMetadata metadata, SqlExecutionContext executionContext); static final int GKK_VANILLA_INT; static final int GKK_HOUR_INT; }