<?xml version="1.0" encoding="UTF-8"?>
<root>

<!--  * =====================================================================*   -->
<!--  *    Testing simple transactions                     *   -->
<!--  * =====================================================================* -->

<query name="TestQuery1">select * from pm1.g1 order by e1
</query>

<query name="TestQuery2">select * from pm1.g2 where e1 >= 0 order by e1</query>
<query name="TestQuery3">select * from pm2.g1 where e1 >= 0 order by e1</query>
<query name="TestQuery4">select * from pm2.g2 where e1 >= 0 order by e1</query>


<query name="TestQuery5">
	<sql updatecnt="1">insert into pm1.g1 (e1, e2) values(?, ?)      
		<parm type="integer">1000</parm>
		<parm type="string">'1000'</parm>
	</sql>
	<sql>select * from pm1.g1 where e1 = 1000</sql>
</query>

<query name="TestQuery6">
	<sql updatecnt="1">insert into pm1.g1 (e1, e2) values(?, ?)      
		<parm type="integer">1000</parm>
		<parm type="string">'1000'</parm>
	</sql>
	<sql updatecnt="1">update pm1.g1 set e2='blah' where e1 = ?
		<parm type="integer">1000</parm>
	</sql>
	<sql>select * from pm1.g1 where e2 = 'blah'</sql>
</query>


<query name="TestQuery7">
	<sql updatecnt="1">insert into pm1.g1 (e1, e2) values(?, ?)      
		<parm type="integer">1000</parm>
		<parm type="string">'1000'</parm>
	</sql>
	<sql rowCount="1">select * from pm1.g1 where e1 = 1000</sql>
	<sql updatecnt="1">delete from pm1.g1 where pm1.g1.e1 = 1000</sql>
	<sql>select * from pm1.g1 where e1 > 999</sql>
</query>

<query name="TestQuery8">
	<sql updatecnt="1">insert into pm1.g1 (e1, e2) values(?, ?)      
		<parm type="integer">1100</parm>
		<parm type="string">'1100'</parm>
	</sql>
	<sql updatecnt="1">insert into pm1.g2 (e1, e2) values(?, ?)      
		<parm type="integer">1100</parm>
		<parm type="string">'1100'</parm>
	</sql>

	<sql rowCount="1">select a.* from pm1.g1 as a, pm1.g2 as b where a.e1 = 1100 and a.e1=b.e1</sql>   

</query>


</root>

