Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8373/src/test/bugs/Tests
Added Files:
alter_table_add_column.sql
Log Message:
propagated changes of Saturday Aug 02 2008 - Tuesday Aug 05 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/02 - nielsnes: src/test/bugs/Tests/alter_table_add_column.sql,1.1.2.1
test for (over strict) check on not null and default == NULL in alter table
add column statements
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: alter_table_add_column.sql ---
create table t_not_null(a int);
alter table t_not_null add foo int not null;
insert into t_not_null values (1,1);
insert into t_not_null (a) values (1);
drop table t_not_null;
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
