hi:
As a newbie, I do not want to report a “bug” before I check with the community first. Below is what I did on my dell laptop running Ubuntu:
hung@laptop-dell:~$ uname -a
Linux laptop-dell 2.6.24-23-generic #1 SMP Mon Jan 26 01:04:16 UTC 2009 x86_64 GNU/Linux
hung@laptop-dell:~$ mysql-ib—version
/opt/infobright-3.1-x86_64/bin/mysql Ver 14.13 Distrib 5.1.14, for unknown-linux-gnu (x86_64) using EditLine wrapper
hung@laptop-dell:~$ mysql-ib mytest
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.14-log build number (revision)=IB_3.1_r2625_2673(ice)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> create table t (str varchar(16) not null) engine=brighthouse;
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile ‘/home/hung/test.dat’ into table t;
Query OK, 1 row affected (0.07 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select * from t;
+——————-+
| str |
+——————-+
| hello world |
+——————-+
1 row in set (0.01 sec)
mysql> create table s (str varchar(16) not null) engine=brighthouse;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from s;
Empty set (0.00 sec)
mysql> select * from s union select * from t;
+——————-+
| str |
+——————-+
| hello
he |
+——————-+
1 row in set (0.00 sec)
mysql> select * from t union select * from s;
+——————-+
| str |
+——————-+
| hello world |
+——————-+
1 row in set (0.00 sec)
Please let me know if anyone else has seen this issue, thanks in advance.
—Hu`ng Phan
