package org.reldb.rel.tests.main;
import org.junit.After;
import org.junit.Test;
import org.reldb.rel.tests.BaseOfTest;
import org.reldb.rel.v0.values.*;
public class TestCase3 extends BaseOfTest {
@Test
public void testCase3() {
String src =
"BEGIN;" +
"OPERATOR caseTest(p integer) RETURNS integer;" +
" RETURN CASE " +
" WHEN p = 1 THEN 1 " +
" ELSE 4" +
" END CASE; " +
"END OPERATOR;" +
"END;" +
"caseTest(1)";
assertValueEquals(ValueInteger.select(generator, 1), testEvaluate(src).getValue());
}
@After
public void testCase3_cleanup() {
String src =
"BEGIN;" +
" DROP OPERATOR caseTest(integer);" +
"END;" +
"true";
assertValueEquals(ValueBoolean.select(generator, true), testEvaluate(src).getValue());
}
}