CMP FBPK Yields an individual SELECT per column
-----------------------------------------------
Key: GERONIMO-985
URL: http://issues.apache.org/jira/browse/GERONIMO-985
Project: Geronimo
Type: Bug
Versions: 1.0-M5
Environment: Geronimo w/Derby
Reporter: Matt Hogstrom
I'm testing the DayTrader Application and it appears that FBPK finds are
executing a single SELECT per field in the CMP field. Here are the SELECTs
making up a single OrderEJB.findByPrimaryKey(). This should be broken down
into a single SELECT for the entity.
SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.companyName FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.volume FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.price FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.open1 FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.low FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.high FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.change1 FROM QuoteEJB Q WHERE Q.symbol = s:153
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
