* Thu Apr 11 2019 wbauer@tmo.at
- Update to 3.2.0
* New features / APIs
+ Add Date/Time classes for precise type support (kde#393094)
+ Add support for the Date/Time constants in the SQL parser
(kde#393094)
+ Add KDbConnection::drv_getTableNames for low level list of
table names, make tableNames() skip names with non-existing
physical tables (kde#392112)
+ Rework KDbConnection::drv_getTableNames API so error
information is passed
* Bug fixes
+ Fix crash in KDbConnection::recordCount(KDbTableSchema)
+ Fix loading object data for given type and ID (kde#393705)
+ Escape column and table aliases in queries as needed
+ Fix input of large unsigned int values (>0x7FFFFFFF)
(kde#395225)
+ Fix handling ORDER BY part of queries (kde#392753)
+ Fix detection of .kexi file types after recent change of MIME
database for SQLite type (2018-06-17) (kde#396999)
+ More reliable resolving plugin MIME types - before adding
metadata (Thanks to Pino Toscano)
* Improvements
+ Add quotes when escaping identifiers only when string is not
empty, invalid identifier or KDBSQL keyword
+ KDbUtils::stringToFileName(): Prepend '_' to recent project
filenames that start with "." so files are not hidden
+ Improve transliteration features by switching to unidecode
* MySQL / MariaDB support
+ Improve MariaDB detection on Windows builds, separately
from MySQL
* SQLite support
+ Fix loading value: Incorrect display of large unsigned int
(>0x7FFFFFFF) (kde#394913)
* PostgreSQL support
+ CMake: find PostgreSQL 11
* Tests
+ HeadersTest: Use install_manifest.txt to obtain list of
files, this improves accuracy, no need for blacklisting
+ KDbTestUtils: add convenience APIs for connecting and using
db, support connection options
+ Add autotests for checking detection of every mime type that
should be supported
+ Add autotests for the new Date/Time related features
* Buildsystem
+ Copy new FindICU.cmake from cmake and port to it
+ ICU is required so do not check for it again in the sqlite
driver's build
- Run spec-cleaner
* Thu Mar 14 2019 wbauer@tmo.at
- BuildRequire postgresql-server-devel instead of postgresql-devel
on Tumbleweed to fix build with the latest postgresql version
Version: 3.1.0-bp150.1.3
* Tue Mar 20 2018 wbauer@tmo.at
- Update to 3.1.0:
* General
+ Bump soname for the libraries to separate from incompatible
3.0.x versions
+ Add Python 3 support for the buildsystem
* API changes
+ See https://community.kde.org/Kexi/Releases/3.1.0_Changes for
details
* Bug fixes
+ Fix SQLite database compacting: canceling issue of the
progress dialog and finalizing the compacting
+ Compacting: close the progress dialog also on error in
SQLite3 processing; fix propagating error status to the GUI
+ SQLite driver: don't clear set of paths in
extraSqliteExtensionPaths Connection property if exists
+ Add safer debug for large values
+ Fix issues because of using " quotes for identifiers in
SQLite driver (kde#376052)
+ Query parsing: try harder to locate positions of table/table
aliases
+ Connection dialog: make message handler optional, return
result, accept on success
+ Fix KDbNativeStatementBuilder API: connection is always
needed
+ Add COLLATION keywords when generated statements are native,
otherwise KDbSQL string is invalid (kde#379447)
+ Fix generating of SQL statements if there are tables used
having lookup fields based on queries (kde#385417)
+ Aesthetics: generate "SELECT FROM ..." statements with
exactly one space after SELECT
+ Fix crash when generating "SELECT a.* FROM a, b" statements
+ Generate automatic ORDER BY only for native SQL statements
+ Raise SQL parse error when alias is duplicated for columns,
e.g. "SELECT foo AS a, bar AS a FROM t"
+ Raise SQL parse error when alias is duplicated for tables,
e.g. "SELECT * FROM foo AS a, bar AS a"
+ Expand scope of KDbTableSchemaChangeListener to allow
registering queries for changes in table schema (kde#371896)
+ Properly unregister table from listeners before dropping
+ Setup query in connection: parsing failure can delete the
query object so do not try to access it
+ Query schema: fix possible crashes - explicitly/properly
remove query from connection's cache when needed
+ Query schema: fix memory leaks - remove internal expressions
* Optimizations
+ Don't create temporary table schema object when checking for
existence in createTable()
+ Don't create temporary table or query schema object when
checking for existence object with empty name
* Docs and examples
+ Update README-PACKAGERS doc to reflect naming and notes about
compatibility
+ Enable creation of API docs QCH file during the build
* Wed Feb 28 2018 wbauer@tmo.at
- Add python-base build requirement to fix build in Leap 15
* Sat Aug 12 2017 wbauer@tmo.at
- Update to 3.0.2:
* General
- Fix possible issue: the WHERE condition can be lost while
converting query to SQL. This can be seen in Kexi Query
Designer.
- Validate query and offer error message/description while
setting or extending WHERE conditions
- Fix WHERE conditions handling
- Make query parameters also work in COLUMNS section. Kexi
query parameters do not work in COLUMNS section, e.g. this
won't work ('invalid query' error appears): SELECT [Param].
The parameters work only in the WHERE section, e.g. SELECT
123 WHERE [Param] = 1. (kde#348473)
- Support queries such as "SELECT FROM table WHERE condition"
for completeness
* Buildsystem
- Add detection for PostgreSQL 10
- Improve information about recommended packages
(for drivers, python, etc.)
- Improve SQLite detection
- FindMySQL script: for Windows use "ProgramFiles(x86)"
environment variable to locate "Program Files (x86)" folder
and find MySQL/MariaDB libs there
- FindMySQL script: fix it if CMAKE_BUILD_TYPE is not
specified (Windows)
* Tests
- Fix HeadersTest for paths containing spaces
- Add tests related to query parameters to the parser test
* Fri Apr 28 2017 wbauer@tmo.at
- Fix the -lang package Recommends
* Tue Apr 04 2017 wbauer@tmo.at
- Update to 3.0.1.1:
* General
- Check result of closing database while testing connection
(ConnectionTestThread)
- Make it possible to set row source values for lookup column
back to empty list
- Fix setting properties for lookup column
(record source related) (kde#371958)
- Fix identifying table properties as related to lookup field
(kde#371958)
- Add safer debug for large values (internal in 3.0.1)
* PostgreSQL support
- Fix database cursors for PostgreSQL: remove use of
uninitialized variable (kde#371331)
- Fix error on repeated loading of "fuzzystrmatch" extension
for the PostgreSQL driver
* Buildsystem
- Make it possible to find PostgreSQL 9.6
- Improve support for Qt Translation catalogs
(use ecm_install_po_files_as_qm macro)
- Fix finding KDb config
(use ecm_configure_package_config_file macro)
- Add PROJECT_STABLE_VERSION_PATCH constant, extend logic for
PROJECT_STABLE* constants
- Improve discovery of PostgreSQL library on Windows
- Improve searching for the MySQL driver build dependencies
- SDC: initialize all variables in from-map constructors
regardless of errors, add {} to conditions, improve spacing
- Suppress warnings about duplicated drivers if
KDB_NO_DUPLICATED_DRIVER_WARNINGS environment variable is set
- Replace KF5I18n BuildRequires with Qt5LinguistTools, that is used
now for installing the translations
* Mon Jan 23 2017 wbauer@tmo.at
- Adjust the package Supplements, they were ineffective as there is
no kdb package
* Wed Jan 11 2017 jengelh@inai.de
- RPM group fix
* Sun Jan 08 2017 tittiatcoke@gmail.com
- Initial package based on version 3.0.0