server/sources/rql2sql.py
2012-07-09 Sylvain Thénault [rql2sql] remove debug print and fix bug introduced in 8469:69ad9a509bc3
2012-07-09 Sylvain Thénault [rql2sql] fix generated SQL when an attribute relation with a variable is ored with another attribute relation. Closes #2410405
2012-02-20 Julien Cristau [rql2sql] correctly handle modulo operator (closes #2192457) stable
2012-02-16 Sylvain Thénault [spelling] fix dictionnary -> dictionary typo stable
2011-10-04 Sylvain Thénault [rql2sql] support for outer join on column alias (closes #1979645) stable
2011-08-04 Sylvain Thénault [rql2sql] closes #1892473: enhance handling of optional inlined relation stable
2011-08-02 Sylvain Thénault [rql2sql] closes #1892471: support for unary expression introduced in rql 0.30 stable
2011-07-27 Sylvain Thénault [rql2sql] take care to boolean_value returning an int (eg sqlite/mysql) stable cubicweb-version-3.13.3
2011-07-27 Sylvain Thénault [sql] more test and fix boolean handling stable
2011-07-27 Sylvain Thénault [sql] fix querying of boolean value w/ sqlite stable
2011-07-27 Sylvain Thénault [sql gen] handle optional on comparison node (eg HAVING expression) and on rhs of final relation. Closes #1859609 stable
2011-07-27 Sylvain Thénault [rql2sql] don't introduce substitution for Int and Boolean constants. This is needed for COUNT(DISTINCT) support stable
2011-07-20 Sylvain Thénault [rql2sql] closes #1832859: fake HAVING terms w/ EXISTS terms
2011-07-11 Sylvain Thénault backport stable
2011-07-07 Sylvain Thénault closes #1784285: [rql2sql] crash when using a relation for inner and outer join stable
2011-06-29 Sylvain Thénault backport stable branch
2011-06-29 Sylvain Thénault [rql2sql] more cases fixed where something is wrongly added to GROUPBY, causing unexpected results for the query stable
2011-06-10 Sylvain Thénault [rql2sql] fix for some queries where eid variable used and entities picked as variable's table
2011-06-08 Sylvain Thénault backport stable
2011-06-08 Sylvain Thénault [rql2sql] fix missing sql restriction w/ attribute restriction where value comes from a subquery stable
2011-05-25 Sylvain Thénault backport stable
2011-05-24 Sylvain Thénault [rql2sql] closes #1697862: ORDERBY SUM(C) cancel GROUPBY by wrongly adding C to grouped variables stable
2011-05-19 Sylvain Thénault backport stable
2011-05-19 Sylvain Thénault [rql2sql] fix in 7394:d11d88bd08e8 was actually not needed stable
2011-05-19 Sylvain Thénault [rql2sql] fix generated sql for eid comparison. closes #1638695 stable
2011-05-10 Sylvain Thénault backport stable
2011-05-10 Sylvain Thénault [rql2sql] fix bug avoiding outer join relation to be used as a variable principal. Closes #1659395 stable
2011-04-27 Adrien Di Mascio [rql] basic support for regexp-based pattern matching
2011-04-27 Adrien Di Mascio [rql] support CAST() Function
2011-04-27 Sylvain Thénault [sql generation] fix crash on outer join + ambiguous inlined relation + attribute selection
2011-04-06 Sylvain Thénault backport stable
2011-04-06 Sylvain Thénault [sql generation] fix missing join with outer joins w/ rhs invariant variable... stable
2011-04-01 Sylvain Thénault [time zone] support for TZDatetime and TZTime data type
2011-03-22 Alexandre Fayolle Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation stable
2011-03-07 Sylvain Thénault [sql generation] fix exists table scope pb: when iterating other solutions inner to an EXISTS subquery, we should reset variables which have this exists node as scope stable
2011-02-06 Sylvain Thénault [rql2sql] should not select a neged relation as principal + simplify code for sql generation for attribute relation stable
2011-02-01 Sylvain Thénault [rql2sql] fix bug with NOT in "fake" having terms stable
2010-10-14 Sylvain Thénault [rql2sql] properly compute has_text relation table scope
2010-10-14 Sylvain Thénault pylint option update
2010-09-22 Sylvain Thénault [rql] fix bug with query like 'Any 1 WHERE NOT X in_group G': tables should be kept in EXISTS() even when there are no restriction stable
2010-09-17 Sylvain Thénault cleanup stable
2010-08-20 Sylvain Thénault [ms] more planning bug fixes stable
2010-08-02 Sylvain Thénault [rql2sql] add test for rql bug #37423, which triggered a cw bug fixed by this changeset (infinite loop with some queries...) stable
2010-07-21 Sylvain Thénault [rql2sql] fix bug with NOT of inlined relation: NULL values are not properly handled and hence some rows won't be returned while the should stable
2010-07-06 Sylvain Thénault backport stable
2010-07-06 Sylvain Thénault imported patch rql2sqlfix.diff stable
2010-07-05 Sylvain Thénault backport stable
2010-07-05 Sylvain Thénault [rql2sql] test and fix crash when OR in HAVING where both expresion are 'fake' having terms (eg not using aggregat function) stable
2010-07-01 Sylvain Thénault backport stable
2010-06-30 Sylvain Thénault [sql generation] fix bug with inlined relation and referenced by other neged relation stable
2010-06-21 Sylvain Thénault [rql2sql] #1089207: do not encode Unicode strings from RQL statements to db encoding
2010-06-21 Sylvain Thénault backport stable
2010-06-18 Sylvain Thénault [rql2sql] use new dbhelper.sql_concat_string function to deal with sql string concatenation. This together with lgdb 1.0.4 fixes #1055133: SQL Server support : string concatenation issue stable
2010-06-17 Sylvain Thénault [rql2sql] when using HAVING to by-pass rql limitation (not to filter on result of an aggregat function), we should emit SQL that doesn't use HAVING to avoid potential backend error because variables are not grouped. Closes #1061603. stable
2010-06-17 Sylvain Thénault [fti] support for fti ranking: has_text query results sorted by relevance, and provides a way to control weight per entity / entity's attribute
2010-06-10 Sylvain Thénault [rql2sql] fix special 'X relation NULL' case (used by security insertion), broken by recent removal of IS operator in RQL stable
2010-06-09 Sylvain Thénault [rql] more update to 0.26.2 api stable
2010-06-03 Sylvain Thénault HAVING sql clause don't know about comma... stable
2010-06-02 Sylvain Thénault [rql2sql] fix scope computation of variable from temporary table stable
2010-06-02 Sylvain Thénault [storage] source's callback has a new prototype, update usage stable
2010-05-26 Sylvain Thénault [rql2sql] properly compute scope for variable from temporary tables stable
2010-05-26 Sylvain Thénault [rql2sql] follow rql 0.26.1 changes: NOT nodes normalization, allowing simplification of sql generation, and fix #XXX stable
2010-04-28 Sylvain Thénault backport oldstable changes stable
2010-04-28 Sylvain Thénault replace logilab-common by CubicWeb in disclaimer oldstable
2010-04-28 Sylvain Thénault backport default into stable: stable is now cw 3.8
2010-04-28 Sylvain Thénault proper licensing information (LGPL-2.1). Hope I get it right this time. stable
2010-04-15 Sylvain Thénault backport stable
2010-04-15 Alexandre Fayolle added note about interesting page about SQL implementation differences stable
2010-03-25 Sylvain Thénault backport stable
2010-03-25 Sylvain Thénault [source storage] refactor source sql generation and results handling to allow repository side callbacks stable
2010-03-25 Sylvain Thénault [cleanup] rename dbms_helper to dbhelper for consistency stable
2010-03-24 Sylvain Thénault le patch rql26 a été importé
2010-03-09 Sylvain Thénault backport stable
2010-03-09 Sylvain Thénault [sql generation] fti_need_distinct quere was not anymore used, potentially causing duplicates on has_text queries with sqlite backend stable
2010-03-08 Sylvain Thénault [repo] use logilab.db instead of lgc.adbh/lgc.db/lgc.sqlgen/indexer, test new date extranction functions
2010-03-04 Sylvain Thénault [rql2sql] fix potential crash when testing _q_invariant on a ColumnAlias instead of a Variable by always considering _q_invariant to false for them stable
2010-02-26 Sylvain Thénault kill dead/useless code as suggested by pylint stable
2010-02-05 Sylvain Thénault fix long-waiting symetric typo: should be spelled symmetric. Add auto database migration on schema deserialization
2010-01-20 Sylvain Thénault fix bug: the 'table' argument is overwritten by the loop variable, causing latter crash due to this missing information stable
2010-01-07 Adrien Di Mascio update copyright: welcome 2010 stable
2009-12-16 Sylvain Thénault fix backout stable
2009-12-15 Sylvain Thénault backout a75a6e770717, unmeetable condition and introduce a bug with boolean values stable
2009-12-14 Alexandre Fayolle Passwords need to be considered as binary fields stable
2009-12-03 Sylvain Thénault héhé, get the same result with a slightly enhanced condition and all this code removed stable
2009-12-03 Sylvain Thénault unused, cleanup stable
2009-12-03 Sylvain Thénault fix sql generation bug with neged inlined relation where the object is invariant and subject is only referenced by the relation stable
2009-11-16 Sylvain Thénault fix potential key error stable
2009-11-16 Sylvain Thénault test and fix case where remove_unsused_solutions remove some solutions that should be kept stable
2009-11-10 Sylvain Thénault test and fix http://www.logilab.org/ticket/499838 stable
2009-10-28 Nicolas Chauvat C - fix typo. make `lgp check` happy. stable
2009-10-21 Sylvain Thénault prefix sql aliases for entity table by '_' to avoid pb with variable such as 'AS' (eg a keyword in SQL) stable
2009-10-20 Sylvain Thénault document stable
2009-10-20 Sylvain Thénault when a query is grouped, ensure sort terms are grouped as well stable
2009-10-19 Sylvain Thénault take care to already existant solutions local variable stable
2009-10-15 Sylvain Thénault follow yams 0.25 api changes to improve performance stable
2009-09-16 Sylvain Thénault cleanup 3.5
2009-09-16 Sylvain Thénault [querier] fix sql generated w/ NOT relation and shared variable: ensure variable's table is in parent select'scope 3.5
2009-08-18 Sylvain Thénault [rql2sql] test and fix a bug triggered when editing a ticket in jpl stable
2009-07-09 Sylvain Thénault ability to map attributes to something else than usual cw mapping on sql generation stable
2009-06-29 Sylvain Thénault fix sql generated on NOT inlined_relation queries. Use exists, so no more needs for extra DISTINCT stable
2009-06-09 Sylvain Thénault fix missing from close when using a var map stable
2009-05-28 Adrien Di Mascio big bunch of copyright / docstring update
2009-05-19 Sylvain Thénault #343322: should generate IS NULL in sql w/ None values in substitution stable
2009-05-14 Adrien Di Mascio delete-trailing-whitespace + some copyright update tls-sprint
2009-04-28 sylvain thenault backport default branch tls-sprint
2009-04-27 Adrien Di Mascio use dbmshelper to generate correct boolean value in rql2sql
2009-04-24 sylvain thenault backport default branch tls-sprint
2009-04-17 sylvain thenault rename internal entity types to have CW prefix instead of E tls-sprint
2009-04-16 sylvain thenault use adbh.func_sqlname for more backend compat
2009-04-07 sylvain thenault backport default branch tls-sprint
2009-04-06 sylvain thenault introduce a 'cw_' prefix on entity table and column names so we don't conflict with sql or DBMS specific keywords
2009-03-23 sylvain thenault remove some bw compat code tls-sprint
2009-03-23 sylvain thenault copyright update
2009-03-20 sylvain thenault fix rql2sq w/ outer join on subquery result
2009-01-16 sylvain thenault need_intersect test and fixes
2009-01-07 Sylvain Thenault consider intersect *and* distinct
2009-01-07 Sylvain Thenault in some cases (eg ambiguous neged relations), INTERSECT should be used instead of DISTINCT
2008-11-05 Adrien Di Mascio Showtime !
less more (0) tip