Bug 120062
depends on
677
bugs:
view as bug list
-
120062:
[META] Database related bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
97838:
Date control - earliest year value written is 1600
[NEW; assigned to libreoffice-bugs]
-
104790:
[META] Database connectivity interfaces (ODBC, JDBC..) and external databases
[NEW; assigned to libreoffice-bugs]
-
44069:
Request: Environment-variable like macros for ODBC/ADO/JDBC connection strings
[NEW; assigned to libreoffice-bugs]
-
46180:
FILEOPEN - LO Base fails to connect to "*.DBF" files but connects OK to "*.dbf"
[NEW; assigned to libreoffice-bugs]
-
46187:
Can't Connect Simultaneously Connect through Different JDBC Drivers
[NEW; assigned to libreoffice-bugs]
-
50747:
JDBC connector with subforms do not work, when there is no value in mainform (PostgreSQL, MySQL ...)
[REOPENED; assigned to libreoffice-bugs]
-
51780:
[META] Default to Firebird not HSQLDB in Base (for _new_ files)
[NEW; assigned to libreoffice-bugs]
-
105220:
Firebird: Insert with direct SQL - RETURNING without values
[NEW; assigned to libreoffice-bugs]
-
112491:
SDBC-mismatch on alter field-properties in embedded Firebird database when editing primary key
[NEW; assigned to libreoffice-bugs]
-
116935:
Firebird: Support for collation in the UI
[NEW; assigned to libreoffice-bugs]
-
116936:
Firebird SDBC should implement XRowUpdate interface
[NEW; assigned to libreoffice-bugs]
-
118094:
Firebird: Support more XResultSet functions
[NEW; assigned to libreoffice-bugs]
-
120596:
Firebird: Editing: Add support for UI data control update of Simple (updatable) views records.
[NEW; assigned to libreoffice-bugs]
-
120597:
Firebird: Edit: Update Create View UI to support Firebird 'WITH CHECK OPTION' for Simple (updatable) Views
[NEW; assigned to libreoffice-bugs]
-
123412:
Base: Unwanted disconnection from Firebird data source error message "connection shutdown caused by isc_service_attach"
[UNCONFIRMED; assigned to libreoffice-bugs]
-
123591:
Firebird - Incorrect Pasting of Numeric Data
[REOPENED; assigned to btomi96]
-
124054:
FIREBIRD: incorrect ASC order with varchar data
[NEW; assigned to libreoffice-bugs]
-
124340:
Firebird: Autovalue inconsistency when inserting values into table via macro
[NEW; assigned to libreoffice-bugs]
-
126941:
Date format with frontslashes (15/08/2019) will be changed to format with points (15.08.2019) when input data in a date-field of a tablecontrol of a form.
[NEW; assigned to libreoffice-bugs]
-
130345:
FIREBIRD: Impossible to create an autovalue key when inserting a new table
[NEW; assigned to libreoffice-bugs]
-
132693:
firebird - cannot execute multiple SQL commands in one go in Tools > SQL (driver does not implement sdbc::XMultipleResults)
[NEW; assigned to libreoffice-bugs]
-
132824:
EDITING: SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582
[NEW; assigned to libreoffice-bugs]
-
135616:
External text table assigned with SQL Statements is not visible in Firebird embedded server within Base
[NEW; assigned to libreoffice-bugs]
-
136637:
Firebird: Entering the sql command will cause Libreoffice to hang
[NEW; assigned to libreoffice-bugs]
-
140339:
CRASH: after closing firebird document
[NEW; assigned to libreoffice-bugs]
-
144256:
Missing destruction of FirebirdDriver::~FirebirdDriver, OSDBCDriverManager::~OSDBCDriverManager, OPoolCollection::~OPoolCollection opening and closing an ODB
[NEW; assigned to libreoffice-bugs]
-
144619:
FIREBIRD - support on disk structure for FB4 versions
[NEW; assigned to libreoffice-bugs]
-
145900:
Firebird: copy records will copy row with max value AutoValue primarykey instead of inserted value before refreshing row
[NEW; assigned to libreoffice-bugs]
-
147893:
Embedded firebird extends size of CHAR() data field beyond set boundaries and invokes error message
[NEW; assigned to libreoffice-bugs]
-
148096:
EDITING: Aliases ignored in form with SQL command as data source in embedded Firebird
[NEW; assigned to libreoffice-bugs]
-
148186:
Potentially confusing text label on Base Database Wizard when connecting to a Firebird file
[NEW; assigned to libreoffice-bugs]
-
148266:
Firebird: entering several SQL commands directly with delimiter impossible
[NEW; assigned to libreoffice-bugs]
-
148663:
Unable to insert an array in embedded firebird
[NEW; assigned to libreoffice-bugs]
-
151344:
Firebird LIST function (aka GROUP_CONCAT) gives #NA when linked to sheet
[NEW; assigned to libreoffice-bugs]
-
152044:
Deleted Firebird file is recreated when reopen Base file
[NEW; assigned to libreoffice-bugs]
-
152472:
LO Base leaves orphaned temp files after running a report from a Firebird database (Win-only)
[NEW; assigned to libreoffice-bugs]
-
156464:
FIREBIRD: AutoValue shows 0 for all new Entries in Query with Alias
[NEW; assigned to libreoffice-bugs]
-
156530:
FIREBIRD: Copying a table from one database file to another gives wrong decimal numbers.
[ASSIGNED; assigned to lionel]
-
51781:
Select a good replacement for embedded HSQLDB 1.8
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
69949:
EDITING - Firebird : does not respect AUTOVALUE NOT NULL setting via UI - no autoincrement/serial function
[RESOLVED FIXED; assigned to btomi96]
-
70425:
EDITING: Embedded Firebird - Copying integer values from Calc to Base impossible
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
70506:
EDITING: Embedded Firebird - Alias in queries are ignored
[RESOLVED FIXED; assigned to btomi96]
-
71007:
EDITING: Embedded Firebird - Impossible to set milliseconds in a timefield with GUI
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
71009:
EDITING: Embedded Firebird - Creating relationship in GUI impossible, but Firebird supports relations
[RESOLVED FIXED; assigned to btomi96]
-
71251:
EDITING - Embedded Firebird - Creating table from default choices via wizard fails
[RESOLVED FIXED; assigned to serval2412]
-
72827:
UI: FIREBIRD "View Refresh Tables" clears the list after tables created by "Tools Sql"
[CLOSED FIXED; assigned to serval2412]
-
72987:
[firebird db integration] big-endian LibreOffice unable to open little-endian embedded firebird db (found 2944.512, support 11.2)
[RESOLVED FIXED; assigned to rene]
-
74019:
FILEOPEN: Any table or select query having more than 10 fields cannot be opened in a database with embedded FireBird.
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
74172:
Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?
[RESOLVED FIXED; assigned to btomi96]
-
76072:
Not allowed to create view with embedded Firebird ?
[RESOLVED WORKSFORME; assigned to btomi96]
-
91324:
Embedded Firebird - Current_Date gives wrong date back
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
101399:
Embedded Firebird - DisposedException
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
101789:
FIREBIRD 3 - fails to build on OSX 10.11.6 with clang
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
103074:
FIREBIRD: Yes/No[BOOLEAN] type field is not available on edit table, but it is a new type on FB 3
[RESOLVED FIXED; assigned to btomi96]
-
103379:
Paste data in Firebird DB table fails
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
103384:
Closing a database with internal Firebird3 <Ctrl>+<W> and confirming to save the ODB leads to a hang
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
104227:
Firebird: Crash when changing data in a table and trying to switch to next row
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
104316:
FIREBIRD 3 : attempting to open a Firebird 3 embedded ODB database file fails to draw all UI elements, causes general LibreOffice UI malfunction
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
104734:
FIREBIRD: Add those field types that are not available with FB while they are available with Hsqldb
[RESOLVED FIXED; assigned to btomi96]
-
104918:
LibreOffice SQL parser chokes on Firebird's DATEDIFF syntax, making use impossible in normal (non-direct SQL) queries
[RESOLVED FIXED; assigned to jcsanz]
-
104957:
Embedded Firebird : conversion ODB files from Firebird 2.5 to Firebird 3.0 gives corrupted ODB files
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
104986:
Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY, MILLISECOND
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105062:
Firebird: Trying to close Firebird-DB without saving leads to hang of LO
[RESOLVED DUPLICATE; assigned to tml]
-
105075:
Firebird: Limit of query-GUI isn't supported
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105101:
Firebird: Division of Decimal and Integer gives wrong values
[CLOSED FIXED; assigned to btomi96]
-
105142:
FIREBIRD 3 - create default collation or character set on database creation
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105240:
Firebird: Insert NULL for auto value fails
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
105604:
Firebird error when creating a table containing a VARCHAR with by default value 32765
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105711:
FIREBIRD: Couldn't create a varchar-field with less than 20 characters in GUI
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
106463:
Data Records Not Saved to External Firebird Database File
[VERIFIED FIXED; assigned to lionel]
-
112715:
Table listboxes entries aren't shown in form with external Firebird3 database over ODBC on Windows
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
114755:
SQL error: extra parentheses
[VERIFIED FIXED; assigned to serval2412]
-
114810:
FIREBIRD: Tools > SQL doesen't respond to query, causes hang requiring forced kill
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115547:
Firebird: Link is formed to an external file with file:///C: (three slash)
[RESOLVED FIXED; assigned to mikekaganski]
-
116893:
Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
116943:
Disabling HSQLDB import filter for external HSQLDB engine
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
116953:
EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
117116:
Creation of database document with Firebird fails
[CLOSED INVALID; assigned to libreoffice-bugs]
-
117118:
Firebird: Saving of data should be done automatically
[RESOLVED FIXED; assigned to jcsanz]
-
117513:
Firebird: DATALOSS Data updated (new/edit) using the data Beamer window or Dataform in odt/ods file is lost when odt/ods file is closed.
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
117527:
Firebird: EDIT: Table creating in Design mode does not allow to change field properties "AutoValue" to "Yes" for suggested automatic default primary key field.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
117842:
Firebird: Enabling connection pooling for firebird:sdbc driver crashes Libo when creating connection to data engine
[RESOLVED FIXED; assigned to mikekaganski]
-
118809:
Firebird: XDatabaseMetaData implementation returns NULL strings for DatabaseProductName and DatabaseProductVersion
[RESOLVED FIXED; assigned to serval2412]
-
118817:
FIREBIRD: EXTRACT Function - WEEK, WEEKDAY, YEARDAY AND MILLISECOND
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
119628:
EDITING: Firebird Embedded: error message when resetting auto increment a second time
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
119962:
FireBird: Auto-Increase after copy table: Error inserting new data item.
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
120042:
FIREBIRD: Crash in: libc-2.27.so when Save As of an ODB overtop of an existing ODB if the target has been opened in current session
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
120640:
FIREBIRD: CHAR() - Values not appearing in base listbox with value list
[RESOLVED DUPLICATE; assigned to andreas.heinisch]
-
120713:
Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.
[RESOLVED FIXED; assigned to lionel]
-
120945:
FIREBIRD: Relationship of tables isn't recognized by formwizard
[RESOLVED FIXED; assigned to serval2412]
-
121477:
Firebird: Migration: Connection from form to subform impossible
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
121528:
FIREBIRD: Multiplication in a query with decimal or numeric values gives result without decimal separator
[RESOLVED FIXED; assigned to xiscofauli]
-
121553:
Editing: Firebird: Table editor erroneously prompts to change CLOB field to a BLOB field during alter table
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
121869:
Crash in: cppuhelper3MSC.dll FILEOPEN
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
121886:
Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls.
[RESOLVED FIXED; assigned to serval2412]
-
121965:
Firebird: Base crashed when I created a new table in design mode with long Cyrillic field name
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
122129:
Firebird: app must be forced to end after any use relation designer window - add table function causes immediate hang
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
122812:
Base Firebird: Time Format hh:mm:ss PM Broken
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
123150:
FIREBIRD: Query with 'LIKE' fails with error "malformed string", when index is set for the field of the condition of the query
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
125284:
Turkish locale ruins LibreOffice Base
[RESOLVED NOTOURBUG; assigned to caolan.mcnamara]
-
125941:
FIREBIRD: Tableeditor tries to change BLOB-Fields every time you will edit a table.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
125955:
BASE: FIREBIRD: Auto-value is incremented when input was aborted by Firebird database due to erroneous input
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
125957:
FIREBIRD: Datatype Binary(fix) [CHAR] couldn't be filled with content
[RESOLVED FIXED; assigned to serval2412]
-
126580:
EDITING: Firebird - Create as View gives error but creates the view in the background.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
126960:
EDITING: Firebird: Table editor instead of view editor
[RESOLVED FIXED; assigned to serval2412]
-
127180:
Firebird: propose migration + Firebird by default only in experimental
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
130334:
firebird direct connector fails to display tables with a field representing an array
[RESOLVED FIXED; assigned to serval2412]
-
130595:
FIREBIRD (internal): Parameter query with :parameter IS NULL doesn't work
[RESOLVED FIXED; assigned to serval2412]
-
130596:
FIREBIRD (internal): Parameter doesn't work with COALESCE and numeric fieldtypes
[RESOLVED FIXED; assigned to serval2412]
-
137042:
SQL Error -607, when changing Field type of a table (Firebird)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
137566:
FIREBIRD: some errors during - create Table and insert records via menue "tools/SQL"
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
138394:
FIREBIRD: truncated CLOB data
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
138409:
FIREBIRD: decimal fields in table are falsifying their default values
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
139320:
LO Vanilla - creating Firebird embedded ODB file on macOS Apple Silicon M1 throws error and creates unusable database file
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
146584:
Firebird: Setting default with ALTER TABLE gives useless message but sets default
[RESOLVED FIXED; assigned to serval2412]
-
56234:
RFE: please allow to link tables from different sources into one database file
[NEW; assigned to libreoffice-bugs]
-
57872:
make JDBC access faster
[NEW; assigned to libreoffice-bugs]
-
67145:
CRASH: ODBC - Firebird: Attempting to edit table definition causes abort
[NEW; assigned to libreoffice-bugs]
-
67649:
Postgresql SDBC updatable views
[NEW; assigned to libreoffice-bugs]
-
68675:
ODBC: support arbitrarily-sized bookmarks
[NEW; assigned to libreoffice-bugs]
-
68676:
ODBC: optionally use W variants of ODBC calls
[NEW; assigned to libreoffice-bugs]
-
77428:
EDITING: Link field is corrupted with H2 JDBC
[NEW; assigned to libreoffice-bugs]
-
80084:
sort out ownership of resultset returned by "X(Prepared)?Statement::execute(Query|Update)?"
[NEW; assigned to libreoffice-bugs]
-
86621:
direct SQLite open
[NEW; assigned to libreoffice-bugs]
-
88601:
LO BASE: Failure to correctly interpret range for UNSIGNED integers from MySQL database (jdbc and native connectors) [summary in comment 9]
[NEW; assigned to libreoffice-bugs]
-
88796:
Enhancement - Mysql native connector extension - add automatic reconnect to server capability in connector code after idle timeout
[NEW; assigned to libreoffice-bugs]
-
90520:
Base crashes with Oracle ODBC driver when sorting/filtering
[NEW; assigned to libreoffice-bugs]
-
92880:
CopyFromRecordset function not working since 4.x
[NEW; assigned to libreoffice-bugs]
-
92950:
No support for sqlite relations via Relations menu
[NEW; assigned to libreoffice-bugs]
-
93849:
Allow specifying the JDBC jar in the Database Wizard
[NEW; assigned to libreoffice-bugs]
-
96686:
Insert data in temporary MySQL/MariaDB-Table through GUI impossible
[NEW; assigned to libreoffice-bugs]
-
100427:
UI - Register database dialog should allow multiple files to be selected and registered
[NEW; assigned to libreoffice-bugs]
-
113372:
[META] Microsoft Access connectivity bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
116253:
With MariaDB JDBC connection & Filter property set, an empty Combo Box shows 'NULL' when record inserted
[NEW; assigned to libreoffice-bugs]
-
116878:
"Password required" no longer available for existing spreadsheet connection
[NEW; assigned to libreoffice-bugs]
-
116968:
[META] Migrating existing embedded HSQLDB databases to Firebird
[NEW; assigned to libreoffice-bugs]
-
116970:
[META] HSQLDB removal blockers
[NEW; assigned to libreoffice-bugs]
-
119135:
Display of field type as TIMESTAMP set via UI for mysql table is systematically modified to DATETIME.
[NEW; assigned to libreoffice-bugs]
-
119139:
Mysql timestamp fields, set as ON UPDATE CURRENT_TIMESTAMP, not displayed in table data entry mode with mysql jdbc-connector ConnectorJ 8.x
[NEW; assigned to libreoffice-bugs]
-
119431:
External database jdbc hsqldb, Crash in the case of SELECT, SQL query, access to the database
[NEW; assigned to libreoffice-bugs]
-
119927:
[META] MariaDB C API
[NEW; assigned to libreoffice-bugs]
-
124022:
Unhardcode different driver default settings
[NEW; assigned to libreoffice-bugs]
-
124531:
PostgreSQL Native Driver: Unable to create view through Base-GUI
[NEW; assigned to libreoffice-bugs]
-
130376:
PostgreSQL JDBC and Direct Connection: Autoincrement doesn't return values in Queries with Alias
[NEW; assigned to libreoffice-bugs]
-
131238:
SQLite/ODBC: LibreOffice fails Unicode compliance with multi-byte characters, such as emoji, for example 😂
[UNCONFIRMED; assigned to libreoffice-bugs]
-
141579:
Create Query in Design View Query Builder build SQL that aliases table name to itself causing some ODBC and JDBC database queries to fail
[UNCONFIRMED; assigned to libreoffice-bugs]
-
143317:
Base crashes viewing / browsing mysql database table using direct mysql connector
[NEEDINFO; assigned to libreoffice-bugs]
-
147582:
PostgreSQL JDBC: Form with Subform and SubSubform gives Parameter Error for SubSubForm
[NEW; assigned to libreoffice-bugs]
-
148186:
Potentially confusing text label on Base Database Wizard when connecting to a Firebird file
[NEW; assigned to libreoffice-bugs]
(*)
-
149284:
LO Base freeze when using a form with macro to enter MySQL data
[UNCONFIRMED; assigned to libreoffice-bugs]
-
152370:
MariaDB direct connection: Access through socket to separate instance of MariaDB impossible
[NEW; assigned to libreoffice-bugs]
-
153431:
PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
[NEW; assigned to libreoffice-bugs]
-
154464:
PostgreSQL direct connection: Prepared statement with setArray leads to crash of LO
[NEW; assigned to libreoffice-bugs]
-
155183:
FIREBIRD: Dialog User Administration won't change anything with Firebird
[NEW; assigned to libreoffice-bugs]
-
155529:
MariaDB/MySQL direct connection: Trying to insert NULL in NOT NULL fields will automatically changed in empty text or 0
[NEW; assigned to libreoffice-bugs]
-
158406:
Calc: data connectors (ODBC, OLEDB....) and query builder just like Excel
[NEW; assigned to libreoffice-bugs]
-
160375:
Base does not manage relationships outside the default catalog/schema
[ASSIGNED; assigned to prrvchr]
-
43369:
Specific UI for collecting PostgreSQL connection settings
[RESOLVED FIXED; assigned to nirnaykorde]
-
46259:
rewrite mysql connector to use mariadb client library
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
52310:
Calling Relations tool with LO Base and mysql native connector appears to freeze LO pushing user to force kill the app
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
59204:
ODBC - data loss when editing mysql VARCHAR or CHAR fields using Actual Technologies ODBC driver
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
60217:
error message limited to a dot when mysql native connector is used
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
68341:
pilot class for MySQL should ignore spaces at begining and and of the class name
[RESOLVED FIXED; assigned to serval2412]
-
81430:
libreoffice-mysql-connector cannot create/edit tables without primary key
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
85148:
FILEOPEN: Firebird connect to server via new driver (feature request)
[RESOLVED FIXED; assigned to jcsanz]
-
92322:
EDITING - MEMO (TEXT) fields refuse data entry with MySQL and JDBC connector on OSX
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
92847:
Append table alias name Database Advanced Settings overriden by database metadata from JDBC data source
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
93094:
Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
93095:
EDITING - sqlite3 table fields considered as SQLNull datatype in table creation mode using Xerial jdbc driver (OSX)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
93348:
Base crashes when entering login information for jdbc connection to MariaDB database (Windows 64bit)
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
95191:
Forms and dialogs opened via macros on ODB file open no longer work
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
99032:
FILEOPEN: Fail to open Table from dictionary using Advantage Data Server JDBC and ODBC.
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
99978:
MariaDB/MySQL - JDBC: Field not shown in table/query, if set ON UPDATE CURRENT_TIMESTAMP
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
103068:
New Database Wizard gets confused between ODBC and JDBC connection if you backup twice to step 1.
[RESOLVED FIXED; assigned to mikekaganski]
-
112423:
MySQL native connector "Commands out of sync..." when calling procedure second time. - Crash
[RESOLVED FIXED; assigned to lionel]
-
119694:
HSQLDB driver not loading causes BASE error in embedded hsqldb database
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
120091:
Some LO Base views with conversions or casting on datetime fields causing error message "the data content could not be loaded" with MySQL Connector/J 8 (not with with MySQL Connector/J 5). SQL Status: S1009 Parameter index out of range (1 > number of para
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
120695:
FILEOPEN unixODBC connection to sqlite database not working
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
122306:
BASE : after i updated to Versiune: 6.1.4.2 the tables imported in base (odb) from ODBC are empty (no records)
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
122516:
Mysql/MariaDB - native connector timestamp values displayed as floating numbers in Table data entry mode
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
122967:
EDITING: Saving data into FB3.0 file impossible when only writing data into a table
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123930:
BASE Entering dates in table control retains wrong date - mariadb backend and mysldb JDBC connector
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
124530:
PostgreSQL Native Driver: Images aren't shown in form when content of field is created in query
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124759:
ODBC - DB2 database access - First row missing from Base query results.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124773:
VIEWING: External database jdbc hsqldb, Crash in the case of SELECT, SQL query, access to the database. Crash in: sal3.dll
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
126624:
Suggested database connection string parameters incorrect in URL entry dialog
[RESOLVED FIXED; assigned to serval2412]
-
128591:
ODBC/SQL Server/datetimeoffset column breaks form creation wizard
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
130540:
FIREBIRD JDBC: Tableeditor will show all Integer-Types as Currency Format
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
140071:
Too long to get data when it get 'Refresh' on pivot table option
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
150295:
JDBC exception stack trace lost
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
153317:
MySQL/MariaDB direct connection: Content of field type 'Bit' isn't shown in Tools → SQL
[RESOLVED FIXED; assigned to serval2412]
-
153940:
Create a new help page explaining how to setup a Firebird connection
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
108440:
[META] Database form bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
42120:
optionally treat filter values as matching patterns
[NEW; assigned to libreoffice-bugs]
-
43928:
EDITING Forms - tabstops in tablecontrols could not be changed
[NEW; assigned to libreoffice-bugs]
-
49145:
EDITING: Form-Wizard should propose listfields for foreign keys in a table
[NEW; assigned to libreoffice-bugs]
-
49328:
EDITING: Relations form-subform, suggested when editing forms, won't work right
[NEW; assigned to libreoffice-bugs]
-
50684:
UI: Currency-fields in forms should get additional FORMATTING fields for Color, conditional formatting
[NEW; assigned to libreoffice-bugs]
-
50816:
EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms
[NEW; assigned to libreoffice-bugs]
-
51727:
EDITING: Tabstops for tablecontrols aren't set to "no" - only after switching to "yes" and then to "no"
[NEW; assigned to libreoffice-bugs]
-
51868:
"Find Record": search through all subforms
[NEW; assigned to libreoffice-bugs]
-
54021:
EDITING: Fields in tablecontrols of a form could not be moved/sorted
[NEW; assigned to libreoffice-bugs]
-
56612:
EDITING - Base problem with boolean field that defaults to unintended value
[NEW; assigned to libreoffice-bugs]
-
58586:
EDITING : Autofilter complete ignored, when content is defined by a Subselect
[NEW; assigned to libreoffice-bugs]
-
61297:
UI - Forms incorrectly switching from print to web layout and back
[NEW; assigned to libreoffice-bugs]
-
61949:
EDITING: Form designer should make available property fetchSize
[NEW; assigned to libreoffice-bugs]
-
67741:
EDITING: Date entry with numeric keypad
[NEW; assigned to libreoffice-bugs]
-
71275:
Other: Enhancement - Number of all records should be shown in a form, not only 41*
[NEW; assigned to libreoffice-bugs]
-
71954:
EDITING: drag and drop text into database form fields will not get stored
[NEW; assigned to libreoffice-bugs]
-
82318:
Form editing repositioning of screen, away from control being edited
[NEW; assigned to libreoffice-bugs]
-
82320:
Form properties should include static width, depth.
[NEW; assigned to libreoffice-bugs]
-
82411:
Numeric fields are limited to Integer-Values in Tablecontrols and Databrowser of a Form
[NEW; assigned to libreoffice-bugs]
-
84069:
LO BASE Forms: Contents of Unbound Field Improperly Reset When Advancing Row Cursor to Insert Row
[NEW; assigned to libreoffice-bugs]
-
84070:
LO BASE Forms: On Unbound Form, List Is Disabled
[NEW; assigned to libreoffice-bugs]
-
88552:
Event "Text modified" never happens in a combobox inside a tablecontrol
[NEW; assigned to libreoffice-bugs]
-
88560:
Wrong Date-input in form gives different values, depended on fieldproperties
[NEW; assigned to libreoffice-bugs]
-
88704:
possible regression introduced by "fdo#88551 no need to update content from field when activating grid cell"
[NEW; assigned to libreoffice-bugs]
-
91752:
Libre base recommendation to load forms at startup
[NEW; assigned to libreoffice-bugs]
-
92588:
BASE: please implement macro trigger with buttons in normal way
[NEW; assigned to libreoffice-bugs]
-
92617:
Base is crashing frequently when EDITING data and switching Forms
[REOPENED; assigned to libreoffice-bugs]
-
92937:
tab order in base form initially inactive
[NEW; assigned to libreoffice-bugs]
-
93287:
Cannot TAB through all Controls on Form with Form window smaller than maximum surface occupied by controls
[NEW; assigned to libreoffice-bugs]
-
96056:
Toggle form/datasheet in form
[NEW; assigned to libreoffice-bugs]
-
96190:
Date in Form shows different values in Datefield and Formatted Field, if based on an integer Column
[NEW; assigned to libreoffice-bugs]
-
97840:
EDITING: table's or field's name does'n get updated in the forms
[NEW; assigned to libreoffice-bugs]
-
98382:
Listbox in a table of a form doesn't follow its alignment property
[NEW; assigned to libreoffice-bugs]
-
100367:
Allow main form filtering by subform values with form-based filter
[NEW; assigned to libreoffice-bugs]
-
103557:
Add syntax to reference form input boxes from queries (pass values)
[NEW; assigned to libreoffice-bugs]
-
103862:
UI: Missing read-only option in form designer for check box
[NEW; assigned to libreoffice-bugs]
-
105051:
Form Navigator: for "Forms" change properties title from "No control selected" to "No form selected"
[NEW; assigned to libreoffice-bugs]
-
107788:
Easy means to clear a selection
[NEW; assigned to libreoffice-bugs]
-
108342:
BASE, Editing: list field in table grid shows status row changed on opening form when it's first column
[NEW; assigned to libreoffice-bugs]
-
108471:
In a Form Table Control the Default time is not working in Date/Time (time) fields.
[NEW; assigned to libreoffice-bugs]
-
108547:
When moving to insert a new record, unbound controls should not get cleared
[NEW; assigned to libreoffice-bugs]
-
112059:
Events fired by subform changed, when form is write-protected
[NEW; assigned to libreoffice-bugs]
-
112273:
Add API method to reload a form with same parameter
[NEW; assigned to libreoffice-bugs]
-
114814:
EDITING: Form Table control Field Copy disfunctional
[NEW; assigned to libreoffice-bugs]
-
115096:
For a Pattern Field please reverse the order of the mask related properties
[NEW; assigned to libreoffice-bugs]
-
115099:
Pattern Field: Improve property names related to the masking operation.
[NEW; assigned to libreoffice-bugs]
-
115619:
Editing form size changes all form sizes
[NEW; assigned to libreoffice-bugs]
-
117792:
Maximised windows for forms or reports in Base are reopened bigger than the actual window (Windows-only)
[NEW; assigned to libreoffice-bugs]
-
117793:
Default fonts in Base form controls cannot be changed
[NEW; assigned to libreoffice-bugs]
-
121652:
Option buttons in forms do not show current value if it is boolean
[NEW; assigned to libreoffice-bugs]
-
121995:
Form preview shows content of the form very confused
[NEW; assigned to libreoffice-bugs]
-
141289:
Usability : Base Form Label creation does not create label at the expected place when user only clicks
[NEW; assigned to libreoffice-bugs]
-
143389:
PDF-Export: Content of a date field in a form won't be shown in exported document
[NEW; assigned to libreoffice-bugs]
-
143418:
FORMCONTROL Date: No possibility to choose "Today" as default date
[NEW; assigned to libreoffice-bugs]
-
144436:
LO Base nested forms exhibit incorrect navigation when using tab key (Windows-only)
[NEW; assigned to libreoffice-bugs]
-
148096:
EDITING: Aliases ignored in form with SQL command as data source in embedded Firebird
[NEW; assigned to libreoffice-bugs]
(*)
-
148344:
Forms: Previews of a form won't be saved while creating a form
[NEW; assigned to libreoffice-bugs]
-
149725:
Database Form Design Navigator is always repositioned at top left corner on French interface
[NEW; assigned to libreoffice-bugs]
-
151186:
[UI] Create form wizard does not go back to subform screen (skips over it)
[NEW; assigned to libreoffice-bugs]
-
151861:
Navigation bar of Forms: Standard Filter is missing - only Form Based Filters available
[NEW; assigned to libreoffice-bugs]
-
153057:
Calc and Base can not filter time values
[NEW; assigned to libreoffice-bugs]
-
153157:
Navigation in formular table control with tabulator: very slow and skips unexpected to subformular
[NEW; assigned to libreoffice-bugs]
-
155175:
Forms: Buttons should support opening Forms, Reports, Tables and Queries
[NEW; assigned to libreoffice-bugs]
-
155401:
Forms - Navigation: Moving by Tilde (Alt+…) only works with Tab Order = 0 for all fields
[NEW; assigned to libreoffice-bugs]
-
157039:
Method to clear search text drop down list in Base form
[NEW; assigned to libreoffice-bugs]
-
157931:
Top right close button fails to close form
[NEW; assigned to libreoffice-bugs]
-
73139:
PRINTING: Content of Tablecontrols isn't printed, when the whole Fonts are default (black) text color
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
88551:
Event "Text modified" happens in tablecontrol while navigating through form without modifying anything
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
91761:
Crash when copying contents from one form to another form
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
94341:
Total record number overwritten in record toolbar control on form
[RESOLVED FIXED; assigned to mikekaganski]
-
102138:
Base doesn't show Table Element Wizard window when creating subform on a form
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
105088:
"Control" and "Form" in Form context menu should be followed by "properties" to make the purpose clearer
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105446:
Copying forms not working anymore
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108203:
EDITING Within Form Edit mode, Copy and paste an action button makes LibreOffice frozen, with high CPU usage
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
108413:
Text in form text fields no longer visible
[VERIFIED FIXED; assigned to erack]
-
108701:
[Feature Request] Open Forms with a Button Action without having to create a Macro
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
112590:
Base forms open maximum size each time with GTK3 VCL backend
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
114596:
External forms for a database doesn't save data - closing form with dataloss ( see comment 30 )
[RESOLVED FIXED; assigned to xiscofauli]
-
115447:
Missing Table Control and other icons in More Controls bar
[RESOLVED FIXED; assigned to philipz85]
-
117347:
All labels disappear in Base Form if a selected field is not within visual display area
[VERIFIED FIXED; assigned to vmiklos]
-
120423:
LibreOffice Base -> can't insert special character in a form
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
122219:
CRASH: closing Base while XML filter settings dialog is open
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
122298:
Charts in Base-Forms couldn't be changed by macro any more
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
122358:
Forms: Right and bottom borders of form-controls set to 'FLAT' style not displayed (gtk3)
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
122408:
linked subform shows empty when slave field is a function call
[RESOLVED FIXED; assigned to lionel]
-
122661:
FORMS: Borders of form-controls set to 'FLAT' style are so narrow and light as to be all but lost to view
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123778:
Frequent crashes in sal3.dll when EDITING forms.
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
125954:
Form wizard creates separate form controls inside a tablecontrol
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
126731:
Editable pictures display as grey instead of colour in a LibreOffice Base form based on a read-only datasource
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
132978:
LO Base: Print Form made from query, can't see the records in result.pdf
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
141633:
VIEWING: Font Display in tableviews distorted, abnormal size of selected fields
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
152614:
Database Form Creation Wizard incorrectly distributes form controls in document.
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
153756:
Unable to open form wizard (GTK3)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
161133:
Date field in Table Control's read-only column can be edited with date picker
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
108441:
[META] Database table bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
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]
-
91976:
table control: insert fails because of database error, macro refreshes query, repeat -> crash
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
116772:
Using LIKE in query assistant
[RESOLVED FIXED; assigned to lionel]
-
144340:
A query against an embedded FB database fails, and then crashed program on close on Windows
[RESOLVED FIXED; assigned to mikekaganski]
-
108444:
[META] Database report bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
108445:
[META] Database import/open bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
113375:
[META] Database wizard bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
114293:
[META] Address Book Data Source bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
120060:
[META] Data source view bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
125502:
Changing database through "exchange database" creates *.odb-files for unusable fileformats
[NEW; assigned to libreoffice-bugs]
-
137043:
[META] HSQLDB database related bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
147110:
Search in record not shown and not Cancel button
[NEW; assigned to libreoffice-bugs]
-
155308:
Dialog Record Search in Base forms: Wrong activated button "Help" instead of "Search"
[NEW; assigned to libreoffice-bugs]
-
146295:
Base linked to txt or csv files crashes on filter dialog
[RESOLVED FIXED; assigned to libreoffice-bugs]
Bug 120062
does not block any bugs.