<commit_before>package org.apache.derby.impl.sql.execute.operations;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.log4j.Logger;
import org.junit.AfterClass;
import org.junit.Assert;
import org.junit.BeforeClass;
import org.junit.Test;

import com.splicemachine.derby.test.SpliceNetDerbyTest;

//public class CallStatementOperationTest extends SpliceDerbyTest {
public class CallStatementOperationTest extends SpliceNetDerbyTest {
	private static Logger LOG = Logger.getLogger(CallStatementOperationTest.class);
	
	@BeforeClass 
	public static void startup() throws SQLException {
		startConnection();	
	} 


	@Test
	public void testCallSysSchemas() throws SQLException {
		LOG.info("start testCallStatement");
		Statement s = null;
		ResultSet result = null;
		try {
			CallableStatement cs = conn.prepareCall("CALL SYSIBM.SQLTABLES('', '', '', '', 'GETSCHEMAS=1')");
			//CallableStatement cs = conn.prepareCall("CALL SYSIBM.METADATA()");
			result = cs.executeQuery();
			
			//s = conn.createStatement();
			//result = s.executeQuery("SELECT SCHEMANAME AS TABLE_SCHEM, CAST(NULL AS VARCHAR(128)) AS TABLE_CATALOG FROM SYS.SYSSCHEMAS WHERE SCHEMANAME LIKE '%' ORDER BY TABLE_SCHEM");
			
			int count = 0;
			while (result.next()) {
				LOG.info("c1="+result.getString(1)+",c2="+result.getString(2));
				Assert.assertTrue(result.getBoolean(1));
				count++;
			}
			Assert.assertEquals(1, count);
		} catch (SQLException e) {
			LOG.error("error in testAggregatedDeleteExt-"+e.getMessage(), e);
		} finally {<commit_msg>added client-server test cases<commit_after>package org.apache.derby.impl.sql.execute.operations;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.log4j.Logger;
import org.junit.AfterClass;
import org.junit.Assert;
import org.junit.BeforeClass;
import org.junit.Test;

import com.splicemachine.derby.test.SpliceNetDerbyTest;

//public class CallStatementOperationTest extends SpliceDerbyTest {
public class CallStatementOperationTest extends SpliceNetDerbyTest {
	private static Logger LOG = Logger.getLogger(CallStatementOperationTest.class);
	
	@BeforeClass 
	public static void startup() throws SQLException {
		startConnection();	
	} 


	@Test
	public void testCallSysSchemas() throws SQLException {
		LOG.info("start testCallStatement");
		Statement s = null;
		ResultSet result = null;
		try {
			CallableStatement cs = conn.prepareCall("CALL SYSIBM.SQLTABLES('', '', '', '', 'GETSCHEMAS=1')");
			//CallableStatement cs = conn.prepareCall("CALL SYSIBM.METADATA()");
			result = cs.executeQuery();
			
			//s = conn.createStatement();
			//result = s.executeQuery("SELECT SCHEMANAME AS TABLE_SCHEM, CAST(NULL AS VARCHAR(128)) AS TABLE_CATALOG FROM SYS.SYSSCHEMAS WHERE SCHEMANAME LIKE '%' ORDER BY TABLE_SCHEM");
			
			int count = 0;
			while (result.next()) {
				LOG.info("c1="+result.getString(1)+",c2="+result.getString(2));
				Assert.assertTrue(result.getBoolean(1));
				count++;
			}
			Assert.assertEquals(11, count);
		} catch (SQLException e) {
			LOG.error("error in testAggregatedDeleteExt-"+e.getMessage(), e);
		} finally {
{'fraction_non_alphanumeric': 0.12638376383763839, 'fraction_numerical': 0.007687576875768758, 'mean_word_length': 4.925318761384335, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1571859', 'n_tokens_mistral': 1129, 'n_tokens_neox': 1017, 'n_words': 221}