public void setColumns(List<XMLColumn> columns) { if (columns.isEmpty()) { usingDefaultColumn = true; columns.add(new XMLColumn("OBJECT_VALUE", DataTypeManager.DefaultDataTypes.XML, ".", null)); //$NON-NLS-1$ //$NON-NLS-2$ } this.columns = columns; }
public void setColumns(List<XMLColumn> columns) { if (columns.isEmpty()) { usingDefaultColumn = true; columns.add(new XMLColumn("OBJECT_VALUE", DataTypeManager.DefaultDataTypes.XML, ".", null)); //$NON-NLS-1$ //$NON-NLS-2$ } this.columns = columns; }
public void setColumns(List<XMLColumn> columns) { if (columns.isEmpty()) { usingDefaultColumn = true; columns.add(new XMLColumn("OBJECT_VALUE", DataTypeManager.DefaultDataTypes.XML, ".", null)); //$NON-NLS-1$ //$NON-NLS-2$ } this.columns = columns; }
jj_consume_token(FOR); jj_consume_token(ORDINALITY); {if (true) return new XMLTable.XMLColumn(name);} break; case STRING: {if (true) return new XMLTable.XMLColumn(name, datatype.type, path, defaultExpr);} break; default:
jj_consume_token(FOR); jj_consume_token(ORDINALITY); {if (true) return new XMLTable.XMLColumn(name);} break; case STRING: {if (true) return new XMLTable.XMLColumn(name, datatype.type, path, defaultExpr);} break; default:
jj_consume_token(FOR); jj_consume_token(ORDINALITY); {if (true) return new XMLTable.XMLColumn(name);} break; case STRING: {if (true) return new XMLTable.XMLColumn(name, datatype.type, path, defaultExpr);} break; default:
@Test public void testXMLTable() throws Exception { String sql = "SELECT * from xmltable(xmlnamespaces(no default), '/' columns x for ordinality, y date default {d'2000-01-01'} path '@date') as x"; //$NON-NLS-1$ Query query = new Query(); query.setSelect(new Select(Arrays.asList(new MultipleElementSymbol()))); XMLTable xt = new XMLTable(); xt.setName("x"); xt.setNamespaces(new XMLNamespaces(Arrays.asList(new XMLNamespaces.NamespaceItem()))); xt.setXquery("/"); List<XMLTable.XMLColumn> columns = new ArrayList<XMLTable.XMLColumn>(); columns.add(new XMLTable.XMLColumn("x")); columns.add(new XMLTable.XMLColumn("y", "date", "@date", new Constant(Date.valueOf("2000-01-01")))); xt.setColumns(columns); query.setFrom(new From(Arrays.asList(xt))); helpTest(sql, "SELECT * FROM XMLTABLE(XMLNAMESPACES(NO DEFAULT), '/' COLUMNS x FOR ORDINALITY, y date DEFAULT {d'2000-01-01'} PATH '@date') AS x", query); }
@Override public XMLColumn clone() { XMLColumn clone = new XMLColumn(); super.copyTo(clone); clone.ordinal = this.ordinal; clone.path = this.path; if (this.defaultExpression != null) { clone.defaultExpression = (Expression)this.defaultExpression.clone(); } clone.pathExpression = this.pathExpression; return clone; } }
@Override public XMLColumn clone() { XMLColumn clone = new XMLColumn(); super.copyTo(clone); clone.ordinal = this.ordinal; clone.path = this.path; if (this.defaultExpression != null) { clone.defaultExpression = (Expression)this.defaultExpression.clone(); } return clone; } }
@Override public XMLColumn clone() { XMLColumn clone = new XMLColumn(); super.copyTo(clone); clone.ordinal = this.ordinal; clone.path = this.path; if (this.defaultExpression != null) { clone.defaultExpression = (Expression)this.defaultExpression.clone(); } return clone; } }