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...
Product: Red Hat Enterprise Linux 4
Classification: Red Hat
Component: MyODBC (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Tom Lane
David Lawrence
Depends On:
  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:
Last Closed: 2007-05-01 13:19:32 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

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:

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!
insert into tab_1 values ("1","test1")

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

How reproducible:

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

- 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

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

$ env | grep LANG

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:
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.

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
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.


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