diff options
Diffstat (limited to 'mysql-test/t/dyncol.test')
| -rw-r--r-- | mysql-test/t/dyncol.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/dyncol.test b/mysql-test/t/dyncol.test index ca3ff600509..ca95dea0779 100644 --- a/mysql-test/t/dyncol.test +++ b/mysql-test/t/dyncol.test @@ -458,6 +458,7 @@ insert into t1 values (6, column_create(10, "test2")); update t1 set str=column_add(str, 2, 'c', 1, column_get(str, 1 as int) + 1, 3, 100) where id > 2; # Check data +--sorted_result select id, length(str), column_get(str, 1 as int), column_get(str, 2 as char), column_get(str, 3 as int) from t1; # You can do anything with the columns, like SUM() or GROUP @@ -471,14 +472,17 @@ select sum(column_get(str, 1 as int)) from t1 where column_get(str, 3 as int) > select id, column_list(str) from t1 where id= 5; update t1 set str=column_delete(str, 3, 4, 2) where id= 5; +--sorted_result select id, length(str), column_list(str), column_get(str, 1 as int), column_get(str, 2 as char), column_get(str, 3 as int) from t1; update t1 set str=column_add(str, 4, 45 as char, 2, 'c') where id= 5; select id, length(str), column_list(str), column_get(str, 1 as int), column_get(str, 2 as char), column_get(str, 3 as int) from t1 where id = 5; # Check which column exists +--sorted_result select id, length(str), column_list(str), column_exists(str, 4) from t1; select sum(column_get(str, 1 as int)), column_list(str) from t1 group by 2; +--sorted_result select id, hex(str) from t1; # Check with a bit larger strings |