/* This file is part of VoltDB. * Copyright (C) 2008-2017 VoltDB Inc. * * Permission is hereby granted, free of charge, to any person obtaining * a copy of this software and associated documentation files (the * "Software"), to deal in the Software without restriction, including * without limitation the rights to use, copy, modify, merge, publish, * distribute, sublicense, and/or sell copies of the Software, and to * permit persons to whom the Software is furnished to do so, subject to * the following conditions: * * The above copyright notice and this permission notice shall be * included in all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. * IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR * OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR * OTHER DEALINGS IN THE SOFTWARE. */ package schemachange; import org.voltdb.SQLStmt; import org.voltdb.TableHelper; import org.voltdb.VoltProcedure; import org.voltdb.VoltTable; import org.voltdb.VoltType; public class VerifySchemaChangedB extends VoltProcedure { final SQLStmt select = new SQLStmt( "select * from B where pkey >= ? " + "order by pkey limit 100;"); public VoltTable run(long offset, VoltTable data) { voltQueueSQL(select, EXPECT_NON_EMPTY, offset); VoltTable newData = voltExecuteSQL()[0]; StringBuilder sb = new StringBuilder(); boolean same = TableHelper.deepEqualsWithErrorMsg(data, newData, sb); VoltTable retval = new VoltTable( new VoltTable.ColumnInfo("A", VoltType.BIGINT), new VoltTable.ColumnInfo("B", VoltType.STRING)); retval.addRow(same ? 1 : 0, sb.toString()); return retval; } }