Issue 18895 - [RFE][Usability] copy table auto pilot: warn the user if magics has been applied
Summary: [RFE][Usability] copy table auto pilot: warn the user if magics has been applied
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2003-09-01 15:43 UTC by Frank Schönheit
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

Attachments
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 Frank Schönheit 2003-09-01 15:43:18 UTC 
This rose from issue 18614.

There are situations where the "copy table" auto pilot applies magics, which
isn't clear to the user. E.g. in the scenario of issue 18614, where a DATETIME
field, when copied from MS Access, is silently converted to DECIMAL, the user
doesn't have a clue of what happened - until s/he e.g. tries to create a query
which compares the column with a date value, which is rejected. Finding the
*cause* for this rejection is up to impossible for the unexperienced user at
this moment.

Given that the auto pilot has the difficult task to mediate between a lot of
different database with a lot of different types, it should offer more help for
the user if something happened which may cause trouble later on.
Comment 1 ocke.janssen 2003-09-15 14:13:38 UTC 
.
Comment 2 hans_werner67 2004-02-02 12:30:34 UTC 
change subcomponent to 'none'
Comment 3 Frank Schönheit 2005-04-13 09:32:21 UTC 
blocking the meta issue
Comment 4 ocke.janssen 2010-01-13 08:19:44 UTC 
@fs: In a current version you'll get an error message that the type in the dest
db isn't available. So there exists no magic anymore. Does this convince you?
Comment 5 Mechtilde 2010-01-19 13:09:54 UTC 
worksforme -> closed