444 '''SELECT (MAX(T1.C1) + MIN(LENGTH(T1.C0))), T1.C2 FROM (SELECT X.cw_data AS C0, X.cw_eid AS C1, X.cw_data_name AS C2, X.cw_data_format AS C3 |
444 '''SELECT (MAX(T1.C1) + MIN(LENGTH(T1.C0))), T1.C2 FROM (SELECT X.cw_data AS C0, X.cw_eid AS C1, X.cw_data_name AS C2, X.cw_data_format AS C3 |
445 FROM cw_File AS X |
445 FROM cw_File AS X |
446 UNION ALL |
446 UNION ALL |
447 SELECT X.cw_data AS C0, X.cw_eid AS C1, X.cw_data_name AS C2, X.cw_data_format AS C3 |
447 SELECT X.cw_data AS C0, X.cw_eid AS C1, X.cw_data_name AS C2, X.cw_data_format AS C3 |
448 FROM cw_Image AS X) AS T1 |
448 FROM cw_Image AS X) AS T1 |
449 GROUP BY T1.C2 |
449 GROUP BY T1.C2,T1.C3 |
450 ORDER BY 1,2,T1.C3'''), |
450 ORDER BY 1,2,T1.C3'''), |
451 |
451 |
452 ('DISTINCT Any S ORDERBY R WHERE A is Affaire, A sujet S, A ref R', |
452 ('DISTINCT Any S ORDERBY R WHERE A is Affaire, A sujet S, A ref R', |
453 '''SELECT T1.C0 FROM (SELECT DISTINCT A.cw_sujet AS C0, A.cw_ref AS C1 |
453 '''SELECT T1.C0 FROM (SELECT DISTINCT A.cw_sujet AS C0, A.cw_ref AS C1 |
454 FROM cw_Affaire AS A |
454 FROM cw_Affaire AS A |
522 |
522 |
523 ('Any X GROUPBY X ORDERBY Y WHERE X eid 12, X login Y', |
523 ('Any X GROUPBY X ORDERBY Y WHERE X eid 12, X login Y', |
524 '''SELECT X.cw_eid |
524 '''SELECT X.cw_eid |
525 FROM cw_CWUser AS X |
525 FROM cw_CWUser AS X |
526 WHERE X.cw_eid=12 |
526 WHERE X.cw_eid=12 |
527 GROUP BY X.cw_eid |
527 GROUP BY X.cw_eid,X.cw_login |
528 ORDER BY X.cw_login'''), |
528 ORDER BY X.cw_login'''), |
529 |
529 |
530 ('Any U,COUNT(X) GROUPBY U WHERE U eid 12, X owned_by U HAVING COUNT(X) > 10', |
530 ('Any U,COUNT(X) GROUPBY U WHERE U eid 12, X owned_by U HAVING COUNT(X) > 10', |
531 '''SELECT rel_owned_by0.eid_to, COUNT(rel_owned_by0.eid_from) |
531 '''SELECT rel_owned_by0.eid_to, COUNT(rel_owned_by0.eid_from) |
532 FROM owned_by_relation AS rel_owned_by0 |
532 FROM owned_by_relation AS rel_owned_by0 |
572 '''SELECT 0'''), |
572 '''SELECT 0'''), |
573 |
573 |
574 ("Any X WHERE X eid 0, X eid 0, X test TRUE", |
574 ("Any X WHERE X eid 0, X eid 0, X test TRUE", |
575 '''SELECT X.cw_eid |
575 '''SELECT X.cw_eid |
576 FROM cw_Personne AS X |
576 FROM cw_Personne AS X |
577 WHERE X.cw_eid=0 AND X.cw_eid=0 AND X.cw_test='''), |
577 WHERE X.cw_eid=0 AND X.cw_eid=0 AND X.cw_test=TRUE'''), |
|
578 |
|
579 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
|
580 '''SELECT X.cw_eid, GROUP_CONCAT(T.cw_name) |
|
581 FROM cw_CWGroup AS X, cw_Tag AS T, tags_relation AS rel_tags0 |
|
582 WHERE rel_tags0.eid_from=T.cw_eid AND rel_tags0.eid_to=X.cw_eid |
|
583 GROUP BY X.cw_eid,X.cw_name |
|
584 ORDER BY X.cw_name'''), |
|
585 |
|
586 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN", |
|
587 '''SELECT T1.C0, GROUP_CONCAT(T1.C1) FROM (SELECT X.cw_eid AS C0, T.cw_name AS C1, X.cw_name AS C2 |
|
588 FROM cw_CWGroup AS X, cw_Tag AS T, tags_relation AS rel_tags0 |
|
589 WHERE rel_tags0.eid_from=T.cw_eid AND rel_tags0.eid_to=X.cw_eid |
|
590 UNION ALL |
|
591 SELECT X.cw_eid AS C0, T.cw_name AS C1, X.cw_name AS C2 |
|
592 FROM cw_State AS X, cw_Tag AS T, tags_relation AS rel_tags0 |
|
593 WHERE rel_tags0.eid_from=T.cw_eid AND rel_tags0.eid_to=X.cw_eid |
|
594 UNION ALL |
|
595 SELECT X.cw_eid AS C0, T.cw_name AS C1, X.cw_name AS C2 |
|
596 FROM cw_Tag AS T, cw_Tag AS X, tags_relation AS rel_tags0 |
|
597 WHERE rel_tags0.eid_from=T.cw_eid AND rel_tags0.eid_to=X.cw_eid) AS T1 |
|
598 GROUP BY T1.C0,T1.C2 |
|
599 ORDER BY T1.C2'''), |
|
600 |
578 ] |
601 ] |
579 |
602 |
580 MULTIPLE_SEL = [ |
603 MULTIPLE_SEL = [ |
581 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
604 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
582 '''SELECT DISTINCT P.cw_nom, P.cw_prenom |
605 '''SELECT DISTINCT P.cw_nom, P.cw_prenom |