Hi Neil, On 1/12/07, Neil Aggarwal <[EMAIL PROTECTED]> wrote:
As you can see, the SQL being passed to Sequioa is in uppercase letters, why would Sequoia be looking for the same table name in lowercase letters?
In the database schema, tables are stored lowercase so it's normal for Sequoia to look for a lowercase pattern. IMHO, the problem is that Sequoia is looking for `yourtable` in the schema and I'm pretty sure that when getting the schema from your database, Sequoia got yourtable (without the enclosing `) and so stored yourtable in the schema. I don't remember if ` is standard per SQL spec but if it is, the regexps to get the tables from a query should probably be updated to take it into account. Thoughts? -- Guillaume _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
