Anyone have any experience with this before ? I'm working with an Oracle database. When using Castor to execute a query I get a certain set of rows. Executing the exact same query with sqlplus yields more rows. The castor query always skips a certain set of rows. I've tried it many different ways changing the order by and the group by and running it in ReadOnly and Shared mode. Castor always skips the exact same set of rows every single time and sqlplus does not. The rows exist and do satisfy the condition in te where clause.
Under what cicumstances is this possible? Could someone paint a scenario under which something like this is possible.
Here is the query:
CALL SQL SELECT asin, inventory_owner_group_id, warehouse_id, fcsku,
sum(original_bin_item_quantity) sum_quantity,
max(inventory_item_identity) max_condition
FROM removal_candidates
WHERE removal_reason_code = $1
GROUP BY asin, inventory_owner_group_id, warehouse_id, fcsku
ORDER by asin, inventory_owner_group_id, warehouse_id, fcsku
AS …..
Thanks,
Sunit
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
