石橋卓見
ishib****@syste*****
2012年 5月 2日 (水) 20:27:24 JST
$B?\F#MM(B $B%7%9%F%`%=%U%H ＠ P66$G$9!#$*@$OC$K$J$j$^$9!#(B $B$=$l$G$O!"$*8 ＠ MU$K4E$($F!"2<5-%9%-!<%^Dj5A$r$*Aw$j$5$;$FD:$-$^$9!#(B $B;29M$K$J$l$P9,$$$G$9!#(B $B>0!"0lE@!"$465<($$$?$@$-$?$$$N$G$9$,!":G?7$N(Bmysql-mroonga$B$r(Byum update $B$K$FF3F~$7$?:]!"2<5-$N%(%i!<$,=P$F$*$j$^$7$?!#(B ERROR 1125 (HY000) at line 1: Function 'mroonga' already exists $B"((B/usr/lib64/mysql/plugin$B!!%U%)%k%@Fb$N(Bso$B%U%!%$%k$O$-$A$s$H99?7$5$l$F(B $B!!$$$k$h$&$G$7$?!#(B $B0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B ------------------------------------------------------------------------ $B%F!<%V%k#1(B CREATE TABLE TBL_SPEECH( SID INTEGER PRIMARY KEY AUTO_INCREMENT PRIMARY KEY NOT NULL , START_TIME DATETIME NOT NULL , START_TIME_MSEC INTEGER NOT NULL , END_TIME DATETIME NOT NULL , END_TIME_MSEC INTEGER NOT NULL , FILE_PATH VARCHAR(100) NOT NULL , CODEC VARCHAR(20) NOT NULL , SPEECH_TEXT TEXT NOT NULL , TID INTEGER NOT NULL , UPDATE_TIME DATETIME NOT NULL , FULLTEXT INDEX (SPEECH_TEXT) ) ENGINE = mroonga COMMENT = 'engine "innodb"' DEFAULT CHARSET utf8; CREATE INDEX IDX_TID ON TBL_SPEECH (TID); CREATE INDEX IDX_START_TIME ON TBL_SPEECH (START_TIME); CREATE INDEX IDX_END_TIME ON TBL_SPEECH (END_TIME); ------------------------------------------------------------------------ $B>e5-Am%l%3!<%I?t!!(B3,692,774$B7o(B ------------------------------------------------------------------------ $B%F!<%V%k#2(B CREATE TABLE TBL_TELEPHONE( TID INTEGER PRIMARY KEY AUTO_INCREMENT PRIMARY KEY NOT NULL , COMMUNICATOR_ID VARCHAR(50) NOT NULL , START_TIME DATETIME NOT NULL , END_TIME DATETIME , UPDATE_TIME DATETIME NOT NULL , TEL_END_FLG TINYINT NOT NULL DEFAULT 0 , CONSTRAINT UNIQUE(COMMUNICATOR_ID,START_TIME) ) engine = InnoDB; CREATE INDEX IDX_COMMUNICATOR_ID ON TBL_TELEPHONE (COMMUNICATOR_ID); ------------------------------------------------------------------------ $B>e5-Am%l%3!<%I?t!!(B112,941$B7o(B ------------------------------------------------------------------------ ------------------------------------------------------------------------ $B%(%i!<$r:F8=$9$k(BSQL SELECT * FROM TBL_SPEECH left join TBL_TELEPHONE on TBL_SPEECH.tid = TBL_TELEPHONE.tid WHERE MATCH(TBL_SPEECH.speech_text) AGAINST('$B$"(B') AND TBL_TELEPHONE.communicator_id IN ('ishibashi-t') AND ('2012/02/01 09:00' <= TBL_SPEECH.start_time AND '2012/04/23 18:00' >= TBL_SPEECH.end_time) ORDER BY 1 LIMIT 100; ------------------------------------------------------------------------ SQL$B<B9TCf$K0J2<$N%(%i!<$,H/@8$7$^$7$?!#(B $B%(%i!<%3!<%I!'(B1032 [MySQL][ODBC 5.1 Driver][mysqld-5.1.61]Can't find record in 'TBL_SPEECH' SQL$B%9%F!<%?%9!'(BS1000 ------------------------------------------------------------------------ $B%(%i!<$NH/@8>r7o(B $B-!A4J88!:w%+%i%`$r;}$D%F!<%V%k$K!"O"B3$7$F%F%-%9%H%G!<%?$rEjF~!#(B $B!!"(#1#0%/%(%j!?KhIC0L$G$7$g$&$+!#(B $B-"$^$5$K(BINSERT$B$7B3$1$F$$$k>u67$G!"$=$N%F%-%9%H%G!<%?$K$?$^$?$^4^$^$l$k(B $B!!J8;zNs$r(BSELECT$B!A(BMATCH$B!A(BAGAINST$B$GA4J88!:w$9$k$H!"2<5-%(%i!<$,H/@8$9$k!#(B $B-#A4J88!:w$K;HMQ$7$?%/%(%j$O!"B>$N%F!<%V%k$H(BJOIN$B$7$F$$$k!#(B $B!!(BJOIN$B$;$:!"C1FH$G(BSELECT$B!A(BMATCH$B!A(BAGAINST$B$GA4J88!:w$7$F$b%(%i!<$OH/@8(B $B!!$7$J$$!#(B $B-%(BORDER BY$B6g$,$J$$$H%(%i!<$OH/@8$7$J$$!#!J%=!<%H%+%i%`$O$I$l$G$bH/@8!K(B $B-&(BSTART TRANSACTION$B!"(BCOMMIT$B4V$K$*$$$F(BINSERT$B$7$F$$$k%F%-%9%H$N$9$Y$F$H(B $B!!8!:wBP>]$NJ8;zNs$,0lCW$7$?>l9g$KH/@8$7$F$*$j$^$9!#(B $B!!$^$?%H%i%s%6%/%7%g%s$r;HMQ$7$J$$!J(BAutoCommit$B!K$N>uBV$G$bH/@8IQEY$ODc$$(B $B!!$G$9$,!"%(%i!<$OH/@8$7$^$9!#(B $B-'0lEY$G$bH/@8$7$?>l9g!"(BINSERT$B$7$F$$$k%F%-%9%H$H%j%"%k%?%$%`$K0lCW$7$J(B $B!!$/$F$b!"0J9_!"8!:w$K;HMQ$7$?J8;zNs$K$*$1$kA4J88!:w$OA4$F<:GT$7$^$9!#(B $B-((BRepair table TBL_SPEECH $B$r<B9T$9$k$H!"@5>o$KF0:n$7$^$9!#(B ------------------------------------------------------------------------ $B%Q%C%1!<%8%P!<%8%g%s(B [root ＠ ccminig ~]# rpm -qa | grep roonga groonga-repository-1.0.1-0.noarch groonga-tokenizer-mecab-2.0.2-0.el6.x86_64 mysql-mroonga-2.02-0.el6.x86_64 groonga-plugin-suggest-2.0.2-0.el6.x86_64 groonga-2.0.2-0.el6.x86_64 groonga-libs-2.0.2-0.el6.x86_64 groonga-devel-2.0.2-0.el6.x86_64 ------------------------------------------------------------------------ $B"!(B $B ＠ P66(B $BBn8+(B / Takken Ishibashi $B""(B $B3t<02q<R(B $B%7%9%F%`%=%U%H(B $B""(B $B%7%9%F%`;v6HIt(B / $B%7%9%F%`3+H/#3It(B $B""(B Tel:03-5776-5910 / Fax:03-5776-5919 $B""(B mobile phone:090-9689-0997 $B"!(B mailto:ishib****@syste***** >On Wed, 02 May 2012 18:32:30 +0900 (JST) >Kouhei Sutou <kou****@clear*****> wrote: > > > $B?\F#$G$9!#(B > > In <20120****@syste*****> > "[groonga-dev,00801] Re: $BO"B3(BINSERT$B;~$KA4J88!:w$G%(%i!<(B" on Tue, 01 May 2012 15:16:27 +0900, > $B ＠ P66Bn8+(B <ishib****@syste*****> wrote: > > > $B7GBj$N7o$K$D$-$^$7$F!"@hF|%j%j!<%9$5$l$?!"(Bgroonga2.02$B!"(Bmroonga 2.02$B$r(B > > $B%j%]%8%H%j$h$j%"%C%W%G!<%H$7!":FEY8!>Z$$$?$7$^$7$?=j!"@hHL$4Js9p$rCW$7(B > > $B$^$7$?!"!VO"B3(BINSERT$B;~$KA4J88!:w$G%(%i!<!W$N7o$K$D$-$^$7$F$O!">I>u$,(B > > $B2~A1$7$J$+$C$?0Y!"G0$N0Y$4Js9p$r$5$;$F$$$?$@$-$^$9!#(B > > # $B:#2s$O!"(BRepair Table $B$rDj;~%P%C%A$GF0$+$7$F!"2sHr$9$k$3$H$H$7$^$7$?!#(B > > $B$b$7$h$m$7$1$l$P!"(BJOIN$B$7$F$$$k(Btable1$B$H(Btable2$B$N%9%-!<%^Dj5A$r(B > $B65$($i$l$kHO0O$G7k9=$G$9$N$G65$($FD:$1$J$$$G$7$g$&$+!)$=$A$i(B > $B$r;H$C$F<j85$G:F8=$G$-$J$$$+;n$7$F$_$?$$$H9M$($F$$$^$9!#(B > > -- > $B?\F#(B $B8yJ?(B <kou****@clear*****> > $B3t<02q<R%/%j%"%3!<%I(B <http://www.clear-code.com/> (03-6231-7270) > > groonga$B%5%]!<%H(B: > http://groonga.org/ja/support/ > $B%W%m%0%i%_%s%0$,9%$-$J%=%U%H%&%'%"3+H/<T$rJg=8Cf(B: > http://www.clear-code.com/recruitment/ > > _______________________________________________ > groonga-dev mailing list > groon****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/groonga-dev
