adem0x / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

JOIN #18

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Do a query with two tables with 10000 record or more the second table copy 
is copy of first.
2.select all fields of both tables,in where clause set a something like that 
table1.field  = table2.field  when field is a char field[20]   
3. use TDBF as your dbf manager.

the query just crash, how can i solve the problem???

Original issue reported on code.google.com by Nenukes...@gmail.com on 10 Aug 2011 at 8:33

GoogleCodeExporter commented 9 years ago
Please post a sample app and data to do the tests.

Original comment by fdue...@gmail.com on 18 Aug 2011 at 12:16

GoogleCodeExporter commented 9 years ago
Hi please Check Issue #19, I have posted some updated sources. I fixed an AV 
error when working with joins and joining with string fields.

I have tested with two tables with more than 50,000 records (Mysql tables 
rtreived wioth AyDAC) and seems to work ok.

Original comment by fdue...@gmail.com on 23 Aug 2011 at 5:24

GoogleCodeExporter commented 9 years ago
Thanks a lot it seems to be the issue is fixed, but notice there is an issue 
with sort and with distinct, im going to upload an example, and con you tell me 
what table maneger did you use?...

Original comment by Nenukes...@gmail.com on 25 Aug 2011 at 4:21

GoogleCodeExporter commented 9 years ago
Ok, yes pleas give a sample data. I tested it with my own test app and also 
with the Demo app that comes with txquery. I have not detecte any issue, unless 
with special characters, that maybe a problem. But please send me the info to 
start checking it.

Original comment by fdue...@gmail.com on 25 Aug 2011 at 6:30