search

leeonsoft / txquery

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

SUM,AVG,MAX not work #43

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Query SQL: SELECT SUM(animals.size) FROM animals
2. Error Syntax: "(Result number of sum): syntax error at line: 1, Column:8 
token: ,."
3. SUM,AVG,MAX not work

What is the expected output? What do you see instead?
Any Thing

What version of the product are you using? On what operating system?
Windows Delphi XE4

Please provide any additional information below.
SUM,AVG,MAX not work - MIN work in my cas with negative result(value -33060 is 
correct result)

Original issue reported on code.google.com by lu...@dicomevents.com on 13 Jun 2013 at 5:22

Attachments:

GoogleCodeExporter commented 9 years ago 
This problem occurs only with numbers that have decimals.
It has also been tested with CAST, but does not work

Original comment by lu...@dicomevents.com on 17 Jun 2013 at 11:47

GoogleCodeExporter commented 9 years ago 
Hi please check the latest version posted in this issue:
http://code.google.com/p/txquery/issues/detail?id=40

Original comment by fdue...@gmail.com on 23 Jul 2013 at 9:22

GoogleCodeExporter commented 9 years ago 
HI please check latest release of TxQuery 3.01

Original comment by fdue...@gmail.com on 1 Aug 2013 at 6:01