* SQLDict_assignMessage.zsql

Avoid unnecessary assignments. Reduce message size.

* SQLDict_setPriority.zsql

Reduce message size.

* SQLDict_readMessageList.zsql

Remove unnecessary GROUP BY.
Add uid into ORDER BY so that messages are enumerated
mostly in the order of insertions, which potentially reduces
chances that messages will be reordered later.

* SQLDict_readMessage.zsql

Use DISTINCT and GROUP BY, only if necessary.
Add uid into ORDER BY for the same reason as above.

* SQLDict_createMessageTable.zsql

Specify NOT NULL whenever possible to reduce data size.
Use SMALLINT instead of INT for processing_node to reduce data size.
Remove useless indexes to reduce the cost of UPDATE.



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13582 20353a03-c40f-0410-a6d1-a30d3c3de9de

Show the report root without start and stop date too.



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13581 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13580 20353a03-c40f-0410-a6d1-a30d3c3de9de

original transaction.



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13579 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13578 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13577 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13575 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13574 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13573 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13572 20353a03-c40f-0410-a6d1-a30d3c3de9de

will decide which one to use (depending on which version of Products code you
have, either selection or selection_name should be None).



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13571 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13570 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13569 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13568 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13567 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13566 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13565 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13564 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13563 20353a03-c40f-0410-a6d1-a30d3c3de9de

None may not be always considered as a NULL value of property, so it's better to take a default NULL value from _null.
Value is considered a NULL if inside _null.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13562 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13561 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13560 20353a03-c40f-0410-a6d1-a30d3c3de9de

It may be used for example to check if user has the View permission on objects.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13559 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13558 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13557 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13556 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13555 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13554 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13553 20353a03-c40f-0410-a6d1-a30d3c3de9de

compatibility


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13551 20353a03-c40f-0410-a6d1-a30d3c3de9de

store the exception in a variable to make sure we have the right one.



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13550 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13549 20353a03-c40f-0410-a6d1-a30d3c3de9de

Separate some test in different test methods to isolate failures more easilly


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13548 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13547 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13546 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13545 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13544 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13543 20353a03-c40f-0410-a6d1-a30d3c3de9de

- use getCurrentInventory instead of getAvailableInventory when we check counter stock value
- add some delete transitions

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13542 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@13540 20353a03-c40f-0410-a6d1-a30d3c3de9de