Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.190.207.23
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.test
596
B
-rw-r--r--
clusterj.cnf
169
B
-rw-r--r--
clusterj.test
2.28
KB
-rw-r--r--
clusterj_jpa.test
2.71
KB
-rw-r--r--
disabled.def
1.36
KB
-rw-r--r--
have_ndb_dist_priv.inc
944
B
-rw-r--r--
have_ndb_error_insert.inc
931
B
-rw-r--r--
loaddata_autocom_ndb.test
308
B
-rw-r--r--
ndb_add_partition.cnf
594
B
-rw-r--r--
ndb_add_partition.test
13.3
KB
-rw-r--r--
ndb_addnode.cnf
665
B
-rw-r--r--
ndb_addnode.test
5.12
KB
-rw-r--r--
ndb_addnode_restart.cnf
79
B
-rw-r--r--
ndb_addnode_restart.test
299
B
-rw-r--r--
ndb_addnode_restart2.cnf
79
B
-rw-r--r--
ndb_addnode_restart2.test
465
B
-rw-r--r--
ndb_addnode_withbinlog.cnf
869
B
-rw-r--r--
ndb_addnode_withbinlog.test
1.18
KB
-rw-r--r--
ndb_alter_table.test
18.09
KB
-rw-r--r--
ndb_alter_table2.test
1.52
KB
-rw-r--r--
ndb_alter_table3.test
1.68
KB
-rw-r--r--
ndb_alter_table_backup.test
1.73
KB
-rw-r--r--
ndb_alter_table_dml.test
2.8
KB
-rw-r--r--
ndb_alter_table_error.test
1.15
KB
-rw-r--r--
ndb_alter_table_online.test
24.07
KB
-rw-r--r--
ndb_alter_table_online2.test
6.24
KB
-rw-r--r--
ndb_alter_table_online_multi.t...
2.08
KB
-rw-r--r--
ndb_auto_increment.test
12.89
KB
-rw-r--r--
ndb_autoinc.test
2.05
KB
-rw-r--r--
ndb_backup_rate.cnf
286
B
-rw-r--r--
ndb_backup_rate.test
2.35
KB
-rw-r--r--
ndb_basic.test
21.28
KB
-rw-r--r--
ndb_bitfield.test
6.54
KB
-rw-r--r--
ndb_blob.test
18.61
KB
-rw-r--r--
ndb_blob_big.cnf
380
B
-rw-r--r--
ndb_blob_big.test
1.83
KB
-rw-r--r--
ndb_blob_partition.test
4.49
KB
-rw-r--r--
ndb_bug13563280.test
743
B
-rw-r--r--
ndb_bug14166590.cnf
63
B
-rw-r--r--
ndb_bug14166590.test
1.45
KB
-rw-r--r--
ndb_bug17624736.cnf
110
B
-rw-r--r--
ndb_bug17624736.test
2.15
KB
-rw-r--r--
ndb_bug17719439.cnf
63
B
-rw-r--r--
ndb_bug17719439.test
1.34
KB
-rw-r--r--
ndb_bug19390895.cnf
272
B
-rw-r--r--
ndb_bug19390895.test
1.06
KB
-rw-r--r--
ndb_bug26793.test
1.06
KB
-rw-r--r--
ndb_bug31477.test
2.33
KB
-rw-r--r--
ndb_bulk_delete.test
4.13
KB
-rw-r--r--
ndb_bushy_joins.cnf
476
B
-rw-r--r--
ndb_bushy_joins.test
9.03
KB
-rw-r--r--
ndb_cache.cnf
201
B
-rw-r--r--
ndb_cache.test
8.13
KB
-rw-r--r--
ndb_cache2.cnf
23
B
-rw-r--r--
ndb_cache2.test
11.26
KB
-rw-r--r--
ndb_cache_multi.cnf
23
B
-rw-r--r--
ndb_cache_multi.test
2.09
KB
-rw-r--r--
ndb_cache_multi2.cnf
23
B
-rw-r--r--
ndb_cache_multi2.test
4.5
KB
-rw-r--r--
ndb_cache_trans.cnf
23
B
-rw-r--r--
ndb_cache_trans.test
4.85
KB
-rw-r--r--
ndb_charset.test
6.63
KB
-rw-r--r--
ndb_checksum.cnf
50
B
-rw-r--r--
ndb_checksum.test
77
B
-rw-r--r--
ndb_column_properties.test
4.71
KB
-rw-r--r--
ndb_condition_pushdown.test
85.29
KB
-rw-r--r--
ndb_config.test
4.16
KB
-rw-r--r--
ndb_config2.test
514
B
-rw-r--r--
ndb_create_table.test
1005
B
-rw-r--r--
ndb_cursor.test
1.1
KB
-rw-r--r--
ndb_database.test
3.18
KB
-rw-r--r--
ndb_dbug_lock.test
2.15
KB
-rw-r--r--
ndb_dbug_tc_select.test
4.03
KB
-rw-r--r--
ndb_dbug_tc_select_1.inc
1.83
KB
-rw-r--r--
ndb_dbug_tc_select_2.inc
1.91
KB
-rw-r--r--
ndb_dbug_tc_select_3.inc
2.06
KB
-rw-r--r--
ndb_dd_alter.test
9
KB
-rw-r--r--
ndb_dd_basic.test
20.93
KB
-rw-r--r--
ndb_dd_bug12581213.cnf
111
B
-rw-r--r--
ndb_dd_bug12581213.test
580
B
-rw-r--r--
ndb_dd_ddl.test
8.07
KB
-rw-r--r--
ndb_dd_disk2memory.test
10.4
KB
-rw-r--r--
ndb_dd_dump.test
10.79
KB
-rw-r--r--
ndb_dd_initial_lg.cnf
796
B
-rw-r--r--
ndb_dd_initial_lg.test
1.11
KB
-rw-r--r--
ndb_dd_restore_check_tablespac...
12.25
KB
-rw-r--r--
ndb_dd_restore_compat.test
1.13
KB
-rw-r--r--
ndb_dd_sql_features.test
16.35
KB
-rw-r--r--
ndb_ddl_open_trans.test
3.03
KB
-rw-r--r--
ndb_disconnect_ddl.test
1.52
KB
-rw-r--r--
ndb_discover_db-master.opt
43
B
-rw-r--r--
ndb_discover_db.test
3.41
KB
-rw-r--r--
ndb_dist_priv.test
10.53
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.tes...
1.31
KB
-rw-r--r--
ndb_err4012.test
2.79
KB
-rw-r--r--
ndb_error_reporter.ini
288
B
-rw-r--r--
ndb_error_reporter.test
3.3
KB
-rw-r--r--
ndb_fired_trigger_shortage.cnf
60
B
-rw-r--r--
ndb_fired_trigger_shortage.tes...
1.31
KB
-rw-r--r--
ndb_fk_addnode.cnf
931
B
-rw-r--r--
ndb_fk_addnode.test
2.07
KB
-rw-r--r--
ndb_fk_alter.test
3.95
KB
-rw-r--r--
ndb_fk_bugs.test
20.95
KB
-rw-r--r--
ndb_fk_build.test
2.18
KB
-rw-r--r--
ndb_fk_cascade_delete.test
3.86
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.te...
1.96
KB
-rw-r--r--
ndb_fk_cascade_update.test
1.37
KB
-rw-r--r--
ndb_fk_create_drop.test
2.55
KB
-rw-r--r--
ndb_fk_db.test
2.59
KB
-rw-r--r--
ndb_fk_deferred_cascade.test
2.81
KB
-rw-r--r--
ndb_fk_disable.test
11.61
KB
-rw-r--r--
ndb_fk_is.inc
2.59
KB
-rw-r--r--
ndb_fk_is.test
161
B
-rw-r--r--
ndb_fk_locase.cnf
63
B
-rw-r--r--
ndb_fk_locase.test
1.54
KB
-rw-r--r--
ndb_fk_locking.test
2.1
KB
-rw-r--r--
ndb_fk_multi_column.test
1.5
KB
-rw-r--r--
ndb_fk_mysqldump.test
1.32
KB
-rw-r--r--
ndb_fk_mysqldump2.test
1.76
KB
-rw-r--r--
ndb_fk_no_fk.test
25.97
KB
-rw-r--r--
ndb_fk_no_fk_compat.inc
3.94
KB
-rw-r--r--
ndb_fk_no_fk_legacy.test
112
B
-rw-r--r--
ndb_fk_no_fk_ndb-master.opt
49
B
-rw-r--r--
ndb_fk_no_fk_ndb.test
139
B
-rw-r--r--
ndb_fk_noaction.test
4.78
KB
-rw-r--r--
ndb_fk_resources.cnf
91
B
-rw-r--r--
ndb_fk_resources.test
1.44
KB
-rw-r--r--
ndb_fk_restore.inc
2.9
KB
-rw-r--r--
ndb_fk_restore.test
3.63
KB
-rw-r--r--
ndb_fk_restrict.test
5.19
KB
-rw-r--r--
ndb_fk_self_ref.test
3.85
KB
-rw-r--r--
ndb_fk_setdefault.test
982
B
-rw-r--r--
ndb_fk_setnull.test
2.43
KB
-rw-r--r--
ndb_global_schema_lock.test
3.71
KB
-rw-r--r--
ndb_global_schema_lock_error.t...
1.73
KB
-rw-r--r--
ndb_grant.later
10.98
KB
-rw-r--r--
ndb_hashmap.cnf
61
B
-rw-r--r--
ndb_hashmap.test
821
B
-rw-r--r--
ndb_hidden_pk.test
2.76
KB
-rw-r--r--
ndb_index.test
13.42
KB
-rw-r--r--
ndb_index_ordered.test
15.67
KB
-rw-r--r--
ndb_index_stat.test
11.05
KB
-rw-r--r--
ndb_index_stat_enable.inc
1.18
KB
-rw-r--r--
ndb_index_stat_partitions-mast...
70
B
-rw-r--r--
ndb_index_stat_partitions.test
4.27
KB
-rw-r--r--
ndb_index_stat_restart.test
2.47
KB
-rw-r--r--
ndb_index_unique.test
16.63
KB
-rw-r--r--
ndb_init_schema_locks_count.in...
325
B
-rw-r--r--
ndb_insert.test
37.01
KB
-rw-r--r--
ndb_join_pushdown.inc
131.68
KB
-rw-r--r--
ndb_join_pushdown_bka.test
2.98
KB
-rw-r--r--
ndb_join_pushdown_default.test
356
B
-rw-r--r--
ndb_join_pushdown_nobnl.test
464
B
-rw-r--r--
ndb_join_pushdown_none.test
1.15
KB
-rw-r--r--
ndb_jtie.test
1.17
KB
-rw-r--r--
ndb_limit.test
2.44
KB
-rw-r--r--
ndb_load.test
2.33
KB
-rw-r--r--
ndb_loaddatalocal.test
2.63
KB
-rw-r--r--
ndb_lock.test
5.89
KB
-rw-r--r--
ndb_lock_table.test
494
B
-rw-r--r--
ndb_many_fragments.cnf
433
B
-rw-r--r--
ndb_many_fragments.test
1.91
KB
-rw-r--r--
ndb_mgm.cnf
172
B
-rw-r--r--
ndb_mgm.inc
130
B
-rw-r--r--
ndb_mgm.test
7.38
KB
-rw-r--r--
ndb_mgmd.cnf
99
B
-rw-r--r--
ndb_mgmd.test
637
B
-rw-r--r--
ndb_minmax.test
1.48
KB
-rw-r--r--
ndb_multi.test
11.13
KB
-rw-r--r--
ndb_multi_row.test
1.99
KB
-rw-r--r--
ndb_multi_update_delete.test
2.02
KB
-rw-r--r--
ndb_native_default_support.tes...
27.65
KB
-rw-r--r--
ndb_one_fragment.cnf
443
B
-rw-r--r--
ndb_one_fragment.test
3.14
KB
-rw-r--r--
ndb_optimize_table.test
2.65
KB
-rw-r--r--
ndb_optimized_node_selection.t...
1.09
KB
-rw-r--r--
ndb_partition_error.test
2.04
KB
-rw-r--r--
ndb_partition_error2.test
579
B
-rw-r--r--
ndb_partition_hash.test
1.73
KB
-rw-r--r--
ndb_partition_key.test
7.85
KB
-rw-r--r--
ndb_partition_list.test
2.88
KB
-rw-r--r--
ndb_partition_range.test
8.11
KB
-rw-r--r--
ndb_print_file.test
1.35
KB
-rw-r--r--
ndb_rbwr.inc
2.13
KB
-rw-r--r--
ndb_rbwr.test
11.15
KB
-rw-r--r--
ndb_read_multi_range.test
14.9
KB
-rw-r--r--
ndb_reconnect.test
4.03
KB
-rw-r--r--
ndb_rename.test
1.19
KB
-rw-r--r--
ndb_replace.test
4.34
KB
-rw-r--r--
ndb_restart_nostart.inc
147
B
-rw-r--r--
ndb_restart_start.inc
130
B
-rw-r--r--
ndb_restore_bug17916243.test
1.21
KB
-rw-r--r--
ndb_restore_compat_compression...
46
B
-rw-r--r--
ndb_restore_compat_compression...
799
B
-rw-r--r--
ndb_restore_compat_downward.te...
4.21
KB
-rw-r--r--
ndb_restore_compat_endianness....
6.94
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
17.35
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
23.02
KB
-rw-r--r--
ndb_restore_conv_more.test
20.65
KB
-rw-r--r--
ndb_restore_conv_padding.test
9.58
KB
-rw-r--r--
ndb_restore_conv_promotion.tes...
12.91
KB
-rw-r--r--
ndb_restore_discover.test
1.72
KB
-rw-r--r--
ndb_restore_misc.cnf
147
B
-rw-r--r--
ndb_restore_misc.test
27.44
KB
-rw-r--r--
ndb_restore_print.test
6.98
KB
-rw-r--r--
ndb_restore_schema_blobs.test
4.43
KB
-rw-r--r--
ndb_restore_schema_partitions....
15.04
KB
-rw-r--r--
ndb_restore_schema_rewrites.te...
16.47
KB
-rw-r--r--
ndb_restore_schema_subsets.tes...
11.14
KB
-rw-r--r--
ndb_restore_schema_tolerance.t...
6.72
KB
-rw-r--r--
ndb_restore_undolog.cnf
509
B
-rw-r--r--
ndb_restore_undolog.test
16.89
KB
-rw-r--r--
ndb_row_count.test
3.16
KB
-rw-r--r--
ndb_row_format.test
2.28
KB
-rw-r--r--
ndb_schema_locks_count.inc
308
B
-rw-r--r--
ndb_select_count.test
574
B
-rw-r--r--
ndb_share.cnf
652
B
-rw-r--r--
ndb_share.test
9.86
KB
-rw-r--r--
ndb_short_sigs.cnf
170
B
-rw-r--r--
ndb_short_sigs.test
2.7
KB
-rw-r--r--
ndb_show_tables_result.inc
768
B
-rw-r--r--
ndb_single_user-master.opt
32
B
-rw-r--r--
ndb_single_user.test
4.92
KB
-rw-r--r--
ndb_sp.test
1.09
KB
-rw-r--r--
ndb_spj_dict.test
9.25
KB
-rw-r--r--
ndb_sql_allow_batching.test
1.33
KB
-rw-r--r--
ndb_startup.test
2.01
KB
-rw-r--r--
ndb_statistics.inc
3.31
KB
-rw-r--r--
ndb_statistics0.test
613
B
-rw-r--r--
ndb_statistics1.test
612
B
-rw-r--r--
ndb_subquery.test
7.14
KB
-rw-r--r--
ndb_suma_handover.cnf
324
B
-rw-r--r--
ndb_suma_handover.test
1.62
KB
-rw-r--r--
ndb_temporary.test
1.3
KB
-rw-r--r--
ndb_tmp_table_and_DDL.test
603
B
-rw-r--r--
ndb_transaction.test
5.97
KB
-rw-r--r--
ndb_trigger.test
8.98
KB
-rw-r--r--
ndb_truncate.test
1004
B
-rw-r--r--
ndb_types.test
4.9
KB
-rw-r--r--
ndb_update.test
2.94
KB
-rw-r--r--
ndb_update_no_read.test
17.18
KB
-rw-r--r--
ndb_view.test
817
B
-rw-r--r--
ndb_wait_nostart.inc
103
B
-rw-r--r--
ndb_wait_started.inc
84
B
-rw-r--r--
ndb_wait_until_ready.cnf
544
B
-rw-r--r--
ndb_wait_until_ready.test
4.19
KB
-rw-r--r--
ndb_waiter.inc
148
B
-rw-r--r--
ndb_wl946_create.inc
449
B
-rw-r--r--
ndb_wl946_main.test
7.1
KB
-rw-r--r--
ndb_wl946_main_query.inc
66.38
KB
-rw-r--r--
ndb_wl946_post.test
2.67
KB
-rw-r--r--
ndb_wl946_pre.test
2.67
KB
-rw-r--r--
ndb_wl946_pre_query.inc
589
B
-rw-r--r--
ndb_wl946_select_all.inc
1.41
KB
-rw-r--r--
ndbapi-examples.test
3.29
KB
-rw-r--r--
ndbinfo.test
24.32
KB
-rw-r--r--
ndbinfo_cache.cnf
23
B
-rw-r--r--
ndbinfo_cache.test
882
B
-rw-r--r--
ndbinfo_dump.test
780
B
-rw-r--r--
ndbinfo_upgrade.test
1.15
KB
-rw-r--r--
ps_7ndb.test
1.08
KB
-rw-r--r--
show_attributes.inc
664
B
-rw-r--r--
show_indexes.inc
674
B
-rw-r--r--
show_primary_keys.inc
609
B
-rw-r--r--
show_varpart.inc
762
B
-rw-r--r--
strict_autoinc_5ndb.test
356
B
-rw-r--r--
test_debugger.test
267
B
-rw-r--r--
test_mgm.test
262
B
-rw-r--r--
test_mgmd.cnf
232
B
-rw-r--r--
test_mgmd.test
473
B
-rw-r--r--
test_ndbinfo.test
439
B
-rw-r--r--
wl10837.test
274
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_native_default_support.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc ############################################################# # Author: Guangbao Ni # Date: 2008-12 # Purpose: ndb native default support test ############################################################## -- source include/have_ndb.inc # Directory containing the saved backup files let $backup_data_dir=$MYSQL_TEST_DIR/suite/ndb/backups; # Turn off STRICT mode since test intentionally generate warnings # while inserting rows without default values. # NOTE! one test at the end turns STRICT back on for a while --source suite/ndb/include/turn_off_strict_sql_mode.inc --disable_warnings DROP TABLE IF EXISTS t1,bit1; DROP DATABASE IF EXISTS mysqltest; --enable_warnings CREATE DATABASE mysqltest; USE mysqltest; ############################################################### # BASIC SQL STATEMENT TEST FOR NDB NATIVE DEFAULT VALUE SUPPORT ############################################################### # Create table with default values for some types. # Create table for bit type. # Test cases include: # 1. Create table with default values # 2. Insert statement: # --Insert default values into, the default values can be inserted into table correctly # --Insert record supplied by client, it can inserted correctly # --Insert record (including default value and value supplied by client) # 3. Update statement: # --Update with primary key condition # --Update with non-primary key condtion # 4. Replace statement: # --Replace with default values when the record isn't existed in table # --Replace with part default values and part value supplied by client when the record isn't existed in table. # --Replace with part default values and part value suppliced by client when the record already existed in table. # 5. Delete statement: --echo *************************************************************** --echo * BASIC SQL STATEMENT TEST FOR NDB NATIVE DEFAULT VALUE SUPPORT --echo *************************************************************** CREATE TABLE t1( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, j INT DEFAULT 6, f FLOAT NOT NULL DEFAULT 6.6, d DOUBLE DEFAULT 8.8, d2 DOUBLE NOT NULL, #d2 gets 'data-type-specific default', i.e. 0. ch CHAR(19) DEFAULT "aaa", vch VARCHAR(19) DEFAULT "bbb", b BINARY(19) DEFAULT "ccc", vb VARBINARY(19) DEFAULT "ddd", blob1 BLOB, text1 TEXT, timestamp_c TIMESTAMP DEFAULT CURRENT_TIMESTAMP )ENGINE=NDB PARTITION BY KEY() PARTITIONS 8; --disable_warnings INSERT INTO t1 VALUES(),(); INSERT INTO t1 VALUES( 10, 10, 10.0, 10.0, 10.0, "nnnnn", "nnnnn", "nnnnn", "nnnnn", "nnnnn", "nnnnn", "2008-11-16 08:13:32"); INSERT INTO t1(i, ch) VALUES(11, "mmm"); --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; UPDATE t1 SET ch = "xxx" WHERE i = 10; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; UPDATE t1 SET blob1 = "yyy" WHERE j = 10; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; REPLACE INTO t1(i, j, ch) VALUES(1, 1, "zzz"); REPLACE INTO t1(i, j, ch) VALUES(20, 20, "www"); --enable_warnings --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; DELETE FROM t1 WHERE i > 9; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; #Test BIT TYPE CREATE TABLE bit1( pk INT AUTO_INCREMENT NOT NULL PRIMARY KEY, b1 BIT(3) DEFAULT B'111', b2 BIT(9) DEFAULT B'101', b3 BIT(23) DEFAULT B'110', b4 BIT(37) DEFAULT B'011', b5 BIT(63) DEFAULT B'101011' )ENGINE=NDB PARTITION BY KEY() PARTITIONS 8; INSERT INTO bit1 VALUES(); INSERT INTO bit1(b1,b4) VALUES(B'101',B'111'); SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; UPDATE bit1 SET b5=B'11111' WHERE pk = 1; REPLACE INTO bit1(pk, b3) VALUES(2, B'1'); REPLACE INTO bit1(pk, b3) VALUES(6, B'101'); SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; DELETE FROM bit1 WHERE pk = 2; SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; ############################################################# # ALTER TABLE WITH DEFAULT VALUES TEST ############################################################# --echo ******************************************************** --echo * Alter table to add column with default value --echo ******************************************************** ALTER TABLE t1 ADD COLUMN ch2 CHAR(30) DEFAULT "alter table"; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 ORDER BY i; --disable_warnings INSERT INTO t1 VALUES(); --enable_warnings --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 ORDER BY i; --echo ******************************************************** --echo * Alter table with default value can fail safely --echo ******************************************************** --disable_warnings --error 1060 ALTER TABLE t1 ADD COLUMN ch2 CHAR(30) DEFAULT "alter table"; --error 1067 ALTER TABLE t1 ADD COLUMN ch3 CHAR(3) DEFAULT "alter table"; INSERT INTO t1 VALUES(); --enable_warnings --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 ORDER BY i; ############################################################## # BACKUP AND RESTORE TEST FOR TABLE WITH DEFAULT VALUES ############################################################## #the above two tables are backuped, they can restore correctly. #The default values can be inserted correctly after restored. --echo ******************************************************** --echo * The tables with default values BACKUP and RESTORE test --echo ******************************************************** --source include/ndb_backup.inc DROP TABLE IF EXISTS t1, bit1; --echo ******************************************************** --echo * Begin to restore data from backup --echo ******************************************************** --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -A -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -A -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --sorted_result SHOW TABLES; --let $ndb_desc_opts= -d mysqltest t1 --source suite/ndb/include/ndb_desc_print.inc --let $ndb_desc_opts= -d mysqltest bit1 --source suite/ndb/include/ndb_desc_print.inc SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 ORDER BY i; --disable_warnings INSERT INTO t1(i, ch) VALUES(99, "restore"); --enable_warnings INSERT INTO bit1(pk, b5) VALUES(99, B'11111111'); SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 ORDER BY i; DROP TABLE IF EXISTS t1, bit1; --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -A -m -r --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -A -r --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --sorted_result SHOW TABLES; --replace_column 1 MAX_VALUE 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, ch2 FROM t1 WHERE i >= (SELECT MAX(i) FROM t1) ORDER BY i; DROP TABLE IF EXISTS t1, bit1; DROP DATABASE mysqltest; ############################################################################### # RESTORE THE BACKUP FROM 6.3 OR 6.4, WHICH DON'T SUPPORT NATIVE DEFAULT VALUE # SO DEFAULT VALUES AREN'T STORED IN NDBD KERNEL ############################################################################### --echo ****************************************************************************** --echo * Restore the backup from 6.3 or 6.4, which don't support native default value --echo ****************************************************************************** --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -m -r $backup_data_dir/before_native_default >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r $backup_data_dir/before_native_default >> $NDB_TOOLS_OUTPUT #### # Bug# 53539 Ndb : MySQLD default values in frm embedded in backup not endian-converted # Bug# 53818 Default values in .frm file not byte-order-independent # Due to this, on big-endian platforms the backup file restored above # has corrupt values for the endian-sensitive defaults (int, float, double) # Until this is fixed we cannot robustly examine the MySQL schema. # Workaround is to offline-alter the defaults to what they should be. # # Show that restored tables have no native defaults --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc --let $ndb_desc_opts= -d test bit1 --source suite/ndb/include/ndb_desc_print.inc USE test; --sorted_result SHOW TABLES; # SHOW CREATE TABLE t1; # Disabled til bug#53539 fixed as it show junk on big-endian SHOW CREATE TABLE bit1; --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; # bug#53539 workaround - overwrites bad default values from frm in # opposite-byte-order case. # # As there were no partition spec in the restored backup, # we also has to set that as part of alter table to get # a partitioning independent of #LDMs # (Keep the 2 partitions as in the backup image) ALTER TABLE t1 CHANGE COLUMN j j INT DEFAULT 6, CHANGE COLUMN f f FLOAT NOT NULL DEFAULT 6.6, CHANGE COLUMN d d DOUBLE DEFAULT 8.8 PARTITION BY KEY () PARTITIONS 2; # Show that the MySQL defaults are now ok. SHOW CREATE TABLE t1; # Show that the defaults are now native --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc --disable_warnings INSERT INTO t1 VALUES(); UPDATE t1 SET ch = "RESTORE FROM 6.3" WHERE i = 12; REPLACE INTO t1(i, j, ch) VALUES(20, 20, "RESTORE FROM 6.3"); --enable_warnings --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; # Show that table with MySQL, but no native defaults is still handled # correctly. # (This works as bit defaults have no endian problems) INSERT INTO bit1 VALUES(); UPDATE bit1 SET b5=b'1111111' WHERE pk = 1; REPLACE INTO bit1(pk, b3) VALUES(6, B'110011'); SELECT pk,BIN(b1),BIN(b2),BIN(b3),BIN(b4),BIN(b5) FROM bit1 ORDER BY pk; # Following commented-out as it's done above due to bug#53539 ######################################################################### # OFFLINE ALTER OF 'OLD' TABLE WITH NO DEFAULTS TO 'NEW' TABLE # WITH NATIVE DEFAULTS. (This is done above with bug#53539 workaround) ######################################################################### #--echo ******************************************************************************** #--echo * Alter table restoring from 6.3 backup to new table with native default support #--echo ******************************************************************************** #--let $ndb_desc_opts= -d test t1 #--source suite/ndb/include/ndb_desc_print.inc # #ALTER TABLE t1 CHANGE COLUMN j j INT DEFAULT 6; # #--let $ndb_desc_opts= -d test t1 #--source suite/ndb/include/ndb_desc_print.inc --disable_warnings INSERT INTO t1(i, ch) VALUES(99, "native default support"); --enable_warnings --replace_column 12 CURRENT_TIMESTAMP SELECT i, j, f, d, d2, ch, vch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c FROM t1 ORDER BY i; DROP TABLE IF EXISTS t1, bit1; --echo ************************************************************* --echo * Test adding a unique index to a column with a default value --echo ************************************************************* CREATE TABLE t2( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, j INT DEFAULT 6, f FLOAT NOT NULL DEFAULT 6.6, d DOUBLE DEFAULT 8.8, UNIQUE INDEX t2_unique_index(j) )ENGINE=NDB PARTITION BY KEY() PARTITIONS 8; INSERT INTO t2 VALUES(); --error 1062 INSERT INTO t2 VALUES(); INSERT INTO t2 VALUES(10, 10, 10.0, 10.0); SELECT * FROM t2 ORDER BY i; --echo ************************************************************* --echo * Test offline alter of default values --echo ************************************************************* ALTER TABLE t2 MODIFY COLUMN j INT DEFAULT 666; --let $ndb_desc_opts= -d test t2 --source suite/ndb/include/ndb_desc_print.inc INSERT INTO t2 VALUES(); SELECT * FROM t2 ORDER BY i; --echo ************************************************************* --echo * Test that online alter of default values fails --echo ************************************************************* --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t2 algorithm=inplace, MODIFY COLUMN j INT DEFAULT 888; DROP TABLE IF EXISTS t2; --echo ************************************************************** --echo * Test not null-after-defaults example that failed previously --echo ************************************************************** CREATE TABLE t1 ( a int primary key, b int default 12, c char not null )ENGINE=NDB PARTITION BY KEY() PARTITIONS 8; --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc DROP TABLE t1; --echo ************************************************************** --echo * Test mix of null, not-null, default etc.. --echo ************************************************************** CREATE TABLE t1 (a int primary key, b int default 12, c char not null, d varchar(6) default 'Daniel', e char(3) default 'Stu', f enum('NBFry','Kebab') default 'NBFry', g set('Chips','Pie','Fish') default 'Fish,Chips', h enum('Pig','Lion') not null, i char(2) default '66') engine = ndb partition by key() partitions 8; --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc DROP TABLE t1; --echo ****************************************** --echo * Test binary default with null char value --echo ****************************************** CREATE TABLE t1 (a int primary key, b binary(10) default 0x4142430045464748494a, c varbinary(100) default 0x4142430045464748494a) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE t1; --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc DROP TABLE t1; --echo *********************************** --echo * Test timestamp column weirdness --echo http://dev.mysql.com/doc/refman/5.1/en/timestamp.html --echo *********************************** --echo Timestamp updated on insert + update CREATE TABLE variant (a int primary key, b timestamp) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Full syntax for update on insert + update CREATE TABLE variant (a int primary key, b timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Default on insert only CREATE TABLE variant (a int primary key, b timestamp DEFAULT CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Set on update only CREATE TABLE variant (a int primary key, b timestamp DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP, c int) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a,c) VALUES (1,1); SELECT * from variant; UPDATE variant SET c=2; --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo No auto-set default 0 CREATE TABLE variant (a int primary key, b timestamp DEFAULT 0) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; DROP TABLE variant; --echo No auto-set default non-zero CREATE TABLE variant (a int primary key, b timestamp DEFAULT 19770623000001) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; DROP TABLE variant; --echo Non-first timestamp default insert value CREATE TABLE variant (a int primary key, b timestamp DEFAULT 19770623000001, c timestamp DEFAULT CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 3 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Non-first timestamp default update value CREATE TABLE variant (a int primary key, b timestamp DEFAULT 19770623000001, c timestamp ON UPDATE CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; UPDATE variant SET b=20100603000001; --replace_column 3 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Non-first timestamp set on insert+update CREATE TABLE variant (a int primary key, b timestamp DEFAULT 19770623000001, c timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 3 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp no default CREATE TABLE variant (a int primary key, b timestamp NULL) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp default zero CREATE TABLE variant (a int primary key, b timestamp NULL DEFAULT 0) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp default non-zero CREATE TABLE variant (a int primary key, b timestamp NULL DEFAULT 19770623000001) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp auto insert val CREATE TABLE variant (a int primary key, b timestamp NULL DEFAULT CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp auto update val CREATE TABLE variant (a int primary key, b timestamp NULL ON UPDATE CURRENT_TIMESTAMP, c int) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a,c) VALUES (1,1); SELECT * from variant; UPDATE variant SET c=2; --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo Nullable timestamp auto insert+update val CREATE TABLE variant (a int primary key, b timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) engine = ndb partition by key() partitions 8; SHOW CREATE TABLE variant; --let $ndb_desc_opts= -d test variant --source suite/ndb/include/ndb_desc_print.inc INSERT INTO variant (a) VALUES (1); --replace_column 2 CURRENT_TIMESTAMP SELECT * from variant; DROP TABLE variant; --echo ************************************************************* --echo * Restore data-only from old backup without native defaults * --echo ************************************************************* --echo Create schema manually with differences for ndb_restore to --echo deal with. See the backup (or above) for the original schema. --echo - J changed from Int -> Bigint, and default changed from 6 to 6006 --echo requires --promote-attributes AND default ignoring --echo - ch default changed from 'aaa' to 'aaaAAA', requires default ignoring --echo - vch missing in DB schema, requires --exclude-missing-columns --echo - timestamp_c default changed from CURRENT_TIMESTAMP to a const default (native) --echo requires default ignoring --echo - newOne is a new column with a default value, requires --exclude-missing-columns --echo - newTwo is a new nullable column with no default value, requires --exclude-missing-columns CREATE TABLE t1 ( `i` int(11) NOT NULL AUTO_INCREMENT, `j` bigint(20) NOT NULL DEFAULT '6006', `f` float NOT NULL DEFAULT '6.6', `d` double DEFAULT '8.8', `d2` double NOT NULL, `ch` char(19) DEFAULT 'aaaAAA', `b` binary(19) DEFAULT 'ccc\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `vb` varbinary(19) DEFAULT 'ddd', `blob1` blob, `text1` text, `timestamp_c` timestamp NOT NULL DEFAULT '2010-06-07 13:06:22', `newOne` varchar(255) DEFAULT 'Comment field default', `newTwo` bigint(20) DEFAULT NULL, PRIMARY KEY (`i`) ) ENGINE=ndbcluster AUTO_INCREMENT=18446744073709551615 DEFAULT CHARSET=latin1 PARTITION BY KEY() PARTITIONS 8; # Bit1 currently unchanged CREATE TABLE bit1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `b1` bit(3) DEFAULT b'111', `b2` bit(9) DEFAULT b'101', `b3` bit(23) DEFAULT b'110', `b4` bit(37) DEFAULT b'11', `b5` bit(63) DEFAULT b'101011', PRIMARY KEY (`pk`) ) ENGINE=ndbcluster AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 PARTITION BY KEY() PARTITIONS 8; SHOW CREATE TABLE t1; --let $ndb_desc_opts= -d test t1 --source suite/ndb/include/ndb_desc_print.inc --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -r --promote-attributes --exclude-missing-columns $backup_data_dir/before_native_default >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r --promote-attributes --exclude-missing-columns $backup_data_dir/before_native_default >> $NDB_TOOLS_OUTPUT SELECT i, j, f, d, d2, ch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, newOne, newTwo from t1 order by i; drop table bit1; --echo Now backup the current data and restore data-only to a different schema --source include/ndb_backup.inc drop table t1; CREATE TABLE t1 ( `i` int(11) NOT NULL AUTO_INCREMENT, `j` bigint NOT NULL DEFAULT '6', `f` float NOT NULL DEFAULT '6.6', `d` double DEFAULT '8.8', `d2` double NOT NULL, `ch` char(19) DEFAULT 'aaa', `b` binary(19) DEFAULT 'ccc\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `vb` varbinary(19) DEFAULT 'ddd', `blob1` blob, `text1` text, `timestamp_c` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `newOne` varchar(256) DEFAULT 'Comment field default', PRIMARY KEY (`i`) ) ENGINE=ndbcluster AUTO_INCREMENT=18446744073709551615 DEFAULT CHARSET=latin1; --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --promote-attributes --exclude-missing-columns $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --promote-attributes --exclude-missing-columns $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT SELECT i, j, f, d, d2, ch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, newOne from t1 order by i; --echo Now backup the current data then restore data-only to a schema with different defaults and no special ndb_restore options --source include/ndb_backup.inc drop table t1; CREATE TABLE t1 ( `i` int(11) NOT NULL AUTO_INCREMENT, `j` bigint NOT NULL DEFAULT '20', `f` float NOT NULL DEFAULT '6.66', `d` double DEFAULT '8.88', `d2` double NOT NULL DEFAULT '9.99', `ch` char(19) DEFAULT 'aaaZZZ', `b` binary(19) DEFAULT 'ccccc\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `vb` varbinary(19) DEFAULT 'dddDDDddd', `blob1` blob, `text1` text, `timestamp_c` timestamp NOT NULL DEFAULT 20100608133131, `newOne` varchar(256), PRIMARY KEY (`i`) ) ENGINE=ndbcluster AUTO_INCREMENT=18446744073709551615 DEFAULT CHARSET=latin1; --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT SELECT i, j, f, d, d2, ch, HEX(b), HEX(vb), HEX(blob1), text1, timestamp_c, newOne from t1 order by i; drop table t1; --echo Bug#55121 error 839 'Illegal null attribute' from NDB for fields with default value --echo Ensure that Ndb handler doesn't expect native defaults for Blobs. set @save_sql_mode = @@session.sql_mode; set sql_mode=STRICT_TRANS_TABLES; --error ER_BLOB_CANT_HAVE_DEFAULT CREATE TABLE t1 ( fid smallint(6) unsigned NOT NULL DEFAULT '0', f01 text NOT NULL, f02 varchar(255) NOT NULL DEFAULT '', f03 text NOT NULL DEFAULT '', PRIMARY KEY (fid) ) engine=ndb; set sql_mode=@save_sql_mode; --disable_warnings CREATE TABLE t1 ( fid smallint(6) unsigned NOT NULL DEFAULT '0', f01 text NOT NULL, f02 varchar(255) NOT NULL DEFAULT '', f03 text NOT NULL DEFAULT '', PRIMARY KEY (fid) ) engine=ndb; --enable_warnings show create table t1; insert into t1(fid) value(100); select fid, isnull(f01), isnull(f02), isnull(f03) from t1; drop table t1; --source suite/ndb/include/restore_sql_mode_after_turn_off_strict.inc
Close
