Issue 86739 - Database: schema names and table names containing slash '/'
Summary: Database: schema names and table names containing slash '/'
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: OOo 3.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: crash, oooqa
Depends on:
Blocks:
 
Reported: 2008-03-05 16:38 UTC by jwascroftleigh_cmed
Modified: 2009-05-21 06:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
A database file with embedded database showing the issue (2.80 KB, application/vnd.sun.xml.base)
2008-03-05 16:40 UTC, jwascroftleigh_cmed 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jwascroftleigh_cmed 2008-03-05 16:38:35 UTC 
I am connecting to a postgresql 8.1 database that uses free text fields for
schema names, table names and column names.  I have noticed that OpenOffice.org
database behaves strangely when trying to access these objects.  The problem is
when accessing a table where either the schema name or the table name contains
the slash character '/'.

The strange behaviour that I have identified so far:

   * In the tables tree listing these tables are shown with no icon (but the
schema has an icon)
   * When double-clicking on the table (to show the table contents) the
resulting window shows no columns and all actions are greyed-out.
   * The query designer shows no icon for the table and double clicking to add
the table to the query has no effect
   * When opening the report wizard a message "The field names from 'test/table'
could not be retrieved." is displayed.

Note that accessing the database using the psql tool seems to cope fine with
these tables and schema.
Comment 1 jwascroftleigh_cmed 2008-03-05 16:40:36 UTC 
Created attachment 51915 [details]
A database file with embedded database showing the issue
Comment 2 jwascroftleigh_cmed 2008-03-05 16:45:22 UTC 
My interest is primarily in postgresql but I managed to recreate similar effects
using an embedded database in the above attachment.  'test_no_slashes' is a
table showing normal behaviour while 'test/table' shows the deviant behaviour.
Comment 3 jwascroftleigh_cmed 2008-03-05 17:11:12 UTC 
This seems to be a regression since 2.2.0.  My postgres and the attached hsqldb
database both work on 2.2.0 as I would expect.
Comment 4 christoph.lukasiak 2008-05-05 15:52:42 UTC 
clu->wurzel: can you confirm that behavior?
Comment 5 alex.thurgood 2008-05-06 18:40:02 UTC 
I can confirm the current behaviour in OOo 2.4 Aqua. The table view shows an
empty grid, same if you switch on the document view in the list of tables.


In OOo 2.4 X11 for Mac, it causes the application to crash.
In OOo 3.0 Aqua m5, it causes the application to crash.

However, in all cases, the icon is shown in the list of tables.

In OOo 2.4 Aqua, if you try and create a query using the Query Wizard, when you
select the table from the dropdown list, an error message is displayed :
"Can not extract field names from public.test/spec"


In OOo 2.4 X11, any attempt to select the table, whether to create a query, a
form, or just visualise the data, causes OOo systematically to crash.

Setting crash keyword. Reassigning priority to P2.
Comment 6 christoph.lukasiak 2008-06-18 15:07:24 UTC 
change owner, set target
Comment 7 Frank Schönheit 2008-09-07 21:07:02 UTC 
fs->oj: please take over.
Comment 8 ocke.janssen 2008-11-03 13:41:20 UTC 
Fixed in cws dba31d.
Comment 9 ocke.janssen 2008-11-19 12:31:14 UTC 
Please verify. Thanks.
Comment 10 Frank Schönheit 2008-12-03 08:45:14 UTC 
looks good in CWS dba31d
Comment 11 drewjensen.inbox 2009-05-21 06:14:35 UTC 
Checked w/ 3.1

Closing

(Opening new issue for field names with '/' in functions)