dynamobi/dynamobi — Issue #813: [FRG-57] no error when inserting into a column which causes char/varchar truncation 
Author: dynamobi-build
Created: 2011-12-30 03:50:11+00:00
State: open
Labels: FRG

[reporter="schoi", created="Fri, 24 Feb 2006 15:09:54 -0500 (GMT-05:00)"]
if non-space characters are truncated on store, sql should fail, but doesn't.

Repro:

----------

create schema s;

set schema 's';

create table ch (c char(2) primary key);

insert into ch values('abcd');

select * from ch;

+-----+

| C |

+-----+

| ab |

+-----+

create table varch (v varchar(2) primary key);

insert into varch values('abcd');

select * from varch;

+-----+

| V |

+-----+

| ab |

+-----+