Bug 157898 - MariaDB JDBC-Connection: Values in query, connected to two tables, will be duplicated while moving cursor
Summary: MariaDB JDBC-Connection: Values in query, connected to two tables, will be du...
Status: RESOLVED DUPLICATE of bug 157913
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-23 15:44 UTC by Robert Großkopf
Modified: 2023-10-25 07:48 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2023-10-23 15:44:42 UTC
This bug is a special bug of MariaDB with JDBC in LO Base:

Create two tables with the following code in MariaDB:
–––––––––––––––––––––––––––––––––––––––––––––––––––––

CREATE TABLE `Person` (
  `ID` tinyint(3) NOT NULL,
  `Forename` varchar(100) DEFAULT NULL,
  `Surname` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `Zensuren` (
  `PersonID` tinyint(3) NOT NULL,
  `F1` tinyint(3) UNSIGNED DEFAULT NULL,
  `F2` tinyint(3) UNSIGNED DEFAULT NULL,
  `F3` tinyint(3) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `Person`
  ADD PRIMARY KEY (`ID`);
ALTER TABLE `Zensuren`
  ADD PRIMARY KEY (`PersonID`);
ALTER TABLE `Person`
  MODIFY `ID` tinyint(3) NOT NULL AUTO_INCREMENT;
ALTER TABLE `Zensuren`
  ADD CONSTRAINT `Zensuren_ibfk_1` FOREIGN KEY (`PersonID`) REFERENCES `Person` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

–––––––––––––––––––––––––––––––––––––––––––––-
Insert some values in table "Person". Only one character for Forname will be enough.
Insert the same values for ID as created in "Person" into "PersonID".
Connect both tables in a query.
Only with JDBC-connection you will be able to add values to F1, F2 and F3. (Write protected with direct connection - don't know why).
Add '2' in first row of F1.
Move arrow down to next row.
'2' will be shown in next row.
Move down again.
'2' will move with the cursor.

Seems something is going wrong with refreshing when changing to next row.

All detected in LO 7.6.2.1, might be also in older versions. Seems to work well with AOO - so not a bug of JDBC-connection …
Comment 1 Robert Großkopf 2023-10-25 07:33:36 UTC
Isn't a special MariaDB/JDBC-Bug.
Will close this one and open a new with internal HSQLDB.
Comment 2 Robert Großkopf 2023-10-25 07:48:50 UTC

*** This bug has been marked as a duplicate of bug 157913 ***