maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Alexander,

To have a behavior the nearest possible to Oracle, I use STRICT_TRANS_TABLES sql_mode.
But then I have a problem with cast to varchar that failed with "truncated incorrect value" .

Ex:
set sql_mode='ORACLE,STRICT_TRANS_TABLES';
delimiter /
CREATE or replace procedure p3(b1 integer)
AS
  strres VARCHAR(4);
BEGIN
  strres:=cast('123456' as char(4));
END
/
call p3(-1)
/
-- Failed with : ERROR 1292 (22007): Truncated incorrect CHAR(4) value: '123456'

But

select cast('11111' as varchar(2)) from dual;

just issue a warning, not an error.

On Oracle, Sybase,SQLServer and DB2, cast a string to a shorter string never issue warnings nor error.

What do you think about ?

Regards,
Jérôme.

Attachment: p3.sql
Description: p3.sql