server/sources/rql2sql.py
Fri, 25 Oct 2013 12:23:06 +0200 Sylvain Thénault [rql2sql] fix relation table scope when some variable from subquery is used. Closes #3252270 stable
Fri, 30 Aug 2013 09:57:38 +0200 Sylvain Thénault [rql2sql] fix bad sql generated when outer joining 'identity' relation and lhs var comes from a subquery. Closes #3099418 stable
Mon, 15 Jul 2013 10:59:34 +0200 Sylvain Thénault [rql rewrite] move some code from querier to rqlrewrite where it makes more sense. stable
Fri, 19 Apr 2013 15:44:42 +0200 Sylvain Thénault [rql2sql] Remove an XXX by explaining why Int non-substitution is desired
Fri, 19 Apr 2013 15:41:56 +0200 Sylvain Thénault [rql2sql] Boolean values should be substitued like others. Closes #2829481
Mon, 09 Jul 2012 13:57:23 +0200 Sylvain Thénault [rql2sql] remove debug print and fix bug introduced in 8469:69ad9a509bc3
Mon, 09 Jul 2012 12:22:43 +0200 Sylvain Thénault [rql2sql] fix generated SQL when an attribute relation with a variable is ored with another attribute relation. Closes #2410405
Mon, 20 Feb 2012 11:32:06 +0100 Julien Cristau [rql2sql] correctly handle modulo operator (closes #2192457) stable
Thu, 16 Feb 2012 14:14:52 +0100 Sylvain Thénault [spelling] fix dictionnary -> dictionary typo stable
Tue, 04 Oct 2011 10:15:45 +0200 Sylvain Thénault [rql2sql] support for outer join on column alias (closes #1979645) stable
Thu, 04 Aug 2011 12:50:48 +0200 Sylvain Thénault [rql2sql] closes #1892473: enhance handling of optional inlined relation stable
Tue, 02 Aug 2011 17:31:06 +0200 Sylvain Thénault [rql2sql] closes #1892471: support for unary expression introduced in rql 0.30 stable
Wed, 27 Jul 2011 19:36:42 +0200 Sylvain Thénault [rql2sql] take care to boolean_value returning an int (eg sqlite/mysql) stable cubicweb-version-3.13.3
Wed, 27 Jul 2011 18:08:39 +0200 Sylvain Thénault [sql] more test and fix boolean handling stable
Wed, 27 Jul 2011 15:42:02 +0200 Sylvain Thénault [sql] fix querying of boolean value w/ sqlite stable
Wed, 27 Jul 2011 14:22:32 +0200 Sylvain Thénault [sql gen] handle optional on comparison node (eg HAVING expression) and on rhs of final relation. Closes #1859609 stable
Wed, 27 Jul 2011 12:26:57 +0200 Sylvain Thénault [rql2sql] don't introduce substitution for Int and Boolean constants. This is needed for COUNT(DISTINCT) support stable
Wed, 20 Jul 2011 14:10:03 +0200 Sylvain Thénault [rql2sql] closes #1832859: fake HAVING terms w/ EXISTS terms
Mon, 11 Jul 2011 09:21:44 +0200 Sylvain Thénault backport stable
Thu, 07 Jul 2011 16:47:34 +0200 Sylvain Thénault closes #1784285: [rql2sql] crash when using a relation for inner and outer join stable
Wed, 29 Jun 2011 18:28:36 +0200 Sylvain Thénault backport stable branch
Wed, 29 Jun 2011 18:27:23 +0200 Sylvain Thénault [rql2sql] more cases fixed where something is wrongly added to GROUPBY, causing unexpected results for the query stable
Fri, 10 Jun 2011 16:54:20 +0200 Sylvain Thénault [rql2sql] fix for some queries where eid variable used and entities picked as variable's table
Wed, 08 Jun 2011 17:08:00 +0200 Sylvain Thénault backport stable
Wed, 08 Jun 2011 15:11:45 +0200 Sylvain Thénault [rql2sql] fix missing sql restriction w/ attribute restriction where value comes from a subquery stable
Wed, 25 May 2011 10:59:26 +0200 Sylvain Thénault backport stable
Tue, 24 May 2011 08:49:58 +0200 Sylvain Thénault [rql2sql] closes #1697862: ORDERBY SUM(C) cancel GROUPBY by wrongly adding C to grouped variables stable
Thu, 19 May 2011 10:36:26 +0200 Sylvain Thénault backport stable
Thu, 19 May 2011 10:35:20 +0200 Sylvain Thénault [rql2sql] fix in 7394:d11d88bd08e8 was actually not needed stable
Thu, 19 May 2011 09:40:44 +0200 Sylvain Thénault [rql2sql] fix generated sql for eid comparison. closes #1638695 stable
Tue, 10 May 2011 18:53:30 +0200 Sylvain Thénault backport stable
Tue, 10 May 2011 18:50:13 +0200 Sylvain Thénault [rql2sql] fix bug avoiding outer join relation to be used as a variable principal. Closes #1659395 stable
Wed, 27 Apr 2011 12:23:43 +0200 Adrien Di Mascio [rql] basic support for regexp-based pattern matching
Wed, 27 Apr 2011 11:37:42 +0200 Adrien Di Mascio [rql] support CAST() Function
Wed, 27 Apr 2011 09:32:05 +0200 Sylvain Thénault [sql generation] fix crash on outer join + ambiguous inlined relation + attribute selection
Wed, 06 Apr 2011 23:24:19 +0200 Sylvain Thénault backport stable
Wed, 06 Apr 2011 23:23:48 +0200 Sylvain Thénault [sql generation] fix missing join with outer joins w/ rhs invariant variable... stable
Fri, 01 Apr 2011 15:04:47 +0200 Sylvain Thénault [time zone] support for TZDatetime and TZTime data type
Tue, 22 Mar 2011 15:11:38 +0100 Alexandre Fayolle Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation stable
Mon, 07 Mar 2011 17:17:07 +0100 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
Sun, 06 Feb 2011 11:33:04 +0100 Sylvain Thénault [rql2sql] should not select a neged relation as principal + simplify code for sql generation for attribute relation stable
Tue, 01 Feb 2011 10:08:44 +0100 Sylvain Thénault [rql2sql] fix bug with NOT in "fake" having terms stable
Thu, 14 Oct 2010 14:10:02 +0200 Sylvain Thénault [rql2sql] properly compute has_text relation table scope
Thu, 14 Oct 2010 10:15:38 +0200 Sylvain Thénault pylint option update
Wed, 22 Sep 2010 10:35:34 +0200 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
Fri, 17 Sep 2010 17:25:58 +0200 Sylvain Thénault cleanup stable
Fri, 20 Aug 2010 10:59:57 +0200 Sylvain Thénault [ms] more planning bug fixes stable
Mon, 02 Aug 2010 12:35:24 +0200 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
Wed, 21 Jul 2010 12:42:18 +0200 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
Tue, 06 Jul 2010 11:31:34 +0200 Sylvain Thénault backport stable
Tue, 06 Jul 2010 09:42:13 +0200 Sylvain Thénault imported patch rql2sqlfix.diff stable
Mon, 05 Jul 2010 18:00:33 +0200 Sylvain Thénault backport stable
Mon, 05 Jul 2010 17:55:37 +0200 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
Thu, 01 Jul 2010 17:06:37 +0200 Sylvain Thénault backport stable
Wed, 30 Jun 2010 18:47:10 +0200 Sylvain Thénault [sql generation] fix bug with inlined relation and referenced by other neged relation stable
Mon, 21 Jun 2010 17:30:15 +0200 Sylvain Thénault [rql2sql] #1089207: do not encode Unicode strings from RQL statements to db encoding
Mon, 21 Jun 2010 13:23:11 +0200 Sylvain Thénault backport stable
Fri, 18 Jun 2010 18:14:55 +0200 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
Thu, 17 Jun 2010 18:36:16 +0200 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
Thu, 17 Jun 2010 14:43:16 +0200 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
Thu, 10 Jun 2010 10:15:26 +0200 Sylvain Thénault [rql2sql] fix special 'X relation NULL' case (used by security insertion), broken by recent removal of IS operator in RQL stable
Wed, 09 Jun 2010 14:31:12 +0200 Sylvain Thénault [rql] more update to 0.26.2 api stable
Thu, 03 Jun 2010 16:47:57 +0200 Sylvain Thénault HAVING sql clause don't know about comma... stable
Wed, 02 Jun 2010 16:13:28 +0200 Sylvain Thénault [rql2sql] fix scope computation of variable from temporary table stable
Wed, 02 Jun 2010 14:48:36 +0200 Sylvain Thénault [storage] source's callback has a new prototype, update usage stable
Wed, 26 May 2010 15:45:22 +0200 Sylvain Thénault [rql2sql] properly compute scope for variable from temporary tables stable
Wed, 26 May 2010 10:28:48 +0200 Sylvain Thénault [rql2sql] follow rql 0.26.1 changes: NOT nodes normalization, allowing simplification of sql generation, and fix #XXX stable
Wed, 28 Apr 2010 12:24:20 +0200 Sylvain Thénault backport oldstable changes stable
Wed, 28 Apr 2010 12:15:52 +0200 Sylvain Thénault replace logilab-common by CubicWeb in disclaimer oldstable
Wed, 28 Apr 2010 12:14:22 +0200 Sylvain Thénault backport default into stable: stable is now cw 3.8
Wed, 28 Apr 2010 10:06:01 +0200 Sylvain Thénault proper licensing information (LGPL-2.1). Hope I get it right this time. stable
Thu, 15 Apr 2010 19:39:55 +0200 Sylvain Thénault backport stable
Thu, 15 Apr 2010 14:29:58 +0200 Alexandre Fayolle added note about interesting page about SQL implementation differences stable
Thu, 25 Mar 2010 14:26:13 +0100 Sylvain Thénault backport stable
Thu, 25 Mar 2010 13:59:47 +0100 Sylvain Thénault [source storage] refactor source sql generation and results handling to allow repository side callbacks stable
Thu, 25 Mar 2010 13:44:24 +0100 Sylvain Thénault [cleanup] rename dbms_helper to dbhelper for consistency stable
Wed, 24 Mar 2010 18:04:59 +0100 Sylvain Thénault le patch rql26 a été importé
Tue, 09 Mar 2010 11:05:29 +0100 Sylvain Thénault backport stable
Tue, 09 Mar 2010 10:48:46 +0100 Sylvain Thénault [sql generation] fti_need_distinct quere was not anymore used, potentially causing duplicates on has_text queries with sqlite backend stable
Mon, 08 Mar 2010 17:57:29 +0100 Sylvain Thénault [repo] use logilab.db instead of lgc.adbh/lgc.db/lgc.sqlgen/indexer, test new date extranction functions
Thu, 04 Mar 2010 11:45:29 +0100 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
Fri, 26 Feb 2010 13:19:14 +0100 Sylvain Thénault kill dead/useless code as suggested by pylint stable
Fri, 05 Feb 2010 11:56:57 +0100 Sylvain Thénault fix long-waiting symetric typo: should be spelled symmetric. Add auto database migration on schema deserialization
Wed, 20 Jan 2010 11:29:00 +0100 Sylvain Thénault fix bug: the 'table' argument is overwritten by the loop variable, causing latter crash due to this missing information stable
Thu, 07 Jan 2010 16:52:32 +0100 Adrien Di Mascio update copyright: welcome 2010 stable
Wed, 16 Dec 2009 09:11:00 +0100 Sylvain Thénault fix backout stable
Tue, 15 Dec 2009 12:24:38 +0100 Sylvain Thénault backout a75a6e770717, unmeetable condition and introduce a bug with boolean values stable
Mon, 14 Dec 2009 14:58:41 +0100 Alexandre Fayolle Passwords need to be considered as binary fields stable
Thu, 03 Dec 2009 12:50:31 +0100 Sylvain Thénault héhé, get the same result with a slightly enhanced condition and all this code removed stable
Thu, 03 Dec 2009 12:44:57 +0100 Sylvain Thénault unused, cleanup stable
Thu, 03 Dec 2009 12:44:30 +0100 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
Mon, 16 Nov 2009 18:36:31 +0100 Sylvain Thénault fix potential key error stable
Mon, 16 Nov 2009 09:36:25 +0100 Sylvain Thénault test and fix case where remove_unsused_solutions remove some solutions that should be kept stable
Tue, 10 Nov 2009 18:06:47 +0100 Sylvain Thénault test and fix http://www.logilab.org/ticket/499838 stable
Wed, 28 Oct 2009 20:09:59 +0100 Nicolas Chauvat C - fix typo. make `lgp check` happy. stable
Wed, 21 Oct 2009 08:55:54 +0200 Sylvain Thénault prefix sql aliases for entity table by '_' to avoid pb with variable such as 'AS' (eg a keyword in SQL) stable
Tue, 20 Oct 2009 16:48:30 +0200 Sylvain Thénault document stable
Tue, 20 Oct 2009 16:22:33 +0200 Sylvain Thénault when a query is grouped, ensure sort terms are grouped as well stable
Mon, 19 Oct 2009 18:36:20 +0200 Sylvain Thénault take care to already existant solutions local variable stable
Thu, 15 Oct 2009 20:29:21 +0200 Sylvain Thénault follow yams 0.25 api changes to improve performance stable
Wed, 16 Sep 2009 14:32:56 +0200 Sylvain Thénault cleanup 3.5
Wed, 16 Sep 2009 14:16:19 +0200 Sylvain Thénault [querier] fix sql generated w/ NOT relation and shared variable: ensure variable's table is in parent select'scope 3.5
Wed, 19 Aug 2009 00:00:34 +0200 Sylvain Thénault [rql2sql] test and fix a bug triggered when editing a ticket in jpl stable
Thu, 09 Jul 2009 16:15:22 +0200 Sylvain Thénault ability to map attributes to something else than usual cw mapping on sql generation stable
Mon, 29 Jun 2009 21:13:54 +0200 Sylvain Thénault fix sql generated on NOT inlined_relation queries. Use exists, so no more needs for extra DISTINCT stable
Tue, 09 Jun 2009 14:47:00 +0200 Sylvain Thénault fix missing from close when using a var map stable
Thu, 28 May 2009 09:20:07 +0200 Adrien Di Mascio big bunch of copyright / docstring update
Tue, 19 May 2009 13:08:51 +0200 Sylvain Thénault #343322: should generate IS NULL in sql w/ None values in substitution stable
Thu, 14 May 2009 11:38:40 +0200 Adrien Di Mascio delete-trailing-whitespace + some copyright update tls-sprint
Tue, 28 Apr 2009 19:14:37 +0200 sylvain thenault backport default branch tls-sprint
Mon, 27 Apr 2009 12:11:33 +0200 Adrien Di Mascio use dbmshelper to generate correct boolean value in rql2sql
Fri, 24 Apr 2009 17:04:14 +0200 sylvain thenault backport default branch tls-sprint
Fri, 17 Apr 2009 16:55:37 +0200 sylvain thenault rename internal entity types to have CW prefix instead of E tls-sprint
Thu, 16 Apr 2009 18:31:53 +0200 sylvain thenault use adbh.func_sqlname for more backend compat
Tue, 07 Apr 2009 09:30:23 +0200 sylvain thenault backport default branch tls-sprint
Mon, 06 Apr 2009 16:18:46 +0200 sylvain thenault introduce a 'cw_' prefix on entity table and column names so we don't conflict with sql or DBMS specific keywords
Mon, 23 Mar 2009 18:20:23 +0100 sylvain thenault remove some bw compat code tls-sprint
Mon, 23 Mar 2009 11:26:09 +0100 sylvain thenault copyright update
Fri, 20 Mar 2009 14:23:08 +0100 sylvain thenault fix rql2sq w/ outer join on subquery result
Fri, 16 Jan 2009 18:31:13 +0100 sylvain thenault need_intersect test and fixes
Wed, 07 Jan 2009 14:55:16 +0100 Sylvain Thenault consider intersect *and* distinct
Wed, 07 Jan 2009 09:47:56 +0100 Sylvain Thenault in some cases (eg ambiguous neged relations), INTERSECT should be used instead of DISTINCT
Wed, 05 Nov 2008 15:52:50 +0100 Adrien Di Mascio Showtime !
less more (0) tip