<?xml version="1.0"?>

<sqlgg>
 <stmt name="create_table_files" sql="CREATE TABLE `%%tablename%%` (&#x0A;  first_key varbinary(30000) NOT NULL DEFAULT ''&#x0A;) ENGINE=INNODB" category="DDL" kind="create" target="%%tablename%%" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="by_prefix" sql="select *&#x0A;  from `%%tablename%%`&#x0A; where 'k' &lt; first_key or first_key like concat(@k,'%')" category="DQL" kind="select" cardinality="n">
  <in>
   <value name="k" type="Text"/>
  </in>
  <out>
   <value name="first_key" type="Text"/>
  </out>
 </stmt>
 <stmt name="create_foo" sql="CREATE TABLE foo ( x decimal(10,2) )" category="DDL" kind="create" target="foo" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="insert_foo_3" sql="INSERT INTO foo ( x ) VALUES (@x)" category="DML" kind="insert" target="foo" cardinality="0">
  <in>
   <value name="x" type="Decimal" nullable="true"/>
  </in>
  <out/>
 </stmt>
 <stmt name="select_4" sql="SELECT x FROM foo" category="DQL" kind="select" cardinality="n">
  <in/>
  <out>
   <value name="x" type="Decimal" nullable="true"/>
  </out>
 </stmt>
 <stmt name="select_5" sql="SELECT SUM(x) FROM foo WHERE x &lt; @n" category="DQL" kind="select" cardinality="1">
  <in>
   <value name="n" type="Decimal"/>
  </in>
  <out>
   <value name="_0" type="Decimal" nullable="true"/>
  </out>
 </stmt>
 <stmt name="insert_foo_6" sql="insert into foo ( x ) values ( cast(1.2 as decimal) ), ( 100 )" category="DML" kind="insert" target="foo" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <table name="foo">
  <schema>
   <value name="x" type="Decimal" nullable="true"/>
  </schema>
 </table>
 <table name="%%tablename%%">
  <schema>
   <value name="first_key" type="Text"/>
  </schema>
 </table>
</sqlgg>
