[
https://issues.apache.org/jira/browse/OFBIZ-7129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15665661#comment-15665661 ]
Paul Foxworthy commented on OFBIZ-7129:
---------------------------------------
I've now checked SQL 99 (
https://mariadb.com/kb/en/sql-99/information_schematables/) and SQL 2011 (Download draft from
http://www.wiscorp.com/sql20nn.zip). The actual SQL standards documents would cost money.
In both cases, the value ought to be "BASE TABLE". It's unfortunate Sun/Oracle didn't say so in their documentation of the getTables method.
Despite the fact my patch is not strictly necessary for MariaDB, I'm inclined to commit it. In future, another database might come along and implement standards-based SQL. Whoever writes a JDBC driver may not be aware that getTables is documented to deliver something different to the standard.
My change will make startup of OFBiz fractionally slower, but mean it accepts the SQL standard value. If there are no objections, I'll commit this in a few days.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)