SQL Query bug with "Bonus" data

[BGabor]

Hello All!

I found some wierd behaviour with SQL query's "bonus number of values before and after the query" functionality.
There are two boolean DP-s archived, b02. and b04.
I want to know two things:
1. Values of the DP-s in the given time range (e.g. 13:40:00 - 13:41:00)
2. First valid value of DP-s before the start time (13:40:00)

Attached the query results.
When I query for both DP-s, I only get values from "b02." before 13:40:00
If I query for only b04., there is value before 13:40:00

Seems like the query does not return the correct DP-s, when searching for both.

I've tried the same query but instead of boolean values I used integers.
It worked as expected.

[BGabor]

Added some clarification about the "Bonus" data defintion I've mentioned.

[leoknipp]

If the bonus parameter works or not may also depend on the database you are using to save the values.

Which WinCC OA version and patch level is installed?
Which type of database is used for archiving?

In case of RDB archiving, is queryRDBDirect used or not?

Best Regards
Leopold Knipp
Senior Support Specialist

[BGabor]

Using version 3.16 P001.
I'm using internal WinCC OA archiving ( called HDB?).

Regards,
Gabor

[leoknipp]

I have tested and I have seen a problem when reading data with bonus values.
The problem was forwarded to our development department for further analysis.

Best Regards
Leopold Knipp
Senior Support Specialist

[BGabor]

Hello Leo,

Any update about this bug?

Regards,
Gabor Baroczi

I have tested and I have seen a problem when reading data with bonus values.
The problem was forwarded to our development department for further analysis.

Best Regards
Leopold Knipp
Senior Support Specialist

[leoknipp]

A solution for this issue is not available up to now and it is not defined when it will be analyzed.

Best Regards
Leopold Knipp
Senior Support Specialist