[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 Julien Nabet changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |serval2...@yahoo.fr |desktop.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #17 from Commit Notification --- Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/97ad402d58b52a1f2636905137c21298531c2935 tdf#128698: MySQL/MariaDB direct Connection: time-values not written to table It will be available in 6.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 Commit Notification changed: What|Removed |Added Whiteboard||target:6.5.0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698
--- Comment #16 from Julien Nabet ---
This patch seems to fix it, at least I don't reproduce the pb with it:
diff --git a/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx
b/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx
index 902a1d93edb0..7cdd19667f30 100644
--- a/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx
+++ b/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx
@@ -267,7 +267,7 @@ void SAL_CALL OPreparedStatement::setTime(sal_Int32
parameter, const Time& aVal)
checkDisposed(OPreparedStatement::rBHelper.bDisposed);
checkParameterIndex(parameter);
-MYSQL_TIME my_time;
+MYSQL_TIME my_time = {};
my_time.hour = aVal.Hours;
my_time.minute = aVal.Minutes;
I'll submit it when I get back home.
If someone wants to submit it before, don't hesitate!
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698
--- Comment #15 from Julien Nabet ---
I don't even know where I can see the request which will be executed:
161 int nFail = mysql_stmt_execute(m_pStmt);
(gdb) p m_pStmt
$27 = (MYSQL_STMT *) 0x58d06190
(gdb) p *m_pStmt
$28 = {mem_root = {free = 0x58d01c90, used = 0x0, pre_alloc = 0x0,
min_malloc = 32, block_size = 2008, block_num = 0, first_block_usage = 0,
error_handler = 0x0}, mysql = 0x57ac7100, stmt_id = 34,
flags = 0, state = MYSQL_STMT_PREPARED, fields = 0x0, field_count = 0,
param_count = 2, send_types_to_server = 1 '\001', params = 0x58d01ca8, bind
= 0x0, result = {rows = 0, fields = 0, data = 0x0,
alloc = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32,
block_size = 4056, block_num = 0, first_block_usage = 0, error_handler = 0x0}},
result_cursor = 0x0, bind_result_done = 0 '\000',
bind_param_done = 1 '\001', upsert_status = {warning_count = 0, server_status
= 0, affected_rows = 18446744073709551615, last_insert_id = 0}, last_errno = 0,
last_error = '\000' ,
sqlstate = "0", update_max_length = 0 '\000', prefetch_rows = 1, list =
{prev = 0x0, next = 0x58a63920, data = 0x58d06190}, cursor_exists = 0
'\000', extension = 0x586f2410,
fetch_row_func = 0x0, execute_count = 0, default_rset_handler = 0x0, m = 0x0}
I'm stuck.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #14 from Julien Nabet --- I gave a new try and this time have 00:00:00 each time. Trying to debug this, I only can tell that everything seems ok in "OPreparedStatement::setTime" (see https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx?r=913d34ec#264) I tried to compare the mechanism with setDate which works, I don't find the root cause. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 Xisco Faulí changed: What|Removed |Added Assignee|xiscofa...@libreoffice.org |libreoffice-b...@lists.free ||desktop.org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 Xisco Faulí changed: What|Removed |Added Priority|highest |medium Resolution|FIXED |--- Severity|critical|normal Assignee|libreoffice-b...@lists.free |xiscofa...@libreoffice.org |desktop.org | CC||xiscofa...@libreoffice.org Status|RESOLVED|NEW --- Comment #9 from Xisco Faulí --- Wait a second... what is going on here? Could anyone explain how to reproduce this issue and under which circumstances it's happening ? As far as I can read, not happening on win, not happening on 64 bits, not happening with native drivers ? Please, clarify -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 erich changed: What|Removed |Added Resolution|--- |FIXED Status|ASSIGNED|RESOLVED --- Comment #8 from erich --- (In reply to Robert Großkopf from comment #7) > (In reply to erich from comment #6) > any other native driver. Seems you had installed an extension. > Yes, I did install an extension because it looked and worked no nicely (the installation) and NativeDriver sounds sooo good. > Did you really assigned yourself to fix this bug? If not please reset it to > new. For me it is no longer a bug I can work. Sorry I forgot to reset the Status 6.4. seems to be close then I'll have a test again with NativeDriver -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #7 from Robert Großkopf --- (In reply to erich from comment #6) > Thanks Robert > > I solved (MY) problem (getting up early this morning) > > Using Version 6.1. > testing falling back till 5.7. but > > The Problem is the mysql Native driver 1.0.1 The native driver is included in LO since LO 6.2. So you don't have to use any other native driver. Seems you had installed an extension. This bug doesn't appear with 64bit-rpm-systems with LO 6.3.3.2 with this included native driver. Did you really assigned yourself to fix this bug? If not please reset it to new. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698
erich changed:
What|Removed |Added
Status|NEW |ASSIGNED
--- Comment #6 from erich ---
Thanks Robert
I solved (MY) problem (getting up early this morning)
Using Version 6.1.
testing falling back till 5.7. but
The Problem is the mysql Native driver 1.0.1
Going back to JDBC driver its fine again you even get
an error message complaining about the TIME values
I succeeded to enter with the native diver.:
--
Die Dateninhalte konnten nicht aktualisiert werden.
The value '30:00:00' is an invalid TIME value. (I entered 12:30)
JDBC Time objects represent a wall-clock time
and not a duration as MySQL treats them .
--
LO 5.7 refuses to load Mysql-native 1.0.2 under Debian 9.0
('auf diesem System nicht lauffähig)
So back to JDBC and forget about nativeDriver(for some time)
But it would be nice to work with a native driver - wouldn't it
NEVER change drivers that was the lesson I just learned
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #5 from Robert Großkopf --- (In reply to erich from comment #4) > Similar Problem as Alex > Using a Form entering 12:45 sends a Key Error Time 00:00:00 duplicate key > > Entering 12:45 in mysql workbench I find 45:00:00 in my dbase Form > > Under debian 9 Which version of LO do you use? I have tried all here to reproduce it with LO 6.3.3.2 rpm-packages. Couldn't reproduce it with my OpenSUSE Linux 64bit system. And you get the error with Debian 9 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #4 from erich --- Similar Problem as Alex Using a Form entering 12:45 sends a Key Error Time 00:00:00 duplicate key Entering 12:45 in mysql workbench I find 45:00:00 in my dbase Form Under debian 9 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 QA Administrators changed: What|Removed |Added Keywords||bibisectRequest -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #3 from Alex Thurgood --- Something weird going on. If I change the name of the time field, by opening up the table for edition, then saving the change, and re-opening the table for data entry, I can now enter any time I like and no longer get the error. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 --- Comment #2 from Alex Thurgood --- The fact that 00:00:00 gets committed to the database, which means data is lost when editing an existing entry, indicates that an incorrect string is being passed to the parser to perform the INSERT or UPDATE. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128698] MySQL/MariaDB direct Connection: time-values not written to table
https://bugs.documentfoundation.org/show_bug.cgi?id=128698 Alex Thurgood changed: What|Removed |Added Summary|MySQL/MariaDB direct|MySQL/MariaDB direct |Connection: Time-values |Connection: time-values not |won't be written to table |written to table -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
