LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
53 stars 24 forks source link

[FRG-57] no error when inserting into a column which causes char/varchar truncation #813

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[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 |
+-----+