diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/3.23/ins000001.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/3.23/err000001.test | 3 | ||||
| -rw-r--r-- | mysql-test/t/3.23/ins000001.test | 11 |
3 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/3.23/ins000001.result b/mysql-test/r/3.23/ins000001.result new file mode 100644 index 00000000000..1003b3b6b18 --- /dev/null +++ b/mysql-test/r/3.23/ins000001.result @@ -0,0 +1,4 @@ +id domain +1 mysql.com +2 hotmail.com +3 aol.com diff --git a/mysql-test/t/3.23/err000001.test b/mysql-test/t/3.23/err000001.test new file mode 100644 index 00000000000..f264c0bb172 --- /dev/null +++ b/mysql-test/t/3.23/err000001.test @@ -0,0 +1,3 @@ +use test; +drop table if exists foo; +!$1146 insert into foo values(1); diff --git a/mysql-test/t/3.23/ins000001.test b/mysql-test/t/3.23/ins000001.test new file mode 100644 index 00000000000..7fafd7d48f1 --- /dev/null +++ b/mysql-test/t/3.23/ins000001.test @@ -0,0 +1,11 @@ +use test; +drop table if exists emails; +drop table if exists domain; +drop table if exists domain; +create table emails (email varchar(50)); +insert into emails values ('sasha@mysql.com'),('monty@mysql.com'), +('foo@hotmail.com'),('foo@aol.com'),('bar@aol.com'); +create table domain(id int not null auto_increment primary key, + domain varchar(50), unique(domain)); +insert into domain (domain) select distinct substring(email, locate('@', email)+1) from emails; +@r/3.23/ins000001.result select * from domain; |