<?xml version="1.0"?>

<sqlgg>
 <stmt name="create_test" sql="create table test ( foo integer not null default 12345 )" category="DDL" kind="create" target="test" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="insert_test_1" sql="insert into test ( foo ) values ( default )" category="DML" kind="insert" target="test" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="select_2" sql="select * from test where foo != default(foo)" category="DQL" kind="select" cardinality="n">
  <in/>
  <out>
   <value name="foo" type="Int"/>
  </out>
 </stmt>
 <stmt name="insert_test_3" sql="insert into test VALUES @@@x" category="DML" kind="insert" target="test" cardinality="0">
  <in>
   <value name="x" type="list(Int)"/>
  </in>
  <out/>
 </stmt>
 <stmt name="insert_test_4" sql="insert into test(foo) VALUES @@@x" category="DML" kind="insert" target="test" cardinality="0">
  <in>
   <value name="x" type="list(Int)"/>
  </in>
  <out/>
 </stmt>
 <stmt name="create_test2" sql="create table test2 ( foo integer not null default 12345, bar text not null default '')" category="DDL" kind="create" target="test2" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="insert_test2_6" sql="insert into test2 VALUES @@@x" category="DML" kind="insert" target="test2" cardinality="0">
  <in>
   <value name="x" type="list(Int, Text)"/>
  </in>
  <out/>
 </stmt>
 <stmt name="insert_test2_7" sql="insert into test2(foo, bar) VALUES @@@x ON DUPLICATE KEY UPDATE bar = @on_collision" category="DML" kind="insert" target="test2" cardinality="0">
  <in>
   <value name="x" type="list(Int, Text)"/>
   <value name="on_collision" type="Text"/>
  </in>
  <out/>
 </stmt>
 <table name="test2">
  <schema>
   <value name="foo" type="Int"/>
   <value name="bar" type="Text"/>
  </schema>
 </table>
 <table name="test">
  <schema>
   <value name="foo" type="Int"/>
  </schema>
 </table>
</sqlgg>
