Insert into and Invalid numeric constant

[Former Member]

Hi all,

i try create table t1

(

f1 fixed(10)

)

and insert -2 into into t1:

insert into t1(f1) values (-2) works fine

insert into t1(f1) values (-(2)) does not work (Error Executing 'insert into t1(f1) values (-(2))' [-3016] (at 28): Invalid numeric constant)

insert into t1(f1) values (-(2+0)) works fine

It's feature or bug?

Best regards,

Lukasz.

MAXDB 7.6.03.07 & Windows Server 2003

[Former Member]

Urrgs, bad bug.

The superfluous bracket cause the trouble. Sorry.

Will be fixed ASAP.

Elke

[lbreddemann]

Hi Lukasz,

this is pretty sure a bug.

SELECT -(f1) FROM T1

works correct.

KR Lars

[Former Member]

Lars,

thank you for your reply and opinion.

KR Lukasz.