SQL Anywhere ultralite - UL Generator error

Author

UL Generator error

Usmanov A.

2006-02-17, 7:24 am

Hi.
ASA 9.0.1 (3131), CodeWarrior 9.2 for PalmOS
Compilerget error object 'result_2' redifined during compilation of
generated code for statement:
select
sum (qnty*price) as t0,
sum (qnty) as t1,
sum(qnty/coalesce(sucase.unit_size,1)) as t2,
sum(qnty/coalesce(sublok.unit_size,1)) as t3
from
((select dd.sku_id,
dd.price,
(if qnty>remain
then remain
else qnty
endif) as qnty
from (rosporders_h dh key join rospdoc_d dd)
inner join rospstockremains rem
on dd.sku_id=rem.sku_id
and dh.stock_id=rem.stock_id
where dh.order_id=?
and dh.seller_id=?) actdd
left join (select sku_id, max(unit_size) as unit_size from rospskuunits
where unit_name='case' group by sku_id) sucase on
actdd.sku_id=sucase.sku_id)
left join (select sku_id, max(unit_size) as unit_size from rospskuunits
where unit_name='block' group by sku_id) sublok on
actdd.sku_id=sublok.sku_id
;

Code in ULDatabase.cpp:
static ul_ret_void UL_GENNED_FN_MOD dfo_aggr_eval_1751( p_ul_cursor cursor )
{
UL_LOCAL_DECL_BEGIN
UL_S_LONG( 4 ) _1756;
UL_S_LONG( 4 ) _1757;
UL_S_LONG( 4 ) _1758;
UL_S_LONG( 4 ) _1759;
UL_S_LONG( 4 ) _1760;
UL_S_LONG( 4 ) _1761;
UL_S_LONG( 4 ) _1762;
UL_S_LONG( 4 ) _1763;
UL_DOUBLE( 8 ) _1764;
UL_DOUBLE( 8 ) _1765;
UL_DOUBLE( 8 ) _1766;
UL_LOCAL_DECL_END
ul_c_ActualTotals_16
85 *c;
ul_dfp_bool result_2; //<-------
ul_dfp_bool result_2;//<-------
ul_dfp_bool result_2;//<-------
ul_dfp_bool result_2;//<-------
UL_LOCAL_FN_BEGIN( return );
.....

--

Sincerely yours,
Alex Usmanov

Michael Thode

2006-02-20, 1:23 pm

This looks like a bug. Please open a tech support case for this.
Thanks
Mike

"Usmanov A." <alex_u@pochtamt.ru> wrote in message
news:43f5c409$1@foru
ms-1-dub...
> Hi.
> ASA 9.0.1 (3131), CodeWarrior 9.2 for PalmOS
> Compilerget error object 'result_2' redifined during compilation of
> generated code for statement:
> select
> sum (qnty*price) as t0,
> sum (qnty) as t1,
> sum(qnty/coalesce(sucase.unit_size,1)) as t2,
> sum(qnty/coalesce(sublok.unit_size,1)) as t3
> from
> ((select dd.sku_id,
> dd.price,
> (if qnty>remain
> then remain
> else qnty
> endif) as qnty
> from (rosporders_h dh key join rospdoc_d dd)
> inner join rospstockremains rem
> on dd.sku_id=rem.sku_id
> and dh.stock_id=rem.stock_id
> where dh.order_id=?
> and dh.seller_id=?) actdd
> left join (select sku_id, max(unit_size) as unit_size from rospskuunits
> where unit_name='case' group by sku_id) sucase on
> actdd.sku_id=sucase.sku_id)
> left join (select sku_id, max(unit_size) as unit_size from rospskuunits
> where unit_name='block' group by sku_id) sublok on
> actdd.sku_id=sublok.sku_id
> ;
>
> Code in ULDatabase.cpp:
> static ul_ret_void UL_GENNED_FN_MOD dfo_aggr_eval_1751( p_ul_cursor
cursor )
> {
> UL_LOCAL_DECL_BEGIN
> UL_S_LONG( 4 ) _1756;
> UL_S_LONG( 4 ) _1757;
> UL_S_LONG( 4 ) _1758;
> UL_S_LONG( 4 ) _1759;
> UL_S_LONG( 4 ) _1760;
> UL_S_LONG( 4 ) _1761;
> UL_S_LONG( 4 ) _1762;
> UL_S_LONG( 4 ) _1763;
> UL_DOUBLE( 8 ) _1764;
> UL_DOUBLE( 8 ) _1765;
> UL_DOUBLE( 8 ) _1766;
> UL_LOCAL_DECL_END
> ul_c_ActualTotals_16
85 *c;
> ul_dfp_bool result_2; //<-------
> ul_dfp_bool result_2;//<-------
> ul_dfp_bool result_2;//<-------
> ul_dfp_bool result_2;//<-------
> UL_LOCAL_FN_BEGIN( return );
> ....
>
> --
>
> Sincerely yours,
> Alex Usmanov
>
>

Usmanov A.

2006-02-25, 9:41 am

Thanks for reply.
Now this statement is obsolete for me. After deleting unnecessary variables
from uldatabase.cpp I tested this query in PDA. It is very slowly and I
recast this statement into more simple statement.

--
Sincerely yours,
Alex Usmanov

> This looks like a bug. Please open a tech support case for this.
> Thanks
> Mike
>
> "Usmanov A." <alex_u@pochtamt.ru> wrote in message
> news:43f5c409$1@foru
ms-1-dub...
> cursor )
>
>

Michael Thode

2006-02-25, 9:41 am

It would be very helpful to us if you could still submit this bug. It'll
help us make the product better.

We prefer to deal with bugs through official tech support channels, but
given that this is no longer a priority for you I think it would be ok to
post details on the newsgroup to save some work for you. What we'd need is
the schema for the tables referenced in the query you listed.

Thanks
Mike

"Usmanov A." <alex_u@pochtamt.ru> wrote in message
news:43fc1b5c@forums
-1-dub...
> Thanks for reply.
> Now this statement is obsolete for me. After deleting unnecessary
variables
> from uldatabase.cpp I tested this query in PDA. It is very slowly and I
> recast this statement into more simple statement.
>
> --
> Sincerely yours,
> Alex Usmanov
>
rospskuunits[color=d
arkred]
rospskuunits[color=d
arkred]
>
>

Greg Fenton

2006-02-25, 9:41 am

Michael Thode wrote:
> We prefer to deal with bugs through official tech support channels, but
> given that this is no longer a priority for you I think it would be ok to
> post details on the newsgroup to save some work for you. What we'd need is
> the schema for the tables referenced in the query you listed.

Alternatively, if you'd prefer to keep the details outside of the
newsgroup you can submit a case at no charge via CaseXpress
(http://case-express.sybase.com/).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Tim McClements

2006-02-28, 8:27 pm

We will be looking at the -10023 problem, but there's no solution yet.

- Tim

"Usmanov A." <alex_u@pochtamt.ru> wrote in message
news:44046a9a$1@foru
ms-2-dub...
> If it can help you, I get table declarations in the attachment. I am not
> avid :-)
>
> P.S. Is there any solutions for error -10023 after sync Palm TE2? (see my
> post Strange Error(-10023) at 17 Oct 2005)
>
> Sincerely yours,
> Alex Usmanov
> --
>
>
> to
> is
>
>
>

Sponsored Links