[Libreoffice-bugs] [Bug 45253] EDITING postgreSQL-SDBC New Table wizard mishandles Memo field data types

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=45253

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
           Priority|medium                      |low
                 CC|                            |lionel at mamane.lu
     Ever Confirmed|0                           |1

--- Comment #1 from Lionel Elie Mamane <lionel at mamane.lu> 2012-02-02 02:50:24 PST ---
The whole type handling system of PostgreSQL-SDBC is a mess and needs serious
love.

Preliminary analysis: most "unknown" types are mapped to "memo". From the
described symptoms, the wizard seems to take the first alphabetical in the list
of ones mapped to memo and this happens to be "[ _abstime ]" (an array type).

My first guess is that the PostgreSQL type "text" is the best match. However,
it is mapped to what the LibreOffice UI calls "Text", which I understand is
supposed to be SQL VARCHAR and similar. (There is a separate "Text (fix)" for
SQL CHAR.)

Note: when testing, make sure to close the wizard between tests; when going
back and forth between step 1 and 2, the wizard keeps changes you made in step
2, even if you remove and readd a field in step 1. This may make that bug seem
like a Heisenbug.

Setting low priority as I'm going to focus on data manipulation issues before
data definition issues. (data definition can conceivably be done with SQL
statements rather than GUI and/or separate PostgreSQL-specific GUI).

If this causes an actual data manipulation issue, this will raise the priority.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.