Package com.foundationdb.sql.types

Examples of com.foundationdb.sql.types.DataTypeDescriptor

138
139
140
141
142
143
144
145
    @Override
    protected DataTypeDescriptor dataTypeDescriptor(TInstance type) {
        int precision = type.attribute(DecimalAttribute.PRECISION);
        int scale = type.attribute(DecimalAttribute.SCALE);
        return new DataTypeDescriptor(TypeId.DECIMAL_ID, precision, scale, type.nullability(),
                DataTypeDescriptor.computeMaxWidth(precision, scale));
    }
View Full Code Here
35
36
37
38
39
40
41
    }

    @Override
    protected DataTypeDescriptor dataTypeDescriptor(TInstance type) {
        boolean isNullable = type.nullability(); // on separate line to make NPE easier to catch
        return new DataTypeDescriptor(typeId, isNullable);
    }
View Full Code Here
213
214
215
216
217
218
219
220
221
        String sql = "CREATE TABLE t1 (column1, column2, column3) AS (SELECT c1, c2, c3 FROM t2) WITH NO DATA";
        createTableAsColumnGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("c1", "c2", "c3");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d,d);
        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
226
227
228
229
230
231
232
233
234
235
        String sql = "CREATE TABLE t1 (column1, column2, column3) AS (SELECT * FROM t2) WITH NO DATA";
        createTableAsColumnGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("c1", "c2", "c3");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d,d);

        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
240
241
242
243
244
245
246
247
248
        String sql = "CREATE TABLE t1 AS (SELECT c1, c2, c3 FROM t2) WITH NO DATA";
        createTableAsCGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("c1", "c2", "c3");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d,d);
        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
253
254
255
256
257
258
259
260
261
        String sql = "CREATE TABLE t1 AS (SELECT * FROM t2) WITH  NO DATA";
        createTableAsCGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("c1", "c2", "c3");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d,d);
        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
266
267
268
269
270
271
272
273
274
        String sql = "CREATE TABLE t1 (c1, c2) AS (SELECT column1, column2, column3 FROM t2) WITH NO DATA";
        createTableAsMixGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("column1", "column2", "column3");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d,d);
        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
279
280
281
282
283
284
285
286
287
        String sql = "CREATE TABLE t1 (c1, c2, c3) AS (SELECT column1, column2 FROM t2) WITH NO DATA";
        createTableAsMixGenerateAIS();
        StatementNode stmt = parser.parseStatement(sql);
        assertTrue (stmt instanceof CreateTableNode);
        List<String> columnNames = Arrays.asList("column1", "column2");
        DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
        List<DataTypeDescriptor> descriptors = Arrays.asList(d,d);
        TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
    }
View Full Code Here
TOP

Related Classes of com.foundationdb.sql.types.DataTypeDescriptor

  • com.foundationdb.server.test.mt.OnlineCreateTableAsCastedMT
  • com.foundationdb.server.test.mt.OnlineCreateTableAsMT
  • com.foundationdb.server.test.mt.OnlineCreateTableAsOtherMT
  • com.foundationdb.server.types.aksql.aktypes.AkInterval
  • com.foundationdb.server.types.aksql.aktypes.AkResultSet
  • com.foundationdb.server.types.common.types.SimpleDtdTClass
  • com.foundationdb.server.types.common.types.TBigDecimal
  • com.foundationdb.server.types.common.types.TBinary
  • com.foundationdb.server.types.common.types.TString
  • com.foundationdb.sql.aisddl.TableDDL
    • 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.