Influxql DIFFERENCE wrong results

InfluxDB 3
1

Hello.
I am using influxdb3 3.2.0, revision 1ca3168beee35b22fe62a3998cd3ed0d4ab65ac6

influxdb@tbsMachine:~$ influxdb3 query --database blindscanners -l influxql “SELECT pass FROM blindscannertimings order by time desc limit 5”
±-----------------------±------------------------------±-----+
| iox::measurement | time | pass |
±-----------------------±------------------------------±-----+
| blindscannertimings | 2025-07-15T01:53:14.756273900 | 90 |
| blindscannertimings | 2025-07-15T01:51:25.442946 | 89 |
| blindscannertimings | 2025-07-15T01:49:35.033774900 | 88 |
| blindscannertimings | 2025-07-15T01:47:48.110567900 | 87 |
| blindscannertimings | 2025-07-15T01:46:07.572942900 | 86 |
±-----------------------±------------------------------±-----+
influxdb@tbsMachine:~$ influxdb3 query --database blindscanners -l influxql “SELECT DIFFERENCE(pass) FROM blindscannertimings order by time desc limit 5”
±-----------------------±------------------------------±---------------------+
| iox::measurement | time | difference |
±-----------------------±------------------------------±---------------------+
| blindscannertimings | 2025-07-15T01:51:25.442946 | 18446744073709551615 |
| blindscannertimings | 2025-07-15T01:49:35.033774900 | 18446744073709551615 |
| blindscannertimings | 2025-07-15T01:47:48.110567900 | 18446744073709551615 |
| blindscannertimings | 2025-07-15T01:46:07.572942900 | 18446744073709551615 |
| blindscannertimings | 2025-07-15T01:44:24.504018700 | 18446744073709551615 |
±-----------------------±------------------------------±---------------------+

As you can see i get 18446744073709551615 . I think that the results are wrong.
Any ideas ?
Thanks!

2

The function expects data in ascending time order to calculate the correct difference between subsequent values see documentation.

Try SELECT DIFFERENCE(pass) FROM blindscannertimings LIMIT 5

3

Thanks for replying.
Sorry but where does it say in the documentation that it has to be sorted by asc ?
Anyway it doesn’t work.
I had to change the data type from unsigned int to int in order to work correctly which i think is wrong. It can’t display negative numbers(in case of unsigned int data type) that’s why it displays wrong values.
Thanks again for replying.