Bug 126148 - Getting a new error using mariadb on "operation 'st_isempty'"
Summary: Getting a new error using mariadb on "operation 'st_isempty'"
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-28 13:31 UTC by tim
Modified: 2019-06-28 19:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tim 2019-06-28 13:31:03 UTC 
Using a mariadb database (using mysql jdbc) unchanged for some months, I am now getting an error in some forms when opening the form for 'new' entries only.  The error message is:

SQL Status: HY000 Error code: 4079 Illegal parameter data type int for operation 'st_isempty'

I have no idea what st_isempty is being used for (I believe it is to do with geometry).

I have this in 6.2.2.2 (ubuntu version) and also in 6.2.5.0.0+ (from doc foundation).

I am trying to reproduce this in an empty database so as to demonstrate it, but have so far not managed to do so.  When debugging the error seems to occur right at the open function, and stepping through my macro it stops at the "After Change" function for that form.

I'd be grateful for any clues to help me diagnose and report this issue better.
Comment 1 tim 2019-06-28 19:25:26 UTC 
Sorry.  I have now found this is a more extensive problem affecting some mariadb views that have been unchanged for years but now give errors.  It is nothing to do with libreoffice,