https://bugs.documentfoundation.org/show_bug.cgi?id=149181
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Base query display '0' in |PostgreSQL direct |TEXT field |connection: Base query | |display '0' in TEXT field, | |if content of all shown | |fields could be read as | |"number" and query works | |with subquery as "table" Status|NEEDINFO |NEW OS|Windows (All) |All --- Comment #8 from Robert Großkopf <[email protected]> --- Could reproduce the error. If all entries in a TEXT field could also be recognized as a number the field will be formatted as a field for numbers in a query. It has nothing to do with direct SQL and starting with a comment. SELECT * FROM (SELECT * FROM "public"."company") "company" will reproduce the error directly. Has something to do with a query, which shows the content of a query. Seems the direct connection looses the information for the field and tries to detect it by the content of the column. -- You are receiving this mail because: You are the assignee for the bug.
