[Libreoffice-bugs] [Bug 124759] First row missing from Base query results.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Apr 17 10:02:28 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=124759

--- Comment #2 from kovacs.zsolt.sandor at gmail.com ---

(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190417/42b4ea9b/attachment.html>


More information about the Libreoffice-bugs mailing list