Package com.foundationdb.ais.model

Examples of com.foundationdb.ais.model.FullTextIndex

377
378
379
380
381
382
383
384
385
    public void createFullTextIndex() throws Exception {
        String sql = "CREATE TABLE test.t17 (c1 varchar(1000))";
        executeDDL(sql);
        sql = "CREATE INDEX t17_ft on test.t17 (FULL_TEXT(c1))";
        executeDDL(sql);
        FullTextIndex index = ais().getTable("test", "t17").getFullTextIndex("t17_ft");
        assertNotNull(index);
        assertNull (ais().getTable("test","t17").getIndex("t17_ft"));
    }
View Full Code Here
49
50
51
52
53
54
55
56
        String sql = "CREATE TABLE test.t17 (c1 varchar(1000), INDEX t17_ft (FULL_TEXT(c1)))";
        executeDDL(sql);
        Table table = ais().getTable("test","t17");
        assertNull (table.getIndex("t17_ft"));
        assertEquals (1, table.getFullTextIndexes().size());
        FullTextIndex index = table.getFullTextIndexes().iterator().next();
        assertNotNull (table.getFullTextIndex("t17_ft"));
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
         */

        //CREATE INDEX cust_ft ON customers(FULL_TEXT(name, addresses.state, items.sku))

        // part 1
        FullTextIndex index = createFullTextIndex(
                                                  SCHEMA, "c", "idx_c",
                                                  "name", "i.sku", "a.state");

        RowType rowType = rowType("c");
        Row[] expected1 = new Row[]
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
        ftScanAndCompare(builder, "flintstone", 15, expected3);
    }

    @Test
    public void cDown() throws InterruptedException {
        FullTextIndex index = createFullTextIndex(
                                                  SCHEMA, "c", "idx_c",
                                                  "name", "i.sku", "a.state");
        RowType rowType = rowType("c");
        Row[] expected = new Row[] {
            row(rowType, 1L),
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
        ftScanAndCompare(builder, "state:MA", 10, expected);
    }

    @Test
    public void respondsToDropSchema() throws Exception {
        FullTextIndex index = createFullTextIndex(
                SCHEMA, "c", "idx_c",
                "name", "i.sku", "a.state");
        RowType rowType = rowType("c");
        Row[] expected = new Row[] {
                row(rowType, 1L),
View Full Code Here
200
201
202
203
204
205
206
207
208
209
210
        ftScanAndCompare(builder, "flintstone", 10, expected);
    }

    @Test
    public void oUpDown() throws InterruptedException {
        FullTextIndex index = createFullTextIndex(
                                                  SCHEMA, "o", "idx_o",
                                                  "c.name", "i.sku");
        RowType rowType = rowType("o");
        Row[] expected = new Row[] {
            row(rowType, 1L, 101L)
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
        ftScanAndCompare(builder, "name:Flintstone AND sku:1234", 10, expected);
    }

    @Test
    public void testTruncate() throws InterruptedException {
        FullTextIndex index = createFullTextIndex(SCHEMA, "c", "idx_c", "name", "i.sku", "a.state");

        final int limit = 15;
        RowType rowType = rowType("c");
        String nameQuery = "flintstone";
        Row[] nameExpected = new Row[] { row(rowType, 1L), row(rowType, 3L) };
View Full Code Here
TOP

Related Classes of com.foundationdb.ais.model.FullTextIndex

  • com.foundationdb.server.service.text.FullTextIndexServiceIT
  • com.foundationdb.sql.aisddl.IndexDDLIT
  • com.foundationdb.sql.aisddl.TableDDLFullTextIT
  • com.foundationdb.server.error.IndexColNotInGroupException
  • com.foundationdb.server.error.BranchingGroupIndexException
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.