Hi,
I am running the following query and its not returning any rows. If the rollno or location criteria is removed it returns rows where the rollno is the same one I have in the query. If location = LU-O is replaced with location like 'LU-%' it works.
select top 1 * from mmwiptran WHERE lamno = '05' AND location = 'LU-O' and rollno = '0000035680-01' order by adddate desc
This is occurring in the latest HXTT version. Its working fine in the older version.
If you need any file for debugging, let me know which email I can send it to.
Thanks
|
|
Please download the latest package. It should be fixed on Dec 12th.
|
Hi,
The Dec 12th package fixed the issue. However this query is not returning any rows. It should return one row and is working fine when I run it from FoxPro
select mmrawmat.group
from mmrawmat
inner join mmrawrol on RTRIM(mmrawrol.item) = rtrim(mmrawmat.item)
where mmrawrol.lamtecid = '536653'
Thanks
Arif
|
The latest package should be 7.1.030 is released on December 16, 2020.
Please try it.
Passed test.
*create table if not exists mmrawmat (item varchar(12),group varchar(12));
*insert into mmrawmat values('15','22');
*create table mmrawrol (item varchar(12),lamtecid varchar(12));
*insert into mmrawrol values('15','536653');
*create index item of mmrawmat.cdx on mmrawmat (RTRIM(item));
*create index item,lamtecid of mmrawrol.cdx on mmrawrol (RTRIM(item),lamtecid);
select mmrawmat.group from mmrawmat inner join mmrawrol on RTRIM(mmrawrol.item) = rtrim(mmrawmat.item) where mmrawrol.lamtecid = '536653'
explain select mmrawmat.group from mmrawmat inner join mmrawrol on RTRIM(mmrawrol.item) = rtrim(mmrawmat.item) where mmrawrol.lamtecid = '536653'
id table expression key
1 mmrawrol mmrawrol.lamtecid=='536653' mmrawrol.lamtecid
2 mmrawmat RTRIM(mmrawmat.item)==RTRIM(mmrawrol.item) RTRIM(mmrawmat.item)
|
Main
webmaster@hxtt.com