<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - First row missing from Base query results."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124759#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - First row missing from Base query results."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124759">bug 124759</a>
from <span class="vcard"><a class="email" href="mailto:kovacs.zsolt.sandor@gmail.com" title="kovacs.zsolt.sandor@gmail.com">kovacs.zsolt.sandor@gmail.com</a>
</span></b>
<pre>
(In reply to Alex Thurgood from <a href="show_bug.cgi?id=124759#c1">comment #1</a>)
<span class="quote">> @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.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>