.. -*- coding: utf-8 -*- project rql =========== :creation date: 2009/01/15 Relationship Query Language This package contains a parser and utilities to manipulate abstract syntax tree for RQL. RQL is mostly used by `CubicWeb`_. .. _`CubicWeb`: http://www.cubicweb.org version 0.20.2 -------------- Stable version :publication date: 2008/10/17 :expected date: n/a version 0.21.0 -------------- Optimization :publication date: 2009/02/17 :expected date: n/a ticket #8067: Use gecode for solving variable types ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 1.000 :state: resolved version 0.22.0 -------------- :publication date: 2009/05/18 :expected date: n/a ticket #8895: [unstable] change libgecode dependency ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.100 :state: resolved :: # apt-cache show libgecode-dev Package: libgecode-dev Priority: optional Section: libdevel Installed-Size: 26936 Maintainer: Kari Pahula Architecture: amd64 Source: gecode Version: 3.0.2-1 Depends: libgecode16 (= 3.0.2-1) The previous version was libgecode12-dev but it is no more available in unstable. ticket #8442: no main_relation method on column alias ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.100 :state: resolved ticket #8418: consider subqueries in variables graph ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.400 :state: resolved else we get a KeyError in has_unique_value_path (stcheck) on some queries ticket #8416: support python datetime ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 0.200 :state: resolved and at some point, drop mx.DateTime support so we avoid this dependancy. version 0.22.2 -------------- :publication date: 2009/08/18 :expected date: n/a ticket #9042: bad type analysis on query like "Any X WHERE X creation_date > 2009-04-16 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.500 :state: resolved NOTE: due to missing quotes, the query is analysed as "Any X WHERE X creation_date > ((2009 - 4) - 16)" Anyway, possible solutions for X includes final types such as "String", "Int"... while only types having a "creation_date" relation should remains. ticket #9235: Compile debian package for 32bits ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.500 :state: resolved The 0.22.0 release is not available for 32bits... Comments :: On 2009/07/07 11:51 - anon wrote : Use lgp build --arch=all ticket #9206: have debian binary packages for non-amd64 archs ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 1.000 :state: resolved ticket #8888: compilation seems to be broken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.500 :state: resolved for Debian unstable release and hg id -nibt:: 174dd044ed64+ 409+ default tip gecode_solver.cpp: In static member function 'static void RqlSolver::run(RqlContext&, Gecode::Search::Stop*)': gecode_solver.cpp:180: error: 'class Gecode::Search::Statistics' has no member named 'clone' gecode_solver.cpp:181: error: 'class Gecode::Search::Statistics' has no member named 'commit' gecode_solver.cpp: In function 'PyObject* rql_solve(PyObject*, PyObject*)': gecode_solver.cpp:248: warning: deprecated conversion from string constant to 'char*' gecode_solver.cpp: At global scope: gecode_solver.cpp:260: warning: deprecated conversion from string constant to 'char*' gecode_solver.cpp:260: warning: deprecated conversion from string constant to 'char*' gecode_solver.cpp: In function 'void initrql_solve()': gecode_solver.cpp:267: warning: deprecated conversion from string constant to 'char*' error: command 'gcc' failed with exit status 1 make: *** [build-stamp] Error 1 dpkg-buildpackage: failure: debian/rules build gave error exit status 2 pbuilder: Failed autobuilding of package -> Aborting with an error -> unmounting dev/pts filesystem -> unmounting proc filesystem -> cleaning the build env -> removing directory /var/cache/pbuilder/build//26516 and its subdirectories Traceback (most recent call last): File "/usr/bin/vbuild", line 109, in sys.exit(run()) File "/usr/bin/vbuild", line 105, in run options.orig File "/usr/bin/vbuild", line 58, in build result = check_call(cmd) File "/usr/lib/python2.5/subprocess.py", line 462, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '['sudo', 'DIST=unstable', 'pbuilder', '--build', '--configfile', '/etc/lgp/pbuilderrc', '--buildresult', '/home/juj/tmp/tmpGuHuvC', '/home/juj/tmp/tmpGuHuvC/rql_0.21.1-1.dsc']' returned non-zero exit status 1 E:build: command 'vbuild -d unstable -a amd64 --result /home/juj/dists/unstable /home/juj/tmp/tmpGuHuvC/rql_0.21.1-1.dsc' returned non-zero exit status 1 C:build: failed autobuilding of package Comments :: On 2009/04/07 15:29 - jjehannet wrote : hardy as well :( I cannot fetch the right version of the library On 2009/08/18 17:27 - anon wrote : still fails for hardy (but ok w/ intrepid, jaunty, lenny, squeeze and side) version 0.24.0 -------------- :publication date: 2010/02/10 :expected date: n/a ticket #20316: other stuff ~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 1.000 :state: resolved * fully dropped mx support * various bugs fixed in 0.23.0: * Union.locate_subquery now return a 2-uple (select subquery, column index in the subquery) * new subquery_selection_index method on Union * new root_selection_index method on VariableRef ticket #20313: remove deprecation warning with recent yams (eg 0.27) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 0.300 :state: resolved version 0.25.0 -------------- :publication date: 2010/03/17 :expected date: n/a ticket #21899: use logilab.database ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 0.500 :state: resolved version 0.26.0 -------------- :publication date: 2010/04/20 :expected date: n/a ticket #23485: setuptools support ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 0.500 :state: resolved eg makes rql pip-installable ticket #23482: optimization ~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :load: 1.000 :state: resolved * stcheck * variable and column alias stinfo version 0.26.1 -------------- :publication date: 2010/06/07 :expected date: n/a ticket #33889: grammar bug for HAVING clause ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.500 :state: validation pending we should be able to use AND/OR between expression, as well as construction like "YEAR(VAR) = 2010" (currently limited to variable only on the lhs) version 0.26.2 -------------- :publication date: 2010/06/11 :expected date: n/a ticket #34440: fix rule order so 'HAVING (X op Y)' is now parseable while 'HAVING (1+2) op Y' isn't anymore parseable ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: validation pending ticket #34437: simplification bug with ored uid relations ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: validation pending ticket #21586: Depend on libgecode20 instead of libgecode19 for squeeze ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: enhancement :state: validation pending ... for debian packages, please regenerate for squeeze. Comments :: On 2010/05/31 10:21 - alutz wrote : up! please... this prevents from a simple squeeze install...
> On 2010/05/31 10:22 - alutz wrote : > It seems that now squeeze uses libgecode22
> On 2010/06/09 10:56 - sthenault wrote : > isn't that one fixed with the latest release?
version 0.26.3 -------------- :publication date: 2010/06/21 :expected date: n/a ticket #35552: Select.replace only handle WHERE node ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: validation pending should also deal with groupby, orderby, having, etc ticket #35549: grammar ambiguity for HAVING clause ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: validation pending unresolvable with yapps, but we should fix grammar so that "(expr op expr AND expr op expr)" takes priority other "(expr)" version 0.26.4 -------------- :publication date: 2010/07/28 :expected date: n/a ticket #37248: re-annotation bug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: validation pending some st information are not properly reseted, keeping potentially junk version 0.26.5 -------------- :publication date: 2010/08/02 :expected date: n/a ticket #37423: crash when computing solutions with some queries w/ subqueries ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.300 :state: validation pending see http://www.cubicweb.org/ticket/1207301 version 0.26.6 -------------- :expected date: n/a ticket #9998: bad rql yields sql syntax error ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :state: open sample: :: rql = 'Any F,N ORDERBY N WHERE F is Folder, F name N, R name "fr", F filed_under RF' sql = 'SELECT FROM VersionedFile AS R WHERE R.name=:66684016' was http://www.cubicweb.org/ticket/7952 ticket #36277: fix datetime constant issue ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.500 :state: open see http://www.logilab.org/ticket/933766 should maybe done in cw... ticket #9996: error with groubpy & orderby ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :type: bug :load: 0.200 :state: open While trying to make one rql query work ('Any VF,S,MAX(REV) GROUPBY VF,S ORDERBY VCD DESC %s WHERE ...') I got this : :: CRITICAL: sql: 'SELECT _TREVVCVCDVF0.C0, ST.name, MAX(_TREVVCVCDVF0.C1)\nFROM DocumentType AS DT, State AS ST, _TREVVCVCDVF0, document_type_relation AS rel_document_type0, in_state_relation AS rel_in_state1\nWHERE rel_document_type0.eid_from=_TREVVCVCDVF0.C0 AND _TREVVCVCDVF0.C0=rel_document_type0.eid_from AND rel_document_type0.eid_to=DT.eid AND DT.type=%(dtt)s AND rel_in_state1.eid_from=_TREVVCVCDVF0.C2 AND rel_in_state1.eid_to=ST.eid\nGROUP BY _TREVVCVCDVF0.C0,ST.name\nORDER BY _TREVVCVCDVF0.C3 DESC\nLIMIT 5' args: {'dtt': 'A'} dbms message: 'column "_trevvcvcdvf0.c3" must appear in the GROUP BY clause or be used in an aggregate function\n' 2009-01-19 17:13:40 - (cubicweb.sources.system) CRITICAL: sql: 'DROP TABLE _TREVVCVCDVF0' args: None dbms message: 'current transaction is aborted, commands ignored until end of transaction block\n' 2009-01-19 17:13:40 - (cubicweb.repository) ERROR: unexpected error Traceback (most recent call last): File "/home/auc/rep/cubicweb/cubicweb/server/repository.py", line 548, in execute build_descr) File "/home/auc/rep/cubicweb/cubicweb/server/querier.py", line 648, in execute results = plan.execute() File "/home/auc/rep/cubicweb/cubicweb/server/querier.py", line 161, in execute result = step.execute() File "/home/auc/rep/cubicweb/cubicweb/server/ssplanner.py", line 347, in execute inputmap) File "/home/auc/rep/cubicweb/cubicweb/server/sources/native.py", line 281, in syntax_tree_search self.doexec(cursor, sql, args) File "/home/auc/rep/cubicweb/cubicweb/server/sources/native.py", line 414, in doexec cursor.execute(str(query), args) ProgrammingError: column "_trevvcvcdvf0.c3" must appear in the GROUP BY clause or be used in an aggregate function notice that in that case, sql want the column used in the order by clause being in the group by clause, and that would change expected query result, so what we could expect is a nicer (and earlier) error message. should be detected by the rql st checker was http://www.cubicweb.org/ticket/5009