.. -*- coding: utf-8 -*-

Version 1.6.2
-------------
:publication date: 2011/07/27
:expected date: n/a

Ticket #64989 add support for CAST operation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: enhancement
:state: validation pending

SQL-92 supports CAST through the CAST(<expr> as <type>) instruction.

logilab-database could provide a CAST function that would be used as in
``CAST(type, expr)``.

Ticket #69607 backup_commands() for sqlite deletes the db
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:state: validation pending

logilab/database/sqlite.py: return [['gzip', dbname], ['mv', dbname + '.gz',
backupfile]]

This results in dbname not existing afterwards, because gzip deletes it after
compressing it. This kind of breaks cubicweb-ctl upgrade since the first step is
to make a backup of the db.

Comments ::

  On 2011/06/24 08:34 - jcristau wrote :
  restore also doesn't seem to work because it expects a .gz extension, but the
  gzipped dump is stored as 'system' (no extension) in the backup.

Ticket #71413 bad checking of maximum number of function's arguments
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:load: 0.100
:state: validation pending

Ticket #70382 Can't upgrade on ubuntu natty
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:state: validation pending

I get ::

Preparing to replace python-logilab-database 1.3.3-1 (using
.../python-logilab-database_1.6.0-1_all.deb) ... Unpacking replacement
python-logilab-database ... dpkg: error processing
/var/cache/apt/archives/python-logilab-database_1.6.0-1_all.deb (--unpack):
trying to overwrite '/usr/share/pyshared/logilab/__init__.py', which is also in
package python-logilab-common 0.56.0-1 Processing triggers for python-support
... Errors were encountered while processing:
/var/cache/apt/archives/python-logilab-database_1.6.0-1_all.deb

Comments ::

  On 2011/07/04 08:41 - alutz wrote :
  temporary fix ::
  
  dpkg --force-overwrite -i
  /var/cache/apt/archives/python-logilab-database_1.6.0-1_all.deb

Ticket #69471 exclude numbers from stop words list in fti parser
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: enhancement
:state: validation pending

We want to be able to search numeric value in attributes.

So, `normalize(word)` could be updated not to refuse numbers for indexing.

Ticket #71414 support for COUNT(DISTINCT ...)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:load: 0.100
:state: not validated

Ticket #70253 sqlserver helper failure on some sql_add_limit_offset calls in CW
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:load: 1.000
:state: validation pending

sometimes int('some arg') fails because we are called without a column index.

Ticket #70982 sqlserver: smalldates are not postprocessed if the query is fetched with fetchmany
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:type: bug
:load: 0.250
:state: validation pending

no wrapper doing the postprocessing is provided for fetchmany, hence we default
on the native cursor implementation, breaking CW.