Assertion failed with number(*) function

#1

PROCEDURE :

create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10))
begin

declare l_kssifra char(13);
declare l_id integer;

set l_id = 1;

for loop1 as cur1 cursor for
select txtcode as ds_code,
txtkol as ds_kol
from reader_text
order by ids
do

set l_kssifra = (select korsifra from rb_korsifra where eancode =
ds_code);

/* THIS IS WRONG CODE I KNOW number(*) ? */
insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
values (l_vd, l_bd, number(*) , l_kssifra, ds_code, ds_kol);

/* THIS IS CORRECT CODE WHAT I NEED */
insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
values (l_vd, l_bd, l_id, l_kssifra, ds_code, ds_kol);
set l_id = l_id + 1;

end for;

commit;

exception
when others then
rollback;
end
&&

With wrong part of code i receive error : assertion failed
106901....unexpectedly NULL in write.
First version of procedure was : insert into .... select ,,number
(*)....
For some reason i need loop with cursor and insert into ... values
(...).

It is my mistake.. number(*) function couldn't use in VALUES (...).
But my database goes to be temporally invalid (validate return error :
orphaned page in database). After restarting database, validating
database returns NO ERROR.

#2

On Dec 7, 9:24*pm, Bofcilo <sprin... (AT) gmail (DOT) com> wrote:

Quote:

PROCEDURE :

create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10))
begin

declare l_kssifra char(13);
declare l_id integer;

set l_id = 1;

for loop1 as cur1 cursor for
* * select txtcode as ds_code,
* * * * * * txtkol as ds_kol
* * from reader_text
* * order by ids
do

* * set l_kssifra = (select korsifra from rb_korsifra where eancode=
ds_code);

/* THIS IS WRONG CODE I KNOW *number(*) ? */
* insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
* * values (l_vd, l_bd, number(*) , l_kssifra, ds_code, ds_kol);

/* THIS IS CORRECT CODE WHAT I NEED */
* * insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
* * values (l_vd, l_bd, l_id, l_kssifra, ds_code, ds_kol);
* * set l_id = l_id + 1;

end for;

commit;

exception
when others then
* * *rollback;
end
&&

With wrong part of code i receive error : assertion failed
106901....unexpectedly NULL in write.
First version of procedure was : insert into .... select ,,number
(*)....
For some reason i need loop with cursor and insert into ... values
(...).

It is my mistake.. number(*) function couldn't use in VALUES (...).
But my database goes to be temporally invalid (validate return error :
orphaned page in database). After restarting database, validating
database returns NO ERROR.

Version of database 10.0.3415 ........

#3

What version of SQL Anywhere are you running?

We will try to reproduce the assertion failure with NUMBER(*) in the
VALUES() list - this should cause a simple run-time failure of the
statement with a syntax error.

The validation problem may be due merely to transient changes to the
database file, which are corrected upon shutdown.

Glenn

Bofcilo wrote:

Quote:

PROCEDURE :

create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10))
begin

declare l_kssifra char(13);
declare l_id integer;

set l_id = 1;

for loop1 as cur1 cursor for
select txtcode as ds_code,
txtkol as ds_kol
from reader_text
order by ids
do

set l_kssifra = (select korsifra from rb_korsifra where eancode =
ds_code);

/* THIS IS WRONG CODE I KNOW number(*) ? */
insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
values (l_vd, l_bd, number(*) , l_kssifra, ds_code, ds_kol);

/* THIS IS CORRECT CODE WHAT I NEED */
insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
values (l_vd, l_bd, l_id, l_kssifra, ds_code, ds_kol);
set l_id = l_id + 1;

end for;

commit;

exception
when others then
rollback;
end
&&

With wrong part of code i receive error : assertion failed
106901....unexpectedly NULL in write.
First version of procedure was : insert into .... select ,,number
(*)....
For some reason i need loop with cursor and insert into ... values
(...).

It is my mistake.. number(*) function couldn't use in VALUES (...).
But my database goes to be temporally invalid (validate return error :
orphaned page in database). After restarting database, validating
database returns NO ERROR.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

#4

On Dec 7, 9:48*pm, "Glenn Paulley [Sybase iAnywhere]"
<paul... (AT) ianywhere (DOT) com> wrote:

Quote:

What version of SQL Anywhere are you running?

We will try to reproduce the assertion failure with NUMBER(*) in the
VALUES() list - this should cause a simple run-time failure of the
statement with a syntax error.

The validation problem may be due merely to transient changes to the
database file, which are corrected upon shutdown.

Glenn

Bofcilo wrote:
PROCEDURE :

create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10))
begin

declare l_kssifra char(13);
declare l_id integer;

set l_id = 1;

for loop1 as cur1 cursor for
* * select txtcode as ds_code,
* * * * * * txtkol as ds_kol
* * from reader_text
* * order by ids
do

* * set l_kssifra = (select korsifra from rb_korsifra where eancode =
ds_code);

/* THIS IS WRONG CODE I KNOW *number(*) ? */
* insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
* * values (l_vd, l_bd, number(*) , l_kssifra, ds_code, ds_kol);

/* THIS IS CORRECT CODE WHAT I NEED */
* * insert into ks_magsta(sifvrd, brodok, ids, korsifra, eancode,
kolicina)
* * values (l_vd, l_bd, l_id, l_kssifra, ds_code, ds_kol);
* * set l_id = l_id + 1;

end for;

commit;

exception
when others then
* * *rollback;
end
&&

With wrong part of code i receive error : assertion failed
106901....unexpectedly NULL in write.
First version of procedure was : insert into .... select ,,number
(*)....
For some reason i need loop with cursor and insert into ... values
(...).

It is my mistake.. number(*) function couldn't use in VALUES (...).
But my database goes to be temporally invalid (validate return error :
orphaned page in database). After restarting database, validating
database returns NO ERROR.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog:http://iablog.sybase.com/paulley

EBF's and Patches:http://downloads.sybase.com
* choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Statushttp://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages athttp://www.sybase.com/products/databasemanagement/sqlanywhere/technic...

Version 10.0.1.3415