[QGIS-Developer] Renderer/expression issue temporal/gpkg

[Karsten Tebling]

HI,

I just wanted to say that i had similar issues (not temporal) with 
PostGIS on a Mac running a 3.4 version of QGIS. I ended up duplicating 
the layer and setting filters instead of using the rule-based-renderer. 
The rule based renderer returned the right amount of items when i testet 
it, but it clearly rendered the wrong amount of objects.

greetz

Am 29.01.2021 um 13:27 schrieb Richard Duivenvoorde:
> Hi Devs,
>
> I have an issue with the (temporal) rendering of (seemingly only) gpkg.
> See https://github.com/qgis/QGIS/issues/41074
> For some test datasets.
>
> I tried to debug, but get lost in the deeper core classes like featureiterator and renderer...
>
> A gpkg with a QDatetime column seems to render the wrong 'classes',
> while if I create a virtual new attribute (to_datatime('Time')) based on the original QDateTime it will render the right one.
>
> BUT(!) those 2 attributes seem to be exactly the same...
>
> So: to me it looks like there is something fishy there: renderer (featureiterator) seems to return other features then the (same?) iterator for the infotool and attributetable..
>
> The temporal controller creates expressions to do the selections.
> EG:
> ("Time" > make_datetime(2019,9,1,6,0,0) AND "Time" < make_datetime(2019,9,1,8,0,0)) OR "Time" IS NULL
>
> BUT: a gkpg with 7 AND 8 will render BOTH, although the expressions rightfully return True (for 7) and False (for 8):
>
> 7 == true/1
> make_datetime(2019,9,1,7,0,0) > make_datetime(2019,9,1,6,0,0) AND make_datetime(2019,9,1,7,0,0) < make_datetime(2019,9,1,8,0,0)
> 8 == false/0
> make_datetime(2019,9,1,8,0,0) > make_datetime(2019,9,1,6,0,0) AND make_datetime(2019,9,1,8,0,0) < make_datetime(2019,9,1,8,0,0)
>
> Anybody has a clue? Or can maybe reproduce my issue(s)?
>
> Regards,
>
> Richard Duivenvoorde
>
> PS although one of my open PR's changes the logice of the expression a little, the behaviour for this is the same before and after this
>
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-- 
Ihre Signatur

Mit freundlichen Grüßen,

Karsten Tebling



*Masuch Geoinformation*

Hauptsitz: Seestraße 72, 16866 Kyritz
Niederlassung: Hauptstraße 31, 16845 Sieversdorf

Telefon: (+49) 0 33 970 - 13 9 56 <tel:+493397013956>
Telefax: (+49) 0 33 970 - 13 9 57 <tel:+493397013957>
E-Mail: info at masuch.de <mailto:info at masuch.de>
Web: www.masuch.de <www.masuch.de >

USt-IDNr.: DE163259093
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210201/d733a7a2/attachment.html>