Issue 114527 - Database does not show updated mysql data
Summary: Database does not show updated mysql data
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-09-15 14:37 UTC by dasistwas
Modified: 2013-01-29 21:47 UTC (History)
1 user (show)

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

Screenshot of the lacking entry in query compared to table (44.12 KB, image/jpeg)
2010-09-15 14:38 UTC, dasistwas
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dasistwas 2010-09-15 14:37:52 UTC
I created a query in myquery.odb, which connects to a mysql database (via MySQL
When I insert a new entry in mysql (via phpmyadmin) and I do a refresh in my
OpenOffice query, the new entry does not show up in the query. I even did a
restart of my computer (Ubuntu 10.04) and the entry does not show in the query,
but it shows up in the table data in my myquery.odb file and in mysql. 
So the problem: The query I created within myquery.odb does not get updated with
the new entries even after system restart. 
As you see on the screenshot, the las entry in the table is 1002081 and the last
entry in the query is 1002090, the latest entry is missing.
Comment 1 dasistwas 2010-09-15 14:38:41 UTC
Created attachment 71711 [details]
Screenshot of the lacking entry in query compared to table
Comment 2 Frank Schönheit 2010-09-15 14:43:12 UTC
what's the SQL statement defining the query?
Comment 3 dasistwas 2010-09-15 15:29:35 UTC
This is one example (works with nearly all statements)
SELECT `rechnungen`.`Rechnungnr`, `rechnungen`.`Kundennr`, `rechnungen`.`Datum`,
`rechnungen`.`Betrag`, `rechnungen`.`Leistung`, `kundendaten`.`Vorname`,
`kundendaten`.`Nachname`, `kundendaten`.`Titel`, `kundendaten`.`Strassse`,
`kundendaten`.`HausStiegeTuer`, `kundendaten`.`PLZ`, `kundendaten`.`Ort`,
`kundendaten`.`Telefon`, `kundendaten`.`Telefax`, `kundendaten`.`Firmenname`,
`kundendaten`.`Anrede` FROM `Firma`.`kundendaten` `kundendaten`,
`Firma`.`rechnungen` `rechnungen` WHERE ( `kundendaten`.`Kundennr` =
`rechnungen`.`Kundennr` )
Comment 4 felixbellaby 2010-10-05 18:13:06 UTC
At the risk of stating the obvious: 

1) the WHERE clause may be excluding the last record from the query even though
it appears in the table,  or 

2) the query might be being performed on a different, but similar, table, or

3) the query might be performed on a different, but similar, database (ie is the
`Firma` database the one appearing in the table window?)

I sometimes have two similar versions of the same table or database on a single
host or two versions of the same database on two different hosts. It is
remarkably easy to access the "wrong" one and become hopelessly confused.