To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105872
------- Additional comments from [email protected] Thu Oct 22 11:43:26 +0000 2009 ------- By comparing server-reported trace messages for HSQL 1.8 and 1.9 (and results of queries thusly obtained) while I performed identical actions in OpenOffice, I have found one difference which *might* cause failures like I observe. I have NOT ascertained that the difference I observe is the actual cause of failure. Neither have I yet ascertained whether this difference is by design, or would be considered a bug by HSQL developers. I only asked about it about an hour ago, at: http://sourceforge.net/tracker/?func=detail&aid=2883838&group_id=23316&atid=378131 I notice that at some point during either form creation or opening a form to display data, or attempting to apply a filter, OpenOffice performs the following queries (they look a little bit different for 1.8 and 1.9, but the data queried are the same): 1.8: SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE 1=1 AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'PRODUCT' AND COLUMN_NAME LIKE '%' 1.9: SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'PRODUCT' AND COLUMN_NAME LIKE '%' Result columns differ more significantly, however, since on 1.9: - COLUMN_SIZE appears for integer columns. - BUFFER_LENGTH disappears for all columns. - DECIMAL_DIGITS value appears for integer columns. - NUM_PREC_RADIX changes for integer columns. - CHAR_OCTET_LENGTH appears with a value of 0 for integer columns. - TYPE_SUB column changes position. Raw result data from 1.8 look like this: TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SCOPE_CATLOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE TYPE_SUB --------- ----------- ---------- ----------- --------- --------- ----------- ------------- -------------- -------------- -------- ------- ---------- ------------- ---------------- ----------------- ---------------- ----------- ------------ ------------ ----------- ---------------- -------- [null] PUBLIC PRODUCT ID 4 INTEGER 4 10 0 [null] [null] 4 1 NO [null] [null] [null] [null] 1 [null] PUBLIC PRODUCT CODE 12 VARCHAR 50 100 1 [null] [null] 12 100 2 YES [null] [null] [null] [null] 1 [null] PUBLIC PRODUCT NAME 12 VARCHAR 50 100 1 [null] [null] 12 100 3 YES [null] [null] [null] [null] 1 Raw result data from 1.9 look like this: TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SCOPE_CATLOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE IS_AUTOINCREMENT TYPE_SUB --------- ----------- ---------- ----------- --------- --------- ----------- ------------- -------------- -------------- -------- ------- ---------- ------------- ---------------- ----------------- ---------------- ----------- ------------ ------------ ----------- ---------------- ---------------- -------- PUBLIC PUBLIC PRODUCT ID 4 INTEGER 32 0 2 0 [null] [null] 4 0 1 NO [null] [null] [null] [null] YES 1 PUBLIC PUBLIC PRODUCT CODE 12 VARCHAR 50 1 [null] [null] 12 50 2 YES [null] [null] [null] [null] NO 1 PUBLIC PUBLIC PRODUCT NAME 12 VARCHAR 50 1 [null] [null] 12 50 3 YES [null] [null] [null] [null] NO 1 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
