db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From krist...@apache.org
Subject svn commit: r674451 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/case.out tests/lang/MixedCaseExpressionTest.java tests/lang/_Suite.java tests/lang/case.sql
Date Mon, 07 Jul 2008 11:14:05 GMT
Author: kristwaa
Date: Mon Jul  7 04:14:05 2008
New Revision: 674451

URL: http://svn.apache.org/viewvc?rev=674451&view=rev
Log:
DERBY-3751: Convert case.sql to junit.
Patch file: derby-3751-2-patch.txt

Patch contributed by Junjie Peng.

Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java
  (with props)
Removed:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/case.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/case.sql
Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java?rev=674451&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java
Mon Jul  7 04:14:05 2008
@@ -0,0 +1,74 @@
+/**
+ *  Derby - Class org.apache.derbyTesting.functionTests.tests.lang.MixedCaseExpressionTest
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.derbyTesting.functionTests.tests.lang;
+
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import junit.framework.Test;
+
+import org.apache.derbyTesting.junit.BaseJDBCTestCase;
+import org.apache.derbyTesting.junit.JDBC;
+import org.apache.derbyTesting.junit.TestConfiguration;
+
+/**
+ *Test case for case.sql.
+ */
+public class MixedCaseExpressionTest extends BaseJDBCTestCase {
+
+    public MixedCaseExpressionTest(String name) {
+        super(name);
+    }
+
+    public static Test suite(){
+        return TestConfiguration.defaultSuite(MixedCaseExpressionTest.class);
+    }
+
+    /**
+     *  This test is for keyword case insensitivity.
+     * @throws SQLException
+     */
+    public void testKeywordsWithMixedCase() throws SQLException{
+        Statement st = createStatement();
+
+        String sql = "cReAtE tAbLe T (x InT)";
+        st.executeUpdate(sql);
+
+        sql = "CrEaTe TaBlE s (X iNt)";
+        st.executeUpdate(sql);
+
+        sql = "iNsErT iNtO t VaLuEs (1)";
+        assertEquals("Mistake in inserting table", 1, st.executeUpdate(sql));
+
+        sql = "InSeRt InTo S vAlUeS (2)";
+        assertEquals("Mistake in inserting table", 1, st.executeUpdate(sql));
+
+        sql = "sElEcT * fRoM t";
+        JDBC.assertSingleValueResultSet(st.executeQuery(sql), "1");
+
+        sql = "SeLeCt * FrOm s";
+        JDBC.assertSingleValueResultSet(st.executeQuery(sql), "2");
+
+        dropTable("s");
+
+        dropTable("t");
+    }
+}

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/MixedCaseExpressionTest.java
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java?rev=674451&r1=674450&r2=674451&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
Mon Jul  7 04:14:05 2008
@@ -167,6 +167,7 @@
         }
         
         suite.addTest(BigDataTest.suite());
+        suite.addTest(MixedCaseExpressionTest.suite());
 
         return suite;
 	}



Mime
View raw message