2012-07-09 |
Sylvain Thénault |
[rql2sql] remove debug print and fix bug introduced in 8469:69ad9a509bc3
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2012-02-20 |
Julien Cristau |
[rql2sql] correctly handle modulo operator (closes #2192457)
stable
|
file |
diff |
annotate
|
2012-02-16 |
Sylvain Thénault |
[spelling] fix dictionnary -> dictionary typo
stable
|
file |
diff |
annotate
|
2011-10-04 |
Sylvain Thénault |
[rql2sql] support for outer join on column alias (closes #1979645)
stable
|
file |
diff |
annotate
|
2011-08-04 |
Sylvain Thénault |
[rql2sql] closes #1892473: enhance handling of optional inlined relation
stable
|
file |
diff |
annotate
|
2011-08-02 |
Sylvain Thénault |
[rql2sql] closes #1892471: support for unary expression introduced in rql 0.30
stable
|
file |
diff |
annotate
|
2011-07-27 |
Sylvain Thénault |
[rql2sql] take care to boolean_value returning an int (eg sqlite/mysql)
stable cubicweb-version-3.13.3
|
file |
diff |
annotate
|
2011-07-27 |
Sylvain Thénault |
[sql] more test and fix boolean handling
stable
|
file |
diff |
annotate
|
2011-07-27 |
Sylvain Thénault |
[sql] fix querying of boolean value w/ sqlite
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2011-07-27 |
Sylvain Thénault |
[rql2sql] don't introduce substitution for Int and Boolean constants. This is needed for COUNT(DISTINCT) support
stable
|
file |
diff |
annotate
|
2011-07-20 |
Sylvain Thénault |
[rql2sql] closes #1832859: fake HAVING terms w/ EXISTS terms
|
file |
diff |
annotate
|
2011-07-11 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-07-07 |
Sylvain Thénault |
closes #1784285: [rql2sql] crash when using a relation for inner and outer join
stable
|
file |
diff |
annotate
|
2011-06-29 |
Sylvain Thénault |
backport stable branch
|
file |
diff |
annotate
|
2011-06-29 |
Sylvain Thénault |
[rql2sql] more cases fixed where something is wrongly added to GROUPBY, causing unexpected results for the query
stable
|
file |
diff |
annotate
|
2011-06-10 |
Sylvain Thénault |
[rql2sql] fix for some queries where eid variable used and entities picked as variable's table
|
file |
diff |
annotate
|
2011-06-08 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-06-08 |
Sylvain Thénault |
[rql2sql] fix missing sql restriction w/ attribute restriction where value comes from a subquery
stable
|
file |
diff |
annotate
|
2011-05-25 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-05-24 |
Sylvain Thénault |
[rql2sql] closes #1697862: ORDERBY SUM(C) cancel GROUPBY by wrongly adding C to grouped variables
stable
|
file |
diff |
annotate
|
2011-05-19 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-05-19 |
Sylvain Thénault |
[rql2sql] fix in 7394:d11d88bd08e8 was actually not needed
stable
|
file |
diff |
annotate
|
2011-05-19 |
Sylvain Thénault |
[rql2sql] fix generated sql for eid comparison. closes #1638695
stable
|
file |
diff |
annotate
|
2011-05-10 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-05-10 |
Sylvain Thénault |
[rql2sql] fix bug avoiding outer join relation to be used as a variable principal. Closes #1659395
stable
|
file |
diff |
annotate
|
2011-04-27 |
Adrien Di Mascio |
[rql] basic support for regexp-based pattern matching
|
file |
diff |
annotate
|
2011-04-27 |
Adrien Di Mascio |
[rql] support CAST() Function
|
file |
diff |
annotate
|
2011-04-27 |
Sylvain Thénault |
[sql generation] fix crash on outer join + ambiguous inlined relation + attribute selection
|
file |
diff |
annotate
|
2011-04-06 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2011-04-06 |
Sylvain Thénault |
[sql generation] fix missing join with outer joins w/ rhs invariant variable...
stable
|
file |
diff |
annotate
|
2011-04-01 |
Sylvain Thénault |
[time zone] support for TZDatetime and TZTime data type
|
file |
diff |
annotate
|
2011-03-22 |
Alexandre Fayolle |
Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2011-02-06 |
Sylvain Thénault |
[rql2sql] should not select a neged relation as principal + simplify code for sql generation for attribute relation
stable
|
file |
diff |
annotate
|
2011-02-01 |
Sylvain Thénault |
[rql2sql] fix bug with NOT in "fake" having terms
stable
|
file |
diff |
annotate
|
2010-10-14 |
Sylvain Thénault |
[rql2sql] properly compute has_text relation table scope
|
file |
diff |
annotate
|
2010-10-14 |
Sylvain Thénault |
pylint option update
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-09-17 |
Sylvain Thénault |
cleanup
stable
|
file |
diff |
annotate
|
2010-08-20 |
Sylvain Thénault |
[ms] more planning bug fixes
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-07-06 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2010-07-06 |
Sylvain Thénault |
imported patch rql2sqlfix.diff
stable
|
file |
diff |
annotate
|
2010-07-05 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-07-01 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2010-06-30 |
Sylvain Thénault |
[sql generation] fix bug with inlined relation and referenced by other neged relation
stable
|
file |
diff |
annotate
|
2010-06-21 |
Sylvain Thénault |
[rql2sql] #1089207: do not encode Unicode strings from RQL statements to db encoding
|
file |
diff |
annotate
|
2010-06-21 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-06-09 |
Sylvain Thénault |
[rql] more update to 0.26.2 api
stable
|
file |
diff |
annotate
|
2010-06-03 |
Sylvain Thénault |
HAVING sql clause don't know about comma...
stable
|
file |
diff |
annotate
|
2010-06-02 |
Sylvain Thénault |
[rql2sql] fix scope computation of variable from temporary table
stable
|
file |
diff |
annotate
|
2010-06-02 |
Sylvain Thénault |
[storage] source's callback has a new prototype, update usage
stable
|
file |
diff |
annotate
|
2010-05-26 |
Sylvain Thénault |
[rql2sql] properly compute scope for variable from temporary tables
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-04-28 |
Sylvain Thénault |
backport oldstable changes
stable
|
file |
diff |
annotate
|
2010-04-28 |
Sylvain Thénault |
replace logilab-common by CubicWeb in disclaimer
oldstable
|
file |
diff |
annotate
|
2010-04-28 |
Sylvain Thénault |
backport default into stable: stable is now cw 3.8
|
file |
diff |
annotate
|
2010-04-28 |
Sylvain Thénault |
proper licensing information (LGPL-2.1). Hope I get it right this time.
stable
|
file |
diff |
annotate
|
2010-04-15 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2010-04-15 |
Alexandre Fayolle |
added note about interesting page about SQL implementation differences
stable
|
file |
diff |
annotate
|
2010-03-25 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
2010-03-25 |
Sylvain Thénault |
[source storage] refactor source sql generation and results handling to allow repository side callbacks
stable
|
file |
diff |
annotate
|
2010-03-25 |
Sylvain Thénault |
[cleanup] rename dbms_helper to dbhelper for consistency
stable
|
file |
diff |
annotate
|
2010-03-24 |
Sylvain Thénault |
le patch rql26 a été importé
|
file |
diff |
annotate
|
2010-03-09 |
Sylvain Thénault |
backport stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-03-08 |
Sylvain Thénault |
[repo] use logilab.db instead of lgc.adbh/lgc.db/lgc.sqlgen/indexer, test new date extranction functions
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-02-26 |
Sylvain Thénault |
kill dead/useless code as suggested by pylint
stable
|
file |
diff |
annotate
|
2010-02-05 |
Sylvain Thénault |
fix long-waiting symetric typo: should be spelled symmetric. Add auto database migration on schema deserialization
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2010-01-07 |
Adrien Di Mascio |
update copyright: welcome 2010
stable
|
file |
diff |
annotate
|
2009-12-16 |
Sylvain Thénault |
fix backout
stable
|
file |
diff |
annotate
|
2009-12-15 |
Sylvain Thénault |
backout a75a6e770717, unmeetable condition and introduce a bug with boolean values
stable
|
file |
diff |
annotate
|
2009-12-14 |
Alexandre Fayolle |
Passwords need to be considered as binary fields
stable
|
file |
diff |
annotate
|
2009-12-03 |
Sylvain Thénault |
héhé, get the same result with a slightly enhanced condition and all this code removed
stable
|
file |
diff |
annotate
|
2009-12-03 |
Sylvain Thénault |
unused, cleanup
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2009-11-16 |
Sylvain Thénault |
fix potential key error
stable
|
file |
diff |
annotate
|
2009-11-16 |
Sylvain Thénault |
test and fix case where remove_unsused_solutions remove some solutions that should be kept
stable
|
file |
diff |
annotate
|
2009-11-10 |
Sylvain Thénault |
test and fix http://www.logilab.org/ticket/499838
stable
|
file |
diff |
annotate
|
2009-10-28 |
Nicolas Chauvat |
C - fix typo. make `lgp check` happy.
stable
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2009-10-20 |
Sylvain Thénault |
document
stable
|
file |
diff |
annotate
|
2009-10-20 |
Sylvain Thénault |
when a query is grouped, ensure sort terms are grouped as well
stable
|
file |
diff |
annotate
|
2009-10-19 |
Sylvain Thénault |
take care to already existant solutions local variable
stable
|
file |
diff |
annotate
|
2009-10-15 |
Sylvain Thénault |
follow yams 0.25 api changes to improve performance
stable
|
file |
diff |
annotate
|
2009-09-16 |
Sylvain Thénault |
cleanup
3.5
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2009-08-18 |
Sylvain Thénault |
[rql2sql] test and fix a bug triggered when editing a ticket in jpl
stable
|
file |
diff |
annotate
|
2009-07-09 |
Sylvain Thénault |
ability to map attributes to something else than usual cw mapping on sql generation
stable
|
file |
diff |
annotate
|
2009-06-29 |
Sylvain Thénault |
fix sql generated on NOT inlined_relation queries. Use exists, so no more needs for extra DISTINCT
stable
|
file |
diff |
annotate
|
2009-06-09 |
Sylvain Thénault |
fix missing from close when using a var map
stable
|
file |
diff |
annotate
|
2009-05-28 |
Adrien Di Mascio |
big bunch of copyright / docstring update
|
file |
diff |
annotate
|
2009-05-19 |
Sylvain Thénault |
#343322: should generate IS NULL in sql w/ None values in substitution
stable
|
file |
diff |
annotate
|
2009-05-14 |
Adrien Di Mascio |
delete-trailing-whitespace + some copyright update
tls-sprint
|
file |
diff |
annotate
|
2009-04-28 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
2009-04-27 |
Adrien Di Mascio |
use dbmshelper to generate correct boolean value in rql2sql
|
file |
diff |
annotate
|
2009-04-24 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
2009-04-17 |
sylvain thenault |
rename internal entity types to have CW prefix instead of E
tls-sprint
|
file |
diff |
annotate
|
2009-04-16 |
sylvain thenault |
use adbh.func_sqlname for more backend compat
|
file |
diff |
annotate
|
2009-04-07 |
sylvain thenault |
backport default branch
tls-sprint
|
file |
diff |
annotate
|
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
|
file |
diff |
annotate
|
2009-03-23 |
sylvain thenault |
remove some bw compat code
tls-sprint
|
file |
diff |
annotate
|
2009-03-23 |
sylvain thenault |
copyright update
|
file |
diff |
annotate
|
2009-03-20 |
sylvain thenault |
fix rql2sq w/ outer join on subquery result
|
file |
diff |
annotate
|
2009-01-16 |
sylvain thenault |
need_intersect test and fixes
|
file |
diff |
annotate
|
2009-01-07 |
Sylvain Thenault |
consider intersect *and* distinct
|
file |
diff |
annotate
|
2009-01-07 |
Sylvain Thenault |
in some cases (eg ambiguous neged relations), INTERSECT should be used instead of DISTINCT
|
file |
diff |
annotate
|
2008-11-05 |
Adrien Di Mascio |
Showtime !
|
file |
diff |
annotate
|