Issue 114527

Summary:

Database does not show updated mysql data

Product:

Base

Reporter:

dasistwas <davidbogner>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

UNCONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 3.2.1

Target Milestone:

---

Hardware:

Unknown

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Screenshot of the lacking entry in query compared to table	none

Description dasistwas 2010-09-15 14:37:52 UTC

I created a query in myquery.odb, which connects to a mysql database (via MySQL
Connector).
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.