equal
deleted
inserted
replaced
336 WHERE X.login=admin'''), |
336 WHERE X.login=admin'''), |
337 |
337 |
338 ('Any XN ORDERBY XN WHERE X name XN', |
338 ('Any XN ORDERBY XN WHERE X name XN', |
339 '''SELECT X.name |
339 '''SELECT X.name |
340 FROM Basket AS X |
340 FROM Basket AS X |
|
341 UNION ALL |
|
342 SELECT X.name |
|
343 FROM ECache AS X |
341 UNION ALL |
344 UNION ALL |
342 SELECT X.name |
345 SELECT X.name |
343 FROM EConstraintType AS X |
346 FROM EConstraintType AS X |
344 UNION ALL |
347 UNION ALL |
345 SELECT X.name |
348 SELECT X.name |
461 WHERE X.name=EGroup AND Y.eid IN(1, 2, 3) AND NOT EXISTS(SELECT 1 FROM read_permission_relation AS rel_read_permission0 WHERE rel_read_permission0.eid_from=X.eid AND rel_read_permission0.eid_to=Y.eid)'''), |
464 WHERE X.name=EGroup AND Y.eid IN(1, 2, 3) AND NOT EXISTS(SELECT 1 FROM read_permission_relation AS rel_read_permission0 WHERE rel_read_permission0.eid_from=X.eid AND rel_read_permission0.eid_to=Y.eid)'''), |
462 |
465 |
463 ('Any MAX(X)+MIN(X), N GROUPBY N WHERE X name N;', |
466 ('Any MAX(X)+MIN(X), N GROUPBY N WHERE X name N;', |
464 '''SELECT (MAX(T1.C0) + MIN(T1.C0)), T1.C1 FROM (SELECT X.eid AS C0, X.name AS C1 |
467 '''SELECT (MAX(T1.C0) + MIN(T1.C0)), T1.C1 FROM (SELECT X.eid AS C0, X.name AS C1 |
465 FROM Basket AS X |
468 FROM Basket AS X |
|
469 UNION ALL |
|
470 SELECT X.eid AS C0, X.name AS C1 |
|
471 FROM ECache AS X |
466 UNION ALL |
472 UNION ALL |
467 SELECT X.eid AS C0, X.name AS C1 |
473 SELECT X.eid AS C0, X.name AS C1 |
468 FROM EConstraintType AS X |
474 FROM EConstraintType AS X |
469 UNION ALL |
475 UNION ALL |
470 SELECT X.eid AS C0, X.name AS C1 |
476 SELECT X.eid AS C0, X.name AS C1 |