Apache OpenOffice (AOO) Bugzilla – Issue 60273
After Executing a Query to MySQL OOo freezes
Last modified: 2006-05-31 14:29:06 UTC
I use milestone m148 I want to execute a query which works till now (m146) With m148 OOo freezes. So it's a regression.
can you attach the document in question?
Created attachment 33087 [details] last Input before frozen
It's also in m149
Today I download 2.0.2-m150 and there is the same mistake. I can't do a query with two parameters. 2.0.1 final do it I think this is priority 1 I tested it on the same computer with 2.0.1 again and there it's work
Created attachment 33209 [details] mysql dump
And here is the sql statement: SELECT `Konten`.`Kontonummer`, `Konten`.`Kontoname`, SUM( `Uberweisung`.`SollEUR` ) AS `GesamtSoll`, SUM( `Uberweisung`.`HabenEUR` ) AS `GesamtHaben` FROM { OJ `Hauptbuch2005`.`Uberweisung` `Uberweisung` LEFT OUTER JOIN `Hauptbuch2005`.`Konten` `Konten` ON `Uberweisung`.`Kontenbezeichnung` = `Konten`.`ID` } WHERE ( ( `Uberweisung`.`Uberweisungsdatum` >= :Anfangsdatum AND `Uberweisung`.`Uberweisungsdatum` <= :Enddatum ) ) GROUP BY `Konten`.`Kontonummer`, `Konten`.`Kontoname` HAVING ( ( `Konten`.`Kontonummer` <> 'Null' ) )
Hmm, cannot reproduce the freeze with any recent version (m151, m152). What's your platform/server version/driver version? Does it make a difference whether the table contains data or not?
Hello >Hmm, cannot reproduce the freeze with any recent version (m151, m152). It was also in m148 and m149 >What's your platform/server version/driver version? I use Debian Sarge, MySQL 4.1.11, libMyODBC 3.51.09, >Does it make a difference whether the table contains data or not? I don't know. This a query I use evry month since Jun 05 in OOo. I think there must be some datas becuse it's a query with parameters.
Ooops, tested this on Windows, not Linux. Hmm, currently don't have access to a working unixODBC installation, so cannot investigate further, sorry.
add to CC I also find more problems that can be regressions (in Linux)
I tested it also with m 147 and it also freezed. What I saw is that in m147 Issue 57084 was fixed with also a problem with queries with parameters. I don't know what was changed. It's only an idea.
I can reproduce this behaviour on m151 CPU Usage remains at zero but OOo Application does not respond to user interactions (needs to be SIGTERMed)
confirmed as SimonAW was able to reproduce. Seems to be an Unix (linux) only problem. andreschnabel-> SimonAW: can you give more details about your environment (esp. MySQL Version, ODBC config)
Hi, I can reproduce this also. Create a mysql database with the attached dump and then execute the query. ==>> loop reassign to the right developer and set target Bye Marc
My Environment: MySQL Version 5.1.5-alpha MyODBC Connector 3.51 unixODBC 2.2.9
The problem here is that we use the function SQLSpecialColumns which works under windows but doesn't seem to work under linux :-( oj->fs: Could please take care for the dba/dbaccess/source/core/api/resultcolumn.cxx and method call getVersionColumns. Thx.
fixed in CWS nomysqlversion
fs-> msc: please verify in CWS nomysqlversion re-open issue and reassign to msc
reassign to msc
reset resolution to FIXED
verified in cws nomysqlversion. This is only fixed if you use the mysql odbc connection. When you use odbc connection this is not fixed and can't be fixed.
Hi, this is fixed in the current master. The current master is available at http://download.openoffice.org/680/index.html I close this issue now. Bye Marc