BAN1AXds

1USE test
2 
3CREATE TABLE IF NOT EXISTS test.sdb_473_sdb (
4	c1 BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
5	c2 TIMESTAMP NOT NULL, 
6	key (c2) RANGE_KEY=SYSTEM,
7	  	  
8	test      char(5),
9	fChar     char(5),
10	fVarChar  varchar(5)
11	
12) ENGINE=ScaleDB TABLE_TYPE=Streaming DEFAULT CHARSET=utf8;
13
14 
15CREATE TABLE IF NOT EXISTS test.sdb_473_innodb (
16	c1 BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
17	c2 TIMESTAMP NOT NULL, 
18
19	test      char(5),
20	fChar     char(5),
21	fVarChar  varchar(5)
22	
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
24
25#
26# insert - Simple
27#
28INSERT INTO test.sdb_473_sdb   ( c1, c2,  test, fChar, fVarChar ) VALUES ( 0,  0, 'test0', 'c0', 'vc0'  );
29 
30INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test0', 'c0', 'vc0'  );
31
32#
33# insert - Ok 
34#
35INSERT INTO test.sdb_473_sdb    ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test1', 'c1', 'vc1'  ),( 0,  0, 'test1', 'c2', 'vc2'  ), ( 0,  0, 'test1', 'c3', 'vc3'  ) ;
36
37INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test1', 'c1', 'vc1'  ),( 0,  0, 'test1', 'c2', 'vc2'  ), ( 0,  0, 'test1', 'c3', 'vc3'  ) ;
38
39#
40# insert - BAD
41#
42INSERT INTO test.sdb_473_sdb    ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test2', 'c1-12345', 'vc1'  ),( 0,  0, 'test2', 'c2', 'vc2'  ), ( 0,  0, 'test2', 'c3', 'vc3'  ) ;
43
44INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test2', 'c1-12345', 'vc1'  ),( 0,  0, 'test2', 'c2', 'vc2'  ), ( 0,  0, 'test2', 'c3', 'vc3'  ) ;
45
46#
47# insert - BAD 
48#
49INSERT INTO test.sdb_473_sdb    ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test3', 'c1', 'vc1-12345'  ),( 0,  0, 'test3', 'c2', 'vc2'  ), ( 0,  0, 'test3', 'c3', 'vc3'  ) ;
50
51INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test3', 'c1', 'vc1-12345'  ),( 0,  0, 'test3', 'c2', 'vc2'  ), ( 0,  0, 'test3', 'c3', 'vc3'  ) ;
52
53
54#
55# insert - BAD
56#
57INSERT INTO test.sdb_473_sdb    ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test4', 'c1', 'vc1'  ),( 0,  0, 'test4', 'c2', 'vc2'  ), ( 0,  0, 'test4', 'c3-12345', 'vc3'  ) ;
58
59INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test4', 'c1', 'vc1'  ),( 0,  0, 'test4', 'c2', 'vc2'  ), ( 0,  0, 'test4', 'c3-12345', 'vc3'  ) ;
60
61#
62# insert - BAD 
63#
64INSERT INTO test.sdb_473_sdb    ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test5', 'c1', 'vc1'  ),( 0,  0, 'test5', 'c2', 'vc2'  ), ( 0,  0, 'test5', 'c3', 'vc3-12345'  ) ;
65
66INSERT INTO test.sdb_473_innodb ( c1, c2, test, fChar, fVarChar ) VALUES ( 0,  0, 'test5', 'c1', 'vc1'  ),( 0,  0, 'test5', 'c2', 'vc2'  ), ( 0,  0, 'test5', 'c3', 'vc3-12345'  ) ;
67
68 
69SELECT * FROM test.sdb_473_sdb;
70
71SELECT * FROM test.sdb_473_innodb;