Bug 108443
depends on
44
open
bugs:
view as bug list
-
108443:
[META] Database query bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
33239:
RPT: "ORDER BY" clause dropped in "analyze sql: no" case when grouping is set in the report
[NEW; assigned to libreoffice-bugs]
-
33240:
RPT: grouping/sorting silently ignored with "analyze sql: no"
[NEW; assigned to libreoffice-bugs]
-
42400:
Query designer: numeric literal in condition on (VAR)CHAR column destructively transformed into string
[NEW; assigned to libreoffice-bugs]
-
42710:
SQL parser: WHERE clause "colname" or "NOT colname"
[NEW; assigned to libreoffice-bugs]
-
42713:
query design view loses SQL comments
[NEW; assigned to libreoffice-bugs]
-
46207:
SQL parser: accept an expression instead of only literal where makes sense
[NEW; assigned to libreoffice-bugs]
-
46209:
SQL parser: FROM clause in SELECT should be optional
[NEW; assigned to libreoffice-bugs]
-
46841:
EDITING: SQL of queries looses returns when saving and reopening
[NEW; assigned to libreoffice-bugs]
-
49359:
Add autocomplete for SQL commands to Query designer
[NEW; assigned to libreoffice-bugs]
-
50546:
EDITING: Allow complex statements for parametrized queries
[NEW; assigned to libreoffice-bugs]
-
50626:
EDITING: Query on Mac OS X Addressbook doesn't display data for fields other than CHAR datatype
[NEW; assigned to libreoffice-bugs]
-
51404:
Libreoffice Base with Oracle - SYSDATE, ROWNUM don't work in query!
[NEW; assigned to libreoffice-bugs]
-
60539:
FILESAVE: Column-width of a Query couldn't be saved
[NEW; assigned to libreoffice-bugs]
-
61831:
QUERY support for "SELECT TOP n", "ROWID", ... ways of limiting the number of results
[NEW; assigned to libreoffice-bugs]
-
61871:
EDITING: Query of a multiplication with fields of two tables don't refresh.
[NEW; assigned to libreoffice-bugs]
-
65685:
constant in select list querying a spreadsheet yields blanks
[NEW; assigned to libreoffice-bugs]
-
67608:
QUERY/TABLE copy/paste a single column
[NEW; assigned to libreoffice-bugs]
-
67664:
Query wizard in need of love
[ASSIGNED; assigned to omkar.nikam.2026]
-
68153:
EDITING: Query input in foreignkey-field impossible, when two tables in the query.
[NEW; assigned to libreoffice-bugs]
-
68374:
UI: Feature Enhancement: Query Design View: Select multiple columns at once
[NEW; assigned to libreoffice-bugs]
-
74487:
UI: Enhancement: Keep whitespace in SQL Editor
[NEW; assigned to libreoffice-bugs]
-
75853:
EDITING: Wrong timestamp in a table with date and time (except 00:00:00) before 1899-12-30
[NEW; assigned to libreoffice-bugs]
-
77897:
EDITING: Query in GUI-mode fails, when using a function in the field and a fieldname with special characters in criterion of the field
[NEW; assigned to libreoffice-bugs]
-
79433:
Other: Uninformative error messages in sql queries
[NEW; assigned to libreoffice-bugs]
-
82323:
query builder should provide visual representation of relationships one to many
[NEW; assigned to libreoffice-bugs]
-
82325:
query builder should seek input concerning what table operation should be done first
[NEW; assigned to libreoffice-bugs]
-
82372:
Base: Query builder deletes columns not visible that do not have constraint (unexpected loss of data)
[NEW; assigned to libreoffice-bugs]
-
83121:
BASE QUERY EDITOR: silently changes one-to-many relationships in complex query, impossible to set reliable outer join relationships
[NEW; assigned to libreoffice-bugs]
-
83171:
QUERY EDITOR: Adapt UI to fully handle views e.g. using function-created NULL values
[NEW; assigned to libreoffice-bugs]
-
86315:
EDITING: Formatting of queries should be saved by base
[NEW; assigned to libreoffice-bugs]
-
87737:
EDITING: Date-parameter in HSQLDB-queries don't work in UI-language, if parameter is only in subquery
[NEW; assigned to libreoffice-bugs]
-
90093:
Enhancement request: SQL auto formatting for Base queries
[NEW; assigned to libreoffice-bugs]
-
91989:
Query builder in UI doesn't parse GROUP_CONCAT with ORDER or SEPARATOR
[NEW; assigned to libreoffice-bugs]
-
95466:
Field properties in query result cannot be set to Currency
[NEW; assigned to libreoffice-bugs]
-
96372:
Filters do not work on Hsqldb subquery result when subquery has alias.
[NEW; assigned to libreoffice-bugs]
-
99619:
query design segfault on redoing an undone table join creation
[NEW; assigned to libreoffice-bugs]
-
103557:
Add syntax to reference form input boxes from queries (pass values)
[NEW; assigned to libreoffice-bugs]
-
105112:
Support aggregate functions EVERY, ANY, SOME, COLLECT, FUSION, INTERSECTION
[NEW; assigned to libreoffice-bugs]
-
112801:
Improve LO SQL parser to allow GUI Query editor usage with more SQL connection varieties
[NEW; assigned to libreoffice-bugs]
-
128514:
Query-GUI doesn't show any row with HSQLDB 2.5.0 / UNION-query - Tools > SQL will show the output
[UNCONFIRMED; assigned to libreoffice-bugs]
-
136637:
Firebird: Entering the sql command will cause Libreoffice to hang
[NEW; assigned to libreoffice-bugs]
-
150917:
Access2Base. The Properties method crashes on Database, Table or Report objects
[NEW; assigned to libreoffice-bugs]
-
155751:
dBase: BETWEEN won't include first and last value in queries
[NEW; assigned to libreoffice-bugs]
Bug 108443
blocks
one
open
bug:
view as bug list