This service will be undergoing maintenance at 00:00 UTC, 2016-09-28. It is expected to last about 1 hours
Bug 84872 - [patch] MyODBC wants to use "." as decimal point when talking to MySQL, but does not set numeric locale correctly
[patch] MyODBC wants to use "." as decimal point when talking to MySQL, but d...
Status: CLOSED ERRATA
Product: Red Hat Enterprise Linux 4
Classification: Red Hat
Component: MyODBC (Show other bugs)
4.0
All Linux
medium Severity medium
: ---
: ---
Assigned To: Tom Lane
David Lawrence
RHEL4U3NAK
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2003-02-22 11:58 EST by shrek-m
Modified: 2013-07-02 22:59 EDT (History)
2 users (show)

See Also:
Fixed In Version: RHBA-2007-0291
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2007-05-01 13:19:32 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:


Attachments (Terms of Use)
patch to fix MyODBC (1.56 KB, patch)
2004-12-02 08:10 EST, Caolan McNamara
no flags Details | Diff

  None (edit)
Description shrek-m 2003-02-22 11:58:02 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030206

Description of problem:
openofffice-datasources

it is possible to create new tables
but it ends everytime with different sql-syntax-errors while "create new
records, insert".
"update" works sometimes


the  "privileges"  are correct:
open a sql-statement window
type the correct statements without ending ";"
there are absolutely no problems!
eg.
insert into tab_1 values ("1","test1")

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1.  create a new table (gui)
2.  try to insert a new record
3.  update an existing record
    

Actual Results:  [unixODBC][TCX][MyODBC]Column count doesn�t match
value count at row 1
- sql-syntax-error

Expected Results:  all should work

Additional info:
Comment 1 Caolan McNamara 2004-10-28 08:16:19 EDT
caolanm->shrek-m: Is this still the case with a contemporary
OpenOffice.org ?
Comment 2 shrek-m 2004-11-20 14:30:45 EST
$ cat /etc/fedora-release
Fedora Core release 3 (Heidelberg)
$ rpm -q openoffice.org unixODBC mysql mysql-server
openoffice.org-1.1.2-11.5.fc3
unixODBC-2.2.9-1
mysql-3.23.58-13
mysql-server-3.23.58-13


- create a new userDSN with
$ ODBCConfig

- create a new dadasource (MySQL or ODBC)

- create a new table (without primary key)
OOo will create a primary key

- insert data
for each new row i have to close the connection
"Fehler beim Einfügen des neuen Datensatzes
[unixODBC][TCX\MyODBC] You have an error in your SQL syntax near
00000000000e+01' at line 1"

- changing existing entries is possible

-------
OOPS,
LANG=C oowriter    /*all is OK*/
LANG=de_DE oowriter    /*"ERROR*/


$ env | grep LANG
LANG=de_DE.UTF-8

it seems that the LANG is the problem
Comment 3 Caolan McNamara 2004-12-02 08:09:15 EST
Argh!, I found it. A problem with setlocale in MyODBC.
Comment 4 Caolan McNamara 2004-12-02 08:10:15 EST
Created attachment 107765 [details]
patch to fix MyODBC

setlocale(LC_NUMERIC,"English") -> setlocale(LC_NUMERIC,"C");
Comment 5 Tom Lane 2004-12-02 11:20:03 EST
My, that's ugly :-( ... will fix.  Thanks for the detective work!
Comment 6 Tom Lane 2004-12-08 15:57:21 EST
Caolan, how far back are we supporting OpenOffice?  I'm wondering
which releases I need to put this fix into ...
Comment 7 Caolan McNamara 2004-12-09 03:48:15 EST
Each OOo update we do we push simultaneously for FC2/FC3/RHEl-4/rawhide
Comment 8 Tom Lane 2004-12-10 17:54:38 EST
I've pushed this fix into fc2, fc3, and rawhide, but it's too late for
RHEL4 :-( ... it'll have to go into U1.

I'll leave the bug report open to remind me to do that when the U1
window opens.
Comment 10 Tom Lane 2005-07-20 15:39:43 EDT
Adjust bz entry to mention RHEL4.
Comment 13 Tom Lane 2005-08-10 23:47:15 EDT
Just for completeness, this problem was reported to MySQL some time ago, and only partially fixed:
http://bugs.mysql.com/bug.php?id=371
Comment 18 shrek-m 2006-04-18 17:58:07 EDT
i do not now if it is fixed, i do not use rhel.
please close it, i have no permission.

ciao
Comment 19 RHEL Product and Program Management 2006-08-18 13:59:23 EDT
This request was evaluated by Red Hat Product Management for inclusion in a Red
Hat Enterprise Linux maintenance release.  Product Management has requested
further review of this request by Red Hat Engineering, for potential
inclusion in a Red Hat Enterprise Linux Update release for currently deployed
products.  This request is not yet committed for inclusion in an Update
release.
Comment 23 Red Hat Bugzilla 2007-05-01 13:19:32 EDT
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHBA-2007-0291.html

Note You need to log in before you can comment on or make changes to this bug.