xmlschema03 query tag table prefix bugs

[peterdd]

• Fails setting table prefix when no space between mytable and '(': (fix regexp)

<query>insert into mytable(field1,field2) values(1,2)</query>

• no table prefix for multiline queries: (probably add missing 'm' multiline regexp option)

<query>insert into mytable
(field1,field2)
values(1,2)
</query>

• update query regexp for table prefix completely wrong: (probably copy-paste error from the delete table regexp)

<query>update mytable set field2=4 where field1=1</query>

More details and example or PR will follow.

[dregad]

@peterdd what is the status of this issue ? Are you planning to submit a PR or additional information as mentioned in your initial posting ?

[peterdd]

No progress there. I stopped after finding the third simple issue within <query> section of xmlschema03 in a short time and stick to the use of queries that work at current(5.21.0 in my case) state. flyspray/flyspray@ade01ed

More important issue is that it data-dict for postgres is not working with xmlschema03 and have to patch 5.21.0 on install. flyspray/flyspray@44af76c
(related #11, #73, #383, #124, #125)

[mnewnham]

@peterdd . I have re-tested the issues described above, using MySQL and SQLite. I cannot see any errors generated. This is my xmlschema

<?xml version="1.0"?>
<schema version="0.3">
  <table name="xml_users">
    <descr>A typical users table for our application.</descr> 
    <field name="userId" type="I">
      <descr>A unique ID assigned to each user.</descr>
      <KEY/>
      <AUTOINCREMENT/>
    </field> 
    <field name="userName" type="C" size="16">
        <NOTNULL/>
    </field>
    <index name="userName">
      <descr>Put a unique index on the user name</descr>
      <col>userName</col>
     
    </index>
  </table>
  <sql>
    <descr>Insert some data into the users table.</descr>
    <query>insert into employees.xml_users 
           (userName) 
           values ( 'admin' )
     </query>
    <query>insert into employees.xml_users(userName) values ( 'Joe' )</query>
  </sql>
</schema>

I believe the XML above should address the issues raised above:

1. Issue with multi-line SQL queries
2. Issue where schema is attached to table name

Is there still a problem here? perhaps the issue has been fixed by other changes.

[mnewnham]

As there has been no further discussion on this I am closing it as not reproducible