← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/bug673380_create_table_null_col_type.test

  • Committer: Stewart Smith
  • Date: 2010-11-10 08:10:53 UTC
  • mto: (1819.7.44 update-innobase)
  • mto: This revision was merged to the branch mainline in revision 1926.
  • Revision ID: stewart@flamingspork.com-20101110081053-fz4depckopv167tg
add tset for bug673380: CREATE TABLE AS can create a table with a column type of NULL

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/bug673380_create_table_null_col_type.test
 
1
# This is the test for bug #54044. Special handle MYSQL_TYPE_NULL type
 
2
# during create table, so it will not trigger assertion failure.
 
3
 
 
4
# This 'create table' operation should fail because of
 
5
# using NULL datatype
 
6
--error ER_CANT_CREATE_TABLE
 
7
CREATE TEMPORARY TABLE TABLE_54044
 
8
 AS SELECT IF(NULL  IS NOT NULL, NULL, NULL); 
 
9
 
 
10