| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Fri, 19 Apr 2013 15:44:42 +0200 |
Sylvain Thénault |
[rql2sql] Remove an XXX by explaining why Int non-substitution is desired
|
file |
diff |
annotate
|
| Fri, 19 Apr 2013 15:41:56 +0200 |
Sylvain Thénault |
[rql2sql] Boolean values should be substitued like others. Closes #2829481
|
file |
diff |
annotate
|
| Mon, 09 Jul 2012 13:57:23 +0200 |
Sylvain Thénault |
[rql2sql] remove debug print and fix bug introduced in 8469:69ad9a509bc3
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Mon, 20 Feb 2012 11:32:06 +0100 |
Julien Cristau |
[rql2sql] correctly handle modulo operator (closes #2192457)
stable
|
file |
diff |
annotate
|
| Thu, 16 Feb 2012 14:14:52 +0100 |
Sylvain Thénault |
[spelling] fix dictionnary -> dictionary typo
stable
|
file |
diff |
annotate
|
| Tue, 04 Oct 2011 10:15:45 +0200 |
Sylvain Thénault |
[rql2sql] support for outer join on column alias (closes #1979645)
stable
|
file |
diff |
annotate
|
| Thu, 04 Aug 2011 12:50:48 +0200 |
Sylvain Thénault |
[rql2sql] closes #1892473: enhance handling of optional inlined relation
stable
|
file |
diff |
annotate
|
| Tue, 02 Aug 2011 17:31:06 +0200 |
Sylvain Thénault |
[rql2sql] closes #1892471: support for unary expression introduced in rql 0.30
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 27 Jul 2011 18:08:39 +0200 |
Sylvain Thénault |
[sql] more test and fix boolean handling
stable
|
file |
diff |
annotate
|
| Wed, 27 Jul 2011 15:42:02 +0200 |
Sylvain Thénault |
[sql] fix querying of boolean value w/ sqlite
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 20 Jul 2011 14:10:03 +0200 |
Sylvain Thénault |
[rql2sql] closes #1832859: fake HAVING terms w/ EXISTS terms
|
file |
diff |
annotate
|
| Mon, 11 Jul 2011 09:21:44 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 29 Jun 2011 18:28:36 +0200 |
Sylvain Thénault |
backport stable branch
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 08 Jun 2011 17:08:00 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 25 May 2011 10:59:26 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 19 May 2011 10:36:26 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| Thu, 19 May 2011 10:35:20 +0200 |
Sylvain Thénault |
[rql2sql] fix in 7394:d11d88bd08e8 was actually not needed
stable
|
file |
diff |
annotate
|
| Thu, 19 May 2011 09:40:44 +0200 |
Sylvain Thénault |
[rql2sql] fix generated sql for eid comparison. closes #1638695
stable
|
file |
diff |
annotate
|
| Tue, 10 May 2011 18:53:30 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 27 Apr 2011 12:23:43 +0200 |
Adrien Di Mascio |
[rql] basic support for regexp-based pattern matching
|
file |
diff |
annotate
|
| Wed, 27 Apr 2011 11:37:42 +0200 |
Adrien Di Mascio |
[rql] support CAST() Function
|
file |
diff |
annotate
|
| Wed, 27 Apr 2011 09:32:05 +0200 |
Sylvain Thénault |
[sql generation] fix crash on outer join + ambiguous inlined relation + attribute selection
|
file |
diff |
annotate
|
| Wed, 06 Apr 2011 23:24:19 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| Wed, 06 Apr 2011 23:23:48 +0200 |
Sylvain Thénault |
[sql generation] fix missing join with outer joins w/ rhs invariant variable...
stable
|
file |
diff |
annotate
|
| Fri, 01 Apr 2011 15:04:47 +0200 |
Sylvain Thénault |
[time zone] support for TZDatetime and TZTime data type
|
file |
diff |
annotate
|
| Tue, 22 Mar 2011 15:11:38 +0100 |
Alexandre Fayolle |
Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Tue, 01 Feb 2011 10:08:44 +0100 |
Sylvain Thénault |
[rql2sql] fix bug with NOT in "fake" having terms
stable
|
file |
diff |
annotate
|
| Thu, 14 Oct 2010 14:10:02 +0200 |
Sylvain Thénault |
[rql2sql] properly compute has_text relation table scope
|
file |
diff |
annotate
|
| Thu, 14 Oct 2010 10:15:38 +0200 |
Sylvain Thénault |
pylint option update
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Fri, 17 Sep 2010 17:25:58 +0200 |
Sylvain Thénault |
cleanup
stable
|
file |
diff |
annotate
|
| Fri, 20 Aug 2010 10:59:57 +0200 |
Sylvain Thénault |
[ms] more planning bug fixes
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Tue, 06 Jul 2010 11:31:34 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| Tue, 06 Jul 2010 09:42:13 +0200 |
Sylvain Thénault |
imported patch rql2sqlfix.diff
stable
|
file |
diff |
annotate
|
| Mon, 05 Jul 2010 18:00:33 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 01 Jul 2010 17:06:37 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Mon, 21 Jun 2010 17:30:15 +0200 |
Sylvain Thénault |
[rql2sql] #1089207: do not encode Unicode strings from RQL statements to db encoding
|
file |
diff |
annotate
|
| Mon, 21 Jun 2010 13:23:11 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 09 Jun 2010 14:31:12 +0200 |
Sylvain Thénault |
[rql] more update to 0.26.2 api
stable
|
file |
diff |
annotate
|
| Thu, 03 Jun 2010 16:47:57 +0200 |
Sylvain Thénault |
HAVING sql clause don't know about comma...
stable
|
file |
diff |
annotate
|
| Wed, 02 Jun 2010 16:13:28 +0200 |
Sylvain Thénault |
[rql2sql] fix scope computation of variable from temporary table
stable
|
file |
diff |
annotate
|
| Wed, 02 Jun 2010 14:48:36 +0200 |
Sylvain Thénault |
[storage] source's callback has a new prototype, update usage
stable
|
file |
diff |
annotate
|
| Wed, 26 May 2010 15:45:22 +0200 |
Sylvain Thénault |
[rql2sql] properly compute scope for variable from temporary tables
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Wed, 28 Apr 2010 12:24:20 +0200 |
Sylvain Thénault |
backport oldstable changes
stable
|
file |
diff |
annotate
|
| Wed, 28 Apr 2010 12:15:52 +0200 |
Sylvain Thénault |
replace logilab-common by CubicWeb in disclaimer
oldstable
|
file |
diff |
annotate
|
| Wed, 28 Apr 2010 12:14:22 +0200 |
Sylvain Thénault |
backport default into stable: stable is now cw 3.8
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 15 Apr 2010 19:39:55 +0200 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| Thu, 15 Apr 2010 14:29:58 +0200 |
Alexandre Fayolle |
added note about interesting page about SQL implementation differences
stable
|
file |
diff |
annotate
|
| Thu, 25 Mar 2010 14:26:13 +0100 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 25 Mar 2010 13:44:24 +0100 |
Sylvain Thénault |
[cleanup] rename dbms_helper to dbhelper for consistency
stable
|
file |
diff |
annotate
|
| Wed, 24 Mar 2010 18:04:59 +0100 |
Sylvain Thénault |
le patch rql26 a été importé
|
file |
diff |
annotate
|
| Tue, 09 Mar 2010 11:05:29 +0100 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Fri, 26 Feb 2010 13:19:14 +0100 |
Sylvain Thénault |
kill dead/useless code as suggested by pylint
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 07 Jan 2010 16:52:32 +0100 |
Adrien Di Mascio |
update copyright: welcome 2010
stable
|
file |
diff |
annotate
|
| Wed, 16 Dec 2009 09:11:00 +0100 |
Sylvain Thénault |
fix backout
stable
|
file |
diff |
annotate
|
| Tue, 15 Dec 2009 12:24:38 +0100 |
Sylvain Thénault |
backout a75a6e770717, unmeetable condition and introduce a bug with boolean values
stable
|
file |
diff |
annotate
|
| Mon, 14 Dec 2009 14:58:41 +0100 |
Alexandre Fayolle |
Passwords need to be considered as binary fields
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Thu, 03 Dec 2009 12:44:57 +0100 |
Sylvain Thénault |
unused, cleanup
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Mon, 16 Nov 2009 18:36:31 +0100 |
Sylvain Thénault |
fix potential key error
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Tue, 10 Nov 2009 18:06:47 +0100 |
Sylvain Thénault |
test and fix http://www.logilab.org/ticket/499838
stable
|
file |
diff |
annotate
|
| Wed, 28 Oct 2009 20:09:59 +0100 |
Nicolas Chauvat |
C - fix typo. make `lgp check` happy.
stable
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Tue, 20 Oct 2009 16:48:30 +0200 |
Sylvain Thénault |
document
stable
|
file |
diff |
annotate
|
| Tue, 20 Oct 2009 16:22:33 +0200 |
Sylvain Thénault |
when a query is grouped, ensure sort terms are grouped as well
stable
|
file |
diff |
annotate
|
| Mon, 19 Oct 2009 18:36:20 +0200 |
Sylvain Thénault |
take care to already existant solutions local variable
stable
|
file |
diff |
annotate
|
| Thu, 15 Oct 2009 20:29:21 +0200 |
Sylvain Thénault |
follow yams 0.25 api changes to improve performance
stable
|
file |
diff |
annotate
|
| Wed, 16 Sep 2009 14:32:56 +0200 |
Sylvain Thénault |
cleanup
3.5
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Tue, 09 Jun 2009 14:47:00 +0200 |
Sylvain Thénault |
fix missing from close when using a var map
stable
|
file |
diff |
annotate
|
| Thu, 28 May 2009 09:20:07 +0200 |
Adrien Di Mascio |
big bunch of copyright / docstring update
|
file |
diff |
annotate
|
| Tue, 19 May 2009 13:08:51 +0200 |
Sylvain Thénault |
#343322: should generate IS NULL in sql w/ None values in substitution
stable
|
file |
diff |
annotate
|
| Thu, 14 May 2009 11:38:40 +0200 |
Adrien Di Mascio |
delete-trailing-whitespace + some copyright update
tls-sprint
|
file |
diff |
annotate
|
| Tue, 28 Apr 2009 19:14:37 +0200 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
| Mon, 27 Apr 2009 12:11:33 +0200 |
Adrien Di Mascio |
use dbmshelper to generate correct boolean value in rql2sql
|
file |
diff |
annotate
|
| Fri, 24 Apr 2009 17:04:14 +0200 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
| Fri, 17 Apr 2009 16:55:37 +0200 |
sylvain thenault |
rename internal entity types to have CW prefix instead of E
tls-sprint
|
file |
diff |
annotate
|
| Thu, 16 Apr 2009 18:31:53 +0200 |
sylvain thenault |
use adbh.func_sqlname for more backend compat
|
file |
diff |
annotate
|
| Tue, 07 Apr 2009 09:30:23 +0200 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
| 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
|
file |
diff |
annotate
|
| Mon, 23 Mar 2009 18:20:23 +0100 |
sylvain thenault |
remove some bw compat code
tls-sprint
|
file |
diff |
annotate
|
| Mon, 23 Mar 2009 11:26:09 +0100 |
sylvain thenault |
copyright update
|
file |
diff |
annotate
|
| Fri, 20 Mar 2009 14:23:08 +0100 |
sylvain thenault |
fix rql2sq w/ outer join on subquery result
|
file |
diff |
annotate
|
| Fri, 16 Jan 2009 18:31:13 +0100 |
sylvain thenault |
need_intersect test and fixes
|
file |
diff |
annotate
|
| Wed, 07 Jan 2009 14:55:16 +0100 |
Sylvain Thenault |
consider intersect *and* distinct
|
file |
diff |
annotate
|
| Wed, 07 Jan 2009 09:47:56 +0100 |
Sylvain Thenault |
in some cases (eg ambiguous neged relations), INTERSECT should be used instead of DISTINCT
|
file |
diff |
annotate
|
| Wed, 05 Nov 2008 15:52:50 +0100 |
Adrien Di Mascio |
Showtime !
|
file |
diff |
annotate
|