Description: First row missing from Base query results. Steps to Reproduce: 1.Write query 2.Run 3.Missing first row 4.Refresh 5.Wow, happy Actual Results: Missing first row. Expected Results: With refresh is good. Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: hu Module: QueryDesign [Information guessed from browser] OS: Windows 10 OS is 64bit: yes
@Sandor : what are you using as your datasource ? Ideally, we need a sample database file where the problem occurs so that we can compare and try to reproduce. Setting NEEDINFO.
(In reply to Alex Thurgood from comment #1) > @Sandor : what are you using as your datasource ? > > Ideally, we need a sample database file where the problem occurs so that we > can compare and try to reproduce. > > Setting NEEDINFO. I can't present that database. Data source: Client Access ODBC Driver (32-bit) 12.00.00.00 IBM Corporation iSeries Access ODBC Driver C:\WINDOWS\system32\cwbodbc.dll 2007.12.11 SQL:: select SYS_CNAME from QSYS2.SYSCOLUMNS where SYS_TNAME='SYSTABLES' and SYS_DNAME='QSYS2' and SYS_CNAME < 'E' order by 1 Run(F5):: SYS_CNAME COLCOUNT CREATOR DBNAME DECFLTRND DEFINER Refresh:: SYS_CNAME ALTEREDTS COLCOUNT CREATOR DBNAME DECFLTRND DEFINER With another data source, SQL server ( 10.00.17134.01 MS SQLSRV32.DLL 2018.04.12), work fine.
@Sandor : the driver you mention is specific for an ODBC connection to IBM DB2 databases Why are you using the 32bit driver, instead of the 64bit driver, on your Win10 64bit OS ? Changed title to reflect information provided.
Unfortunately, I do not have access to such a db setup, so can't test. According to : http://www-01.ibm.com/support/docview.wss?uid=nas8N1015102 the ODBC driver includes both 64 bit and 32 bit support built-in, and uses the bit type corresponding to the application which calls the driver. However, this document also notes that the 64 bit driver is located in \windows\system32\cwbodbc.dll So, despite the information you gave, indicating that the driver is 32bit, it is fact, at least according to IBM's own documentation, the 64-bit driver. Go figure. Please ignore my questions, setting back to UNCONFIRMED
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
(In reply to Xisco Faulí from comment #5) > Could you please try to reproduce it with the latest version of LibreOffice > from https://www.libreoffice.org/download/libreoffice-fresh/ ? > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' if the bug is still present in the latest version. Unfortunately, the problem still exists in the new version.
[Automated Action] NeedInfo-To-Unconfirmed
Thanks to everyone for your efforts. I had to reinstall my machine, which also solved this problem. Now it works fine.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.