Skip to content
This repository was archived by the owner on Jan 11, 2023. It is now read-only.
This repository was archived by the owner on Jan 11, 2023. It is now read-only.

Exeption while generating hmac for filter with NULL or empty values #3

Description

@simonschaufi

i have 2 tables. table A and table B.
I want to join table A with table B with field x
x has NULL values and integers
I created a checkbox filter to group all values of field x and filter for that field.
my SQL looks like this:
SELECT tableA.id, tableA.x
FROM tableA LEFT JOIN tableB ON tableA.x = tableB.id

the moment i remove all entries from tableA where x is NULL or empty string, then the filter works.

Hint: I'm accessing an external database, I know that TYPO3 tables usually use 0 as default value instead of NULL value.

right now i have no glue how this can be fixed otherwise I would have done a pull request already ;)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions