Author: jgbutler
Date: Tue Jun 23 16:35:17 2009
New Revision: 787748
URL: http://svn.apache.org/viewvc?rev=787748&view=rev
Log:
Fix SQL error on a submitted test
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/CreateDB.sql
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/DynSql.xml
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/CreateDB.sql
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/CreateDB.sql?rev=787748&r1=787747&r2=787748&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/CreateDB.sql
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/CreateDB.sql
Tue Jun 23 16:35:17 2009
@@ -1,12 +1,13 @@
+create schema ibtest authorization dba;
-create table names (
+create table ibtest.names (
id int,
description varchar(20)
);
-insert into names (id, description) values(1, 'Fred');
-insert into names (id, description) values(2, 'Wilma');
-insert into names (id, description) values(3, 'Pebbles');
-insert into names (id, description) values(4, 'Barney');
-insert into names (id, description) values(5, 'Betty');
-insert into names (id, description) values(6, 'Bamm Bamm');
+insert into ibtest.names (id, description) values(1, 'Fred');
+insert into ibtest.names (id, description) values(2, 'Wilma');
+insert into ibtest.names (id, description) values(3, 'Pebbles');
+insert into ibtest.names (id, description) values(4, 'Barney');
+insert into ibtest.names (id, description) values(5, 'Betty');
+insert into ibtest.names (id, description) values(6, 'Bamm Bamm');
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/DynSql.xml
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/DynSql.xml?rev=787748&r1=787747&r2=787748&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/DynSql.xml
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/submitted/dynsql/DynSql.xml
Tue Jun 23 16:35:17 2009
@@ -5,7 +5,7 @@
<if test="enabled">
<foreach collection="ids" item="id" separator="union">
<if test="schema != null">
- select * from names where id = #{id}
+ select * from ${schema}.names where id = #{id}
</if>
</foreach>
</if>
@@ -13,7 +13,7 @@
<select id="select_simple"
parameterType="org.apache.ibatis.submitted.dynsql.Parameter" resultType="map">
<foreach collection="ids" index="index" item="id" separator="union">
- select * from names where id = #{id}
+ select * from ${schema}.names where id = #{id}
</foreach>
</select>
</mapper>
\ No newline at end of file
