diff options
| author | unknown <serg@serg.mysql.com> | 2001-01-05 23:31:34 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2001-01-05 23:31:34 +0100 |
| commit | ff59a22d043777c61c468cd198e22477db49aa63 (patch) | |
| tree | eec5cfb66123feac695ebe8853213eee6e42b296 /mysql-test | |
| parent | 784f9e5975b8ccb3b8b6f4d2e77f6d500f6a4fc0 (diff) | |
| download | mariadb-git-ff59a22d043777c61c468cd198e22477db49aa63.tar.gz | |
sql_select.cc check for cond==NULL in add_ft_keys()
fulltext_left_join.result BitKeeper file /usr/home/serg/Abk/mysql/mysql-test/r/fulltext_left_join.result
fulltext_left_join.test BitKeeper file /usr/home/serg/Abk/mysql/mysql-test/t/fulltext_left_join.test
mysql-test/t/fulltext_left_join.test:
edited
sql/sql_select.cc:
check for cond==NULL in add_ft_keys()
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext_left_join.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/fulltext_left_join.test | 25 |
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext_left_join.result b/mysql-test/r/fulltext_left_join.result new file mode 100644 index 00000000000..04244e309e5 --- /dev/null +++ b/mysql-test/r/fulltext_left_join.result @@ -0,0 +1,5 @@ +match(t1.texte,t1.sujet,t1.motsclefs) against('droit') +0 +0 +0.67003110026735 +0 diff --git a/mysql-test/t/fulltext_left_join.test b/mysql-test/t/fulltext_left_join.test new file mode 100644 index 00000000000..bbe2beb7d0e --- /dev/null +++ b/mysql-test/t/fulltext_left_join.test @@ -0,0 +1,25 @@ +# +# Test for bug from Jean-Cédric COSTA <jean-cedric.costa@ensmp.fr> +# + +CREATE TABLE t1 ( + id VARCHAR(255) NOT NULL PRIMARY KEY, + sujet VARCHAR(255), + motsclefs TEXT, + texte MEDIUMTEXT, + FULLTEXT(sujet, motsclefs, texte) +); +INSERT INTO t1 VALUES('123','toto','essai','test'); +INSERT INTO t1 VALUES('456','droit','penal','lawyer'); +INSERT INTO t1 VALUES('789','aaaaa','bbbbb','cccccc'); +CREATE TABLE t2 ( + id VARCHAR(255) NOT NULL, + author VARCHAR(255) NOT NULL +); +INSERT INTO t2 VALUES('123', 'moi'); +INSERT INTO t2 VALUES('123', 'lui'); +INSERT INTO t2 VALUES('456', 'lui'); + +select match(t1.texte,t1.sujet,t1.motsclefs) against('droit') + from t1 left join t2 on t2.id=t1.id; + |