Issue 25624 - queries form mysql cannot be imported into the mysql database as table
Summary: queries form mysql cannot be imported into the mysql database as table
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1RC
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2004-02-17 20:04 UTC by oub
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
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 oub 2004-02-17 20:04:51 UTC 
Hi 

On suse 7.2 I have installed:

unixODBC-2.0.5-32
MyODBC-2.50.39-1
unixODBC-gui-gtk-2.0.5-32
unixODBC-devel-2.0.5-32
unixODBC-gui-qt-2.0.5-32

mysql-shared-3.23.37-8
mysql-client-3.23.37-8
mysql-3.23.37-8
mysql-devel-3.23.37-8

Using either the ODBC driver or the MySQL driver the following problem
occurs:

 The table of the  database consists of  two columns (fields), both of
 decimal  character, say  field1 and field2.  Now  in the query a  new
 field is generted,  which is simply  field1+field2. When copying  and
 pasting the query back in the database (in  the same spirit as a copy
 and paste a table in dbase format  into a table of  mysql), I have to
 select the format of the 'new field' which is text per default, but I
 chose to decimal. In anycase the new table  consists for three field,
 field1, field2 and field3, field3 however is empty,

Uwe Brauer
Comment 1 marc.neumann 2004-03-22 12:31:18 UTC 
Hi oub,

I can reproduce this.

Set target and send to the right developer.

Bye Marc
Comment 2 ocke.janssen 2004-05-27 15:26:38 UTC 
Fixed in cws insight01
Comment 3 marc.neumann 2004-06-16 08:45:33 UTC 
verify in cws insight01
Comment 4 ocke.janssen 2004-09-06 11:59:01 UTC 
.