private Mode getMode(CreateProcedureCommand parentProcCommand, CommandStatement cmdStmt, Command command) { if (!command.returnsResultSet()&&!(command instanceof StoredProcedure)) { return Mode.UPDATE; } if (parentProcCommand.returnsResultSet()&&cmdStmt.isReturnable()&&cmdStmt.getCommand().returnsResultSet()) { return Mode.HOLD; } return Mode.NOHOLD; }
private Mode getMode(CreateProcedureCommand parentProcCommand, CommandStatement cmdStmt, Command command) { if (!command.returnsResultSet()&&!(command instanceof StoredProcedure)) { return Mode.UPDATE; } if (parentProcCommand.returnsResultSet()&&cmdStmt.isReturnable()&&cmdStmt.getCommand().returnsResultSet()) { return Mode.HOLD; } return Mode.NOHOLD; }
private Mode getMode(CreateProcedureCommand parentProcCommand, CommandStatement cmdStmt, Command command) { if (!command.returnsResultSet()&&!(command instanceof StoredProcedure)) { return Mode.UPDATE; } if (parentProcCommand.returnsResultSet()&&cmdStmt.isReturnable()&&cmdStmt.getCommand().returnsResultSet()) { return Mode.HOLD; } return Mode.NOHOLD; }
public void visit(CommandStatement obj) { if (!obj.isReturnable() || obj.getCommand() instanceof DynamicCommand || !obj.getCommand().returnsResultSet()) { return; } for (int i = 0; i < proc.getResultSet().getColumns().size(); i++) { Column c = proc.getResultSet().getColumns().get(i); LinkedHashSet<AbstractMetadataRecord> columnValues = null; if (c.getIncomingObjects() instanceof LinkedHashSet) { columnValues = (LinkedHashSet<AbstractMetadataRecord>) c.getIncomingObjects(); } else { columnValues = new LinkedHashSet<>(); c.setIncomingObjects(columnValues); } determineDependencies(obj.getCommand(), c, i, columnValues); } } });
public void visit(CommandStatement obj) { if (!obj.isReturnable() || obj.getCommand() instanceof DynamicCommand || !obj.getCommand().returnsResultSet()) { return; } for (int i = 0; i < proc.getResultSet().getColumns().size(); i++) { Column c = proc.getResultSet().getColumns().get(i); LinkedHashSet<AbstractMetadataRecord> columnValues = null; if (c.getIncomingObjects() instanceof LinkedHashSet) { columnValues = (LinkedHashSet<AbstractMetadataRecord>) c.getIncomingObjects(); } else { columnValues = new LinkedHashSet<>(); c.setIncomingObjects(columnValues); } determineDependencies(obj.getCommand(), c, i, columnValues); } } });
@Override public void visit( CommandStatement obj ) { visitNode(obj.getCommand()); if (!obj.isReturnable()) { append(SPACE); append(WITHOUT); append(SPACE); append(RETURN); } append(";"); //$NON-NLS-1$ }
@Override public void visit( CommandStatement obj ) { visitNode(obj.getCommand()); if (!obj.isReturnable()) { append(SPACE); append(WITHOUT); append(SPACE); append(RETURN); } append(";"); //$NON-NLS-1$ }
@Override public void visit( CommandStatement obj ) { visitNode(obj.getCommand()); if (!obj.isReturnable()) { append(SPACE); append(WITHOUT); append(SPACE); append(RETURN); } append(";"); //$NON-NLS-1$ }
@Override public void visit(CommandStatement obj) { if (this.createProc == null || this.createProc.getResultSetColumns().isEmpty() || !obj.isReturnable() || !obj.getCommand().returnsResultSet()) { return; } List<? extends Expression> symbols = obj.getCommand().getResultSetColumns(); if (symbols == null && obj.getCommand() instanceof DynamicCommand) { DynamicCommand cmd = (DynamicCommand)obj.getCommand(); cmd.setAsColumns(this.createProc.getResultSetColumns()); return; } try { QueryResolver.validateProjectedSymbols(createProc.getVirtualGroup(), createProc.getResultSetColumns(), symbols); } catch (QueryValidatorException e) { handleValidationError(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31121, createProc.getVirtualGroup(), obj, e.getMessage()), obj); } }
@Override public void visit(CommandStatement obj) { if (this.createProc == null || this.createProc.getResultSetColumns().isEmpty() || !obj.isReturnable() || !obj.getCommand().returnsResultSet()) { return; } List<? extends Expression> symbols = obj.getCommand().getResultSetColumns(); if (symbols == null && obj.getCommand() instanceof DynamicCommand) { DynamicCommand cmd = (DynamicCommand)obj.getCommand(); cmd.setAsColumns(this.createProc.getResultSetColumns()); return; } try { QueryResolver.validateProjectedSymbols(createProc.getVirtualGroup(), createProc.getResultSetColumns(), symbols); } catch (QueryValidatorException e) { handleValidationError(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31121, createProc.getVirtualGroup(), obj, e.getMessage()), obj); } }
@Override public void visit(CommandStatement obj) { if (this.createProc == null || this.createProc.getResultSetColumns().isEmpty() || !obj.isReturnable() || !obj.getCommand().returnsResultSet()) { return; } List<? extends Expression> symbols = obj.getCommand().getResultSetColumns(); if (symbols == null && obj.getCommand() instanceof DynamicCommand) { DynamicCommand cmd = (DynamicCommand)obj.getCommand(); cmd.setAsColumns(this.createProc.getResultSetColumns()); return; } try { QueryResolver.validateProjectedSymbols(createProc.getVirtualGroup(), createProc.getResultSetColumns(), symbols); } catch (QueryValidatorException e) { handleValidationError(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31121, createProc.getVirtualGroup(), obj, e.getMessage()), obj); } }
instruction = new ExecDynamicSqlInstruction(parentProcCommand,((DynamicCommand)command), metadata, idGenerator, capFinder, ((DynamicCommand)command).getIntoGroup() == null && cmdStmt.isReturnable() && parentProcCommand.returnsResultSet()); }else{ CreateCursorResultSetInstruction cursor = new CreateCursorResultSetInstruction(null, commandPlan, getMode(parentProcCommand, cmdStmt, command));
instruction = new ExecDynamicSqlInstruction(parentProcCommand,((DynamicCommand)command), metadata, idGenerator, capFinder, ((DynamicCommand)command).getIntoGroup() == null && cmdStmt.isReturnable() && parentProcCommand.returnsResultSet()); }else{ CreateCursorResultSetInstruction cursor = new CreateCursorResultSetInstruction(null, commandPlan, getMode(parentProcCommand, cmdStmt, command));
instruction = new ExecDynamicSqlInstruction(parentProcCommand,((DynamicCommand)command), metadata, idGenerator, capFinder, ((DynamicCommand)command).getIntoGroup() == null && cmdStmt.isReturnable() && parentProcCommand.returnsResultSet()); }else{ CreateCursorResultSetInstruction cursor = new CreateCursorResultSetInstruction(null, commandPlan, getMode(parentProcCommand, cmdStmt, command));
if ((command.getResultSetColumns() != null && command.getResultSetColumns().isEmpty()) || !cmdStmt.isReturnable() || command.getResultSetColumns() == null) { if (command.getResultSetColumns() == null && cmdStmt.isReturnable() && subCommand.returnsResultSet() && subCommand.getResultSetColumns() != null && !subCommand.getResultSetColumns().isEmpty()) { command.setResultSetColumns(subCommand.getResultSetColumns()); if (command.getProjectedSymbols().isEmpty()) {
if ((command.getResultSetColumns() != null && command.getResultSetColumns().isEmpty()) || !cmdStmt.isReturnable() || command.getResultSetColumns() == null) { if (command.getResultSetColumns() == null && cmdStmt.isReturnable() && subCommand.returnsResultSet() && subCommand.getResultSetColumns() != null && !subCommand.getResultSetColumns().isEmpty()) { command.setResultSetColumns(subCommand.getResultSetColumns()); if (command.getProjectedSymbols().isEmpty()) {
if ((command.getResultSetColumns() != null && command.getResultSetColumns().isEmpty()) || !cmdStmt.isReturnable() || command.getResultSetColumns() == null) { if (command.getResultSetColumns() == null && cmdStmt.isReturnable() && subCommand.returnsResultSet() && subCommand.getResultSetColumns() != null && !subCommand.getResultSetColumns().isEmpty()) { command.setResultSetColumns(subCommand.getResultSetColumns()); if (command.getProjectedSymbols().isEmpty()) {