BDB 타입으로 모든 테이블을 만든후
Query 에서 이상한 에러가 생기는데요..
아래 쿼리를 잘 보시면
select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
란 쿼리를 날리기전의 쿼리가 결과가 있으면 위의 쿼리는 에러가
없지만, 날리기전의 쿼리의 결과 없으면 위의 쿼리는 에러가
납니다.
outer join이 트랜잭션과 관련이 있어서 그런가요?
여하튼 이유를 잘 모르겠습니다...
mysql> select p.*,
-> a.addressno,
-> a.customerid,
-> a.customername1,
-> a.customername2,
-> a.customername3,
-> a.street1,
-> a.street2,
-> a.street3,
-> a.city,
-> a.state,
-> a.country,
-> a.zipcode,
-> a.phone1,
-> a.phone2,
-> a.fax,
-> a.email,
-> a.address,
-> c.*
-> from EBF_CUSTOMER c,
-> EBF_ADDRESSBOOK a
-> left join EBF_CUSTOMERPROFILE p on c.customerid=p.customerid
-> where c.customerid=a.customerid and
-> c.customerid='admin';
+------------+-------------+-----------+------------+---------------+----------
.......어쩌구저쩌구 결과.....
-----+------+-------+---------+---------+-------------+--------+------+-------1 row in set (0.01 sec)
mysql> select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
Empty set (0.01 sec) <=== 에러가 안나죠..
mysql> select p.*,
-> a.addressno,
-> a.customerid,
-> a.customername1,
-> a.customername2,
-> a.customername3,
-> a.street1,
-> a.street2,
-> a.street3,
-> a.city,
-> a.state,
-> a.country,
-> a.zipcode,
-> a.phone1,
-> a.phone2,
-> a.fax,
-> a.email,
-> a.address,
-> c.*
-> from EBF_CUSTOMER c,
-> EBF_ADDRESSBOOK a
-> left join EBF_CUSTOMERPROFILE p on c.customerid=p.customerid
-> where c.customerid=a.customerid and
-> c.customerid='WWWanonymous';
Empty set (0.00 sec)
mysql> select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
ERROR 1015: Can't lock file (errno: -30989) <==에러가 납니다.
|