[MDEV-20314] Segmentation fault Created: 2019-08-10  Updated: 2019-09-02

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: None

Type: Bug Priority: Major
Reporter: João Costa Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

MariaDB official docker image ( Ubuntu Linux )

Attachments: File custom.cnf     File sampledb.sql     Text File stacktrace.txt    

 Description   

I am seeing the mariadb server core dumping while using libmysqludf_ta, but only if the derived_merge optimizer switch is turned off. This happens in mariadb 10.2 and above. It works on 10.1.

While I first imagined this was most likely a bug in libmysqludf_ta, the attached stack trace does not mention libmysqludf_ta, hinting that perhaps something else is wrong.

The problem is fairly easy to reproduce, ie:

# Clone the udf repo
 
git clone git@github.com:joaocosta/lib_mysqludf_ta.git
 
 
 
cd lib_mysqludf_ta/
 
 
 
# change to a mariadb version where the problem happens
 
sed -i 's/10.1/10.4/' Dockerfile
 
 
 
docker build --tag db_test .
 
 
 
# Turn off derived_merge, it does not segfault if derived_merge is ON (but then the query returns the wrong results)
 
echo "[mysqld]
 
optimizer_switch='derived_merge=OFF'
 
" > /tmp/custom.cnf
 
 
 
# Run a mariadb instance with the required setup in place
 
docker run -v /tmp/database:/var/lib/mysql \
 
           -v /tmp/custom.cnf:/etc/mysql/conf.d/custom.cnf \
 
           --name db \
 
           -e "MYSQL_ROOT_PASSWORD=root" \
 
           -e "MYSQL_DATABASE=db" \
 
           -e "MYSQL_USER=db" \
 
           -e "MYSQL_PASSWORD=db" -d db_test
 
 
 
 
 
docker exec -ti db bash
 
 
 
# Create a sample database to run the offending query against
 
mysql -uroot -proot db < sampledb.sql
 
 
 
mysql -uroot -proot db

Once you have a mysql client prompt, run the query:

SELECT * FROM (
 
 
 
SELECT datetime as `datetime`, ta_previous(round(ta_rsi(close,14), 2),40) AS F1, ta_previous(close,40), ta_max(high,40), ta_min(low,40)
 
FROM (
 
  SELECT * FROM EURUSD_86400
 
  WHERE datetime >= '0001-01-01' AND datetime <= '9999-12-31'
 
  ORDER BY datetime DESC
 
  LIMIT 5000
 
) AS R
 
ORDER BY datetime ASC
 
 
 
) AS LIMIT_ROWS
 
 
 
WHERE F1 > 75
 
ORDER BY datetime DESC
 
LIMIT 20;

After running that query a couple of times, the server will crash with the attached stack trace, that can be retrieved with:

docker logs db

Thanks

 Comments   
Comment by Alice Sherepa [ 2019-08-12 ]

Could you please provide the output of 

SHOW CREATE FUNCTION ta_previous;
 
SHOW CREATE FUNCTION ta_max;
 
SHOW CREATE FUNCTION ta_min;

and upload sampledb.sql, custom.cnf
I tried to reproduce without them:

CREATE TABLE `EURUSD_86400` (
 
  `datetime` datetime NOT NULL,
 
  `open` float NOT NULL,
 
  `low` float NOT NULL,
 
  `high` float NOT NULL,
 
  `close` float NOT NULL,
 
  PRIMARY KEY (`datetime`)
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 
 
INSERT INTO `EURUSD_86400` VALUES ('2001-01-03 00:00:00',0.9507,0.9262,0.9569,0.9273),('2001-01-04 00:00:00',0.9283,0.9269,0.9515,0.9503),('2001-01-05 00:00:00',0.9532,0.9464,0.9591,0.9575),('2001-01-08 00:00:00',0.9582,0.9462,0.9588,0.9467),('2001-01-09 00:00:00',0.9464,0.9384,0.9477,0.9436),('2001-01-10 00:00:00',0.9437,0.9361,0.9464,0.9362),('2001-01-11 00:00:00',0.9367,0.9364,0.9549,0.952),('2001-01-12 00:00:00',0.9522,0.9468,0.9575,0.9523),('2001-01-15 00:00:00',0.9502,0.9408,0.9521,0.9431),('2001-01-16 00:00:00',0.9431,0.9371,0.9438,0.9422),('2001-01-17 00:00:00',0.942,0.9288,0.9442,0.9354),('2001-01-18 00:00:00',0.9361,0.9352,0.946,0.9424),('2001-01-19 00:00:00',0.9428,0.9337,0.9499,0.9346),('2001-01-22 00:00:00',0.9345,0.9269,0.9401,0.9383),('2001-01-23 00:00:00',0.9387,0.9343,0.9447,0.9355),('2001-01-24 00:00:00',0.9353,0.9209,0.9369,0.9226),('2001-01-25 00:00:00',0.9233,0.9114,0.9248,0.9234),('2001-01-26 00:00:00',0.9243,0.9198,0.9314,0.9243),('2001-01-29 00:00:00',0.9236,0.9159,0.9258,0.9171),('2001-01-30 00:00:00',0.9175,0.9143,0.9276,0.926),('2001-01-31 00:00:00',0.9263,0.9253,0.9374,0.9363),('2001-02-01 00:00:00',0.937,0.9365,0.9442,0.9383),('2001-02-02 00:00:00',0.9362,0.9318,0.9417,0.9357),('2001-02-05 00:00:00',0.9362,0.9351,0.9438,0.9376),('2001-02-06 00:00:00',0.9374,0.9283,0.9383,0.9309),('2001-02-07 00:00:00',0.9306,0.9257,0.9347,0.9281),('2001-02-08 00:00:00',0.9284,0.9149,0.9298,0.9177),('2001-02-09 00:00:00',0.9182,0.9131,0.927,0.9253),('2001-02-12 00:00:00',0.9247,0.9247,0.9327,0.9319),('2001-02-13 00:00:00',0.9322,0.917,0.9327,0.9201),('2001-02-14 00:00:00',0.9197,0.9164,0.9216,0.9175),('2001-02-15 00:00:00',0.9179,0.9024,0.9193,0.9045),('2001-02-16 00:00:00',0.9052,0.905,0.9172,0.9146),('2001-02-19 00:00:00',0.9126,0.912,0.9233,0.9212),('2001-02-20 00:00:00',0.921,0.9049,0.9236,0.9111),('2001-02-21 00:00:00',0.91,0.9056,0.918,0.9089),('2001-02-22 00:00:00',0.9096,0.9014,0.9128,0.904),('2001-02-23 00:00:00',0.9045,0.9025,0.9204,0.9169),('2001-02-26 00:00:00',0.9172,0.9078,0.9183,0.9109),('2001-02-27 00:00:00',0.9083,0.9082,0.9203,0.9178),('2001-02-28 00:00:00',0.9182,0.916,0.9253,0.9239),('2001-03-01 00:00:00',0.9228,0.9225,0.9318,0.9305),('2001-03-02 00:00:00',0.9306,0.9288,0.9377,0.9348),('2001-03-05 00:00:00',0.9361,0.9264,0.9364,0.9284),('2001-03-06 00:00:00',0.9263,0.925,0.9345,0.9333),('2001-03-07 00:00:00',0.9332,0.9262,0.9368,0.9293),('2001-03-08 00:00:00',0.9288,0.9271,0.9337,0.9326),('2001-03-09 00:00:00',0.9327,0.9292,0.937,0.9322),('2001-03-12 00:00:00',0.9319,0.9258,0.9339,0.9283),('2001-03-13 00:00:00',0.929,0.9128,0.9298,0.9141),('2001-03-14 00:00:00',0.9147,0.9077,0.9207,0.9112),('2001-03-15 00:00:00',0.9111,0.8953,0.9124,0.8969),('2001-03-16 00:00:00',0.8981,0.8913,0.8999,0.8958),('2001-03-19 00:00:00',0.8967,0.8933,0.9017,0.8993),('2001-03-20 00:00:00',0.8991,0.8985,0.9115,0.9097),('2001-03-21 00:00:00',0.9109,0.8932,0.912,0.8963),('2001-03-22 00:00:00',0.896,0.8832,0.8963,0.8892),('2001-03-23 00:00:00',0.8887,0.8852,0.8964,0.8882),('2001-03-26 00:00:00',0.8907,0.8885,0.8967,0.8962),('2001-03-27 00:00:00',0.8965,0.8896,0.8989,0.8931),('2001-03-28 00:00:00',0.8933,0.8844,0.8944,0.8853),('2001-03-29 00:00:00',0.886,0.8796,0.8882,0.8825),('2001-03-30 00:00:00',0.8821,0.8748,0.8873,0.877),('2001-04-02 00:00:00',0.8741,0.8735,0.8832,0.8795),('2001-04-03 00:00:00',0.8806,0.8793,0.8983,0.8981),('2001-04-04 00:00:00',0.8966,0.8933,0.9047,0.9011),('2001-04-05 00:00:00',0.9012,0.8942,0.9086,0.8966),('2001-04-06 00:00:00',0.8966,0.8924,0.9046,0.9034),('2001-04-09 00:00:00',0.9035,0.896,0.9045,0.897),('2001-04-10 00:00:00',0.8971,0.8865,0.899,0.8885),('2001-04-11 00:00:00',0.8887,0.8809,0.8913,0.8881),('2001-04-12 00:00:00',0.8882,0.8835,0.894,0.8925),('2001-04-13 00:00:00',0.8925,0.8925,0.8925,0.8925),('2001-04-16 00:00:00',0.8888,0.8837,0.89,0.8886),('2001-04-17 00:00:00',0.8881,0.8775,0.8907,0.8831),('2001-04-18 00:00:00',0.8826,0.8698,0.8893,0.8821),('2001-04-19 00:00:00',0.8833,0.8805,0.8985,0.8982),('2001-04-20 00:00:00',0.8973,0.8952,0.9045,0.903),('2001-04-23 00:00:00',0.9023,0.8945,0.9077,0.8961),('2001-04-24 00:00:00',0.8969,0.893,0.9016,0.8941),('2001-04-25 00:00:00',0.8943,0.8906,0.8998,0.8977),('2001-04-26 00:00:00',0.8974,0.8945,0.904,0.9031),('2001-04-27 00:00:00',0.9031,0.8886,0.9051,0.8916),('2001-04-30 00:00:00',0.891,0.885,0.8922,0.8894),('2001-05-01 00:00:00',0.8889,0.8856,0.8938,0.8927),('2001-05-02 00:00:00',0.8929,0.8884,0.8948,0.8938),('2001-05-03 00:00:00',0.896,0.8879,0.8974,0.8898),('2001-05-04 00:00:00',0.8899,0.8893,0.9004,0.8949),('2001-05-07 00:00:00',0.8924,0.8897,0.8932,0.8902),('2001-05-08 00:00:00',0.8903,0.8822,0.8912,0.8849),('2001-05-09 00:00:00',0.8848,0.881,0.8866,0.8856),('2001-05-10 00:00:00',0.8861,0.878,0.8918,0.8812),('2001-05-11 00:00:00',0.8814,0.8737,0.882,0.8762),('2001-05-14 00:00:00',0.8754,0.8725,0.8757,0.8741),('2001-05-15 00:00:00',0.8741,0.8732,0.8795,0.8782),('2001-05-16 00:00:00',0.8776,0.8747,0.8865,0.883),('2001-05-17 00:00:00',0.8828,0.8792,0.8877,0.8825),('2001-05-18 00:00:00',0.8826,0.8754,0.8827,0.8797),('2001-05-21 00:00:00',0.8801,0.8739,0.8815,0.8766),('2001-05-22 00:00:00',0.8763,0.8625,0.8772,0.8651),('2001-05-23 00:00:00',0.8643,0.8547,0.8659,0.8562),('2001-05-24 00:00:00',0.8554,0.8494,0.861,0.8562),('2001-05-25 00:00:00',0.8573,0.8536,0.8625,0.8595),('2001-05-28 00:00:00',0.86,0.8578,0.8605,0.8599),('2001-05-29 00:00:00',0.8599,0.8529,0.861,0.8551),('2001-05-30 00:00:00',0.8557,0.8534,0.8588,0.8565),('2001-05-31 00:00:00',0.8553,0.8441,0.8563,0.8456),('2001-06-01 00:00:00',0.8458,0.8433,0.8494,0.8474),('2001-06-04 00:00:00',0.8468,0.844,0.8535,0.8464),('2001-06-05 00:00:00',0.847,0.8424,0.8544,0.854),('2001-06-06 00:00:00',0.8538,0.8444,0.8565,0.8476),('2001-06-07 00:00:00',0.8465,0.8455,0.8517,0.8504),('2001-06-08 00:00:00',0.8511,0.8457,0.8515,0.8508),('2001-06-11 00:00:00',0.8498,0.841,0.8537,0.8431),('2001-06-12 00:00:00',0.8441,0.8413,0.8536,0.853),('2001-06-13 00:00:00',0.8533,0.8509,0.8564,0.8551),('2001-06-14 00:00:00',0.8544,0.8485,0.8632,0.8624),('2001-06-15 00:00:00',0.8626,0.8598,0.8671,0.8616),('2001-06-18 00:00:00',0.8628,0.8573,0.8639,0.8607),('2001-06-19 00:00:00',0.8596,0.8525,0.8605,0.8535),('2001-06-20 00:00:00',0.8539,0.8495,0.8555,0.8551),('2001-06-21 00:00:00',0.8546,0.8514,0.8579,0.854),('2001-06-22 00:00:00',0.8539,0.8509,0.8573,0.856),('2001-06-25 00:00:00',0.8567,0.8563,0.8622,0.8588),('2001-06-26 00:00:00',0.8595,0.8586,0.8649,0.8636),('2001-06-27 00:00:00',0.8635,0.8585,0.8657,0.8593),('2001-06-28 00:00:00',0.8589,0.843,0.8611,0.8437),('2001-06-29 00:00:00',0.844,0.8435,0.8493,0.8487),('2001-07-02 00:00:00',0.8493,0.844,0.8504,0.8474),('2001-07-03 00:00:00',0.8474,0.8453,0.8499,0.8481),('2001-07-04 00:00:00',0.8473,0.8433,0.8499,0.846),('2001-07-05 00:00:00',0.847,0.8352,0.8477,0.836),('2001-07-06 00:00:00',0.8361,0.835,0.8475,0.8469),('2001-07-09 00:00:00',0.8466,0.8444,0.8512,0.85),('2001-07-10 00:00:00',0.8495,0.8489,0.8571,0.8547),('2001-07-11 00:00:00',0.8551,0.853,0.8639,0.8585),('2001-07-12 00:00:00',0.8575,0.8506,0.8581,0.8534),('2001-07-13 00:00:00',0.8536,0.8508,0.8558,0.8542),('2001-07-16 00:00:00',0.8543,0.8521,0.8589,0.8528),('2001-07-17 00:00:00',0.8522,0.849,0.8607,0.8595),('2001-07-18 00:00:00',0.8598,0.8569,0.874,0.8735),('2001-07-19 00:00:00',0.8724,0.8679,0.8777,0.8707),('2001-07-20 00:00:00',0.8714,0.8701,0.8784,0.8712),('2001-07-23 00:00:00',0.8702,0.8652,0.8713,0.8689),('2001-07-24 00:00:00',0.869,0.8686,0.8769,0.8735),('2001-07-25 00:00:00',0.8729,0.8715,0.8811,0.8805),('2001-07-26 00:00:00',0.8803,0.8745,0.8821,0.8779),('2001-07-27 00:00:00',0.8779,0.8723,0.8803,0.8763),('2001-07-30 00:00:00',0.876,0.8722,0.8771,0.8744),('2001-07-31 00:00:00',0.8741,0.8723,0.8777,0.8757),('2001-08-01 00:00:00',0.876,0.8758,0.8828,0.8811),('2001-08-02 00:00:00',0.8809,0.8783,0.8838,0.8837),('2001-08-03 00:00:00',0.8833,0.8774,0.8873,0.8835),('2001-08-06 00:00:00',0.8829,0.8784,0.8831,0.8816),('2001-08-07 00:00:00',0.8805,0.8751,0.8813,0.8774),('2001-08-08 00:00:00',0.8765,0.874,0.8805,0.8801),('2001-08-09 00:00:00',0.8811,0.88,0.8938,0.892),('2001-08-10 00:00:00',0.8917,0.8909,0.8957,0.8934),('2001-08-13 00:00:00',0.8936,0.8921,0.9006,0.8961),('2001-08-14 00:00:00',0.8968,0.8938,0.9034,0.9028),('2001-08-15 00:00:00',0.9025,0.9019,0.9148,0.9138),('2001-08-16 00:00:00',0.9139,0.909,0.9198,0.9118),('2001-08-17 00:00:00',0.9109,0.9102,0.9179,0.9172),('2001-08-20 00:00:00',0.917,0.9108,0.9199,0.9144),('2001-08-21 00:00:00',0.9125,0.908,0.9181,0.9175),('2001-08-22 00:00:00',0.9175,0.9122,0.9238,0.9145),('2001-08-23 00:00:00',0.9133,0.9097,0.9165,0.9152),('2001-08-24 00:00:00',0.9141,0.9074,0.9165,0.9128),('2001-08-27 00:00:00',0.9131,0.9084,0.914,0.9113),('2001-08-28 00:00:00',0.9108,0.9027,0.9132,0.9121),('2001-08-29 00:00:00',0.9123,0.9081,0.9146,0.909),('2001-08-30 00:00:00',0.9069,0.9058,0.9182,0.916),('2001-08-31 00:00:00',0.9158,0.9066,0.9195,0.9119),('2001-09-03 00:00:00',0.9094,0.9056,0.9099,0.9069),('2001-09-04 00:00:00',0.9074,0.8848,0.9075,0.8885),('2001-09-05 00:00:00',0.888,0.8845,0.8909,0.8857),('2001-09-06 00:00:00',0.887,0.8824,0.8967,0.8954),('2001-09-07 00:00:00',0.8945,0.893,0.9067,0.906),('2001-09-10 00:00:00',0.9059,0.8971,0.9075,0.8977),('2001-09-11 00:00:00',0.898,0.8953,0.9167,0.9144),('2001-09-12 00:00:00',0.9089,0.9009,0.9148,0.9067),('2001-09-13 00:00:00',0.9065,0.9048,0.9121,0.9115),('2001-09-14 00:00:00',0.9115,0.9085,0.9245,0.9208),('2001-09-17 00:00:00',0.9231,0.9171,0.9329,0.9248),('2001-09-18 00:00:00',0.9237,0.9187,0.9281,0.9272),('2001-09-19 00:00:00',0.9269,0.9227,0.9323,0.926),('2001-09-20 00:00:00',0.9265,0.9226,0.9292,0.9276),('2001-09-21 00:00:00',0.9266,0.9092,0.9274,0.914),('2001-09-24 00:00:00',0.9135,0.9103,0.9197,0.9168),('2001-09-25 00:00:00',0.9164,0.9146,0.9246,0.9225),('2001-09-26 00:00:00',0.9227,0.9194,0.9241,0.9227),('2001-09-27 00:00:00',0.9226,0.9158,0.9232,0.9181),('2001-09-28 00:00:00',0.9182,0.908,0.9182,0.91),('2001-10-01 00:00:00',0.9105,0.9061,0.9175,0.9169),('2001-10-02 00:00:00',0.9166,0.9134,0.9194,0.9187),('2001-10-03 00:00:00',0.9176,0.9124,0.923,0.9144),('2001-10-04 00:00:00',0.9142,0.911,0.9183,0.918),('2001-10-05 00:00:00',0.9176,0.9154,0.9204,0.9175),('2001-10-08 00:00:00',0.9186,0.9165,0.9239,0.9209),('2001-10-09 00:00:00',0.9203,0.9123,0.9223,0.913),('2001-10-10 00:00:00',0.9133,0.9099,0.9155,0.9109),('2001-10-11 00:00:00',0.9105,0.8988,0.9121,0.9022),('2001-10-12 00:00:00',0.9024,0.9011,0.9115,0.9099),('2001-10-15 00:00:00',0.9118,0.9062,0.9134,0.9083),('2001-10-16 00:00:00',0.9078,0.9037,0.9109,0.9082),('2001-10-17 00:00:00',0.9076,0.901,0.9088,0.9036),('2001-10-18 00:00:00',0.9022,0.8999,0.9054,0.903),('2001-10-19 00:00:00',0.903,0.8964,0.9032,0.8988),('2001-10-22 00:00:00',0.8985,0.8894,0.8999,0.8909),('2001-10-23 00:00:00',0.8911,0.8867,0.8925,0.89),('2001-10-24 00:00:00',0.8902,0.8897,0.8941,0.8937),('2001-10-25 00:00:00',0.8933,0.8879,0.8976,0.8924),('2001-10-26 00:00:00',0.8921,0.8903,0.8948,0.8917),('2001-10-29 00:00:00',0.8927,0.8921,0.9056,0.905),('2001-10-30 00:00:00',0.905,0.9034,0.9098,0.9045),('2001-10-31 00:00:00',0.9045,0.8986,0.9074,0.9002),('2001-11-01 00:00:00',0.8996,0.8993,0.9116,0.9019),('2001-11-02 00:00:00',0.9021,0.9006,0.9067,0.9022),('2001-11-05 00:00:00',0.9011,0.8943,0.9017,0.8973),('2001-11-06 00:00:00',0.8972,0.8941,0.8992,0.8942),('2001-11-07 00:00:00',0.894,0.8938,0.9048,0.8973),('2001-11-08 00:00:00',0.8977,0.8905,0.8992,0.8923),('2001-11-09 00:00:00',0.8926,0.8891,0.8944,0.8936),('2001-11-12 00:00:00',0.8943,0.8912,0.9012,0.8935),('2001-11-13 00:00:00',0.8934,0.8789,0.8937,0.881),('2001-11-14 00:00:00',0.8809,0.8771,0.8838,0.8821),('2001-11-15 00:00:00',0.8823,0.8803,0.885,0.8815),('2001-11-16 00:00:00',0.8815,0.8809,0.8861,0.8841),('2001-11-19 00:00:00',0.884,0.8766,0.885,0.8785),('2001-11-20 00:00:00',0.8783,0.8779,0.8842,0.8829),('2001-11-21 00:00:00',0.8831,0.8754,0.8833,0.878),('2001-11-22 00:00:00',0.8774,0.8762,0.8792,0.8776),('2001-11-23 00:00:00',0.8782,0.8736,0.8809,0.8775),('2001-11-26 00:00:00',0.878,0.8779,0.8828,0.8802),('2001-11-27 00:00:00',0.8805,0.877,0.8834,0.8832),('2001-11-28 00:00:00',0.883,0.8817,0.8882,0.8876),('2001-11-29 00:00:00',0.8872,0.8857,0.8914,0.887),('2001-11-30 00:00:00',0.8868,0.8848,0.8977,0.8955),('2001-12-03 00:00:00',0.8952,0.889,0.8966,0.8911),('2001-12-04 00:00:00',0.8907,0.8885,0.892,0.89),('2001-12-05 00:00:00',0.8902,0.8846,0.8937,0.8884),('2001-12-06 00:00:00',0.8881,0.8863,0.895,0.8945),('2001-12-07 00:00:00',0.894,0.8885,0.8944,0.8893),('2001-12-10 00:00:00',0.8895,0.8842,0.8914,0.8905),('2001-12-11 00:00:00',0.8906,0.8883,0.893,0.8927),('2001-12-12 00:00:00',0.8924,0.8921,0.8985,0.898),('2001-12-13 00:00:00',0.8973,0.892,0.899,0.8933),('2001-12-14 00:00:00',0.8927,0.8921,0.9049,0.9037),('2001-12-17 00:00:00',0.9035,0.9015,0.9076,0.9021),('2001-12-18 00:00:00',0.9018,0.8995,0.9037,0.9033),('2001-12-19 00:00:00',0.9022,0.8953,0.9028,0.9007),('2001-12-20 00:00:00',0.8997,0.8962,0.9007,0.8999),('2001-12-21 00:00:00',0.8986,0.8855,0.9011,0.887),('2001-12-24 00:00:00',0.8887,0.874,0.8905,0.8772),('2001-12-27 00:00:00',0.88,0.8773,0.8867,0.8827),('2001-12-28 00:00:00',0.8834,0.8789,0.8839,0.8837),('2002-01-02 00:00:00',0.8892,0.888,0.9061,0.9035),('2002-01-03 00:00:00',0.9032,0.8976,0.9055,0.8988),('2002-01-04 00:00:00',0.8993,0.8939,0.8998,0.8949),('2002-01-07 00:00:00',0.8955,0.8881,0.8993,0.8934),('2002-01-08 00:00:00',0.8923,0.8884,0.8932,0.8929),('2002-01-09 00:00:00',0.8932,0.8865,0.8947,0.8907),('2002-01-10 00:00:00',0.8913,0.8901,0.8934,0.8915),('2002-01-11 00:00:00',0.8916,0.8897,0.8927,0.8921),('2002-01-14 00:00:00',0.894,0.8914,0.895,0.8938),('2002-01-15 00:00:00',0.894,0.8821,0.8941,0.8827),('2002-01-16 00:00:00',0.8838,0.8802,0.8843,0.8826),('2002-01-17 00:00:00',0.8844,0.8792,0.8847,0.8807),('2002-01-18 00:00:00',0.8812,0.8795,0.8846,0.8838),('2002-01-21 00:00:00',0.8848,0.8827,0.8862,0.8835),('2002-01-22 00:00:00',0.8832,0.8812,0.887,0.8862),('2002-01-23 00:00:00',0.8875,0.8768,0.8887,0.8782),('2002-01-24 00:00:00',0.8782,0.8753,0.8788,0.8777),('2002-01-25 00:00:00',0.8774,0.8632,0.8783,0.8649),('2002-01-27 00:00:00',0.8644,0.8643,0.865,0.8649),('2002-01-28 00:00:00',0.8642,0.8573,0.8661,0.8617),('2002-01-29 00:00:00',0.8607,0.8593,0.8655,0.8651),('2002-01-30 00:00:00',0.8649,0.8599,0.8669,0.8611),('2002-01-31 00:00:00',0.8615,0.8577,0.8642,0.8592),('2002-02-01 00:00:00',0.8589,0.8563,0.8638,0.8614),('2002-02-04 00:00:00',0.8616,0.8605,0.8705,0.8696),('2002-02-05 00:00:00',0.8698,0.865,0.8726,0.867),('2002-02-06 00:00:00',0.8676,0.8632,0.8704,0.8674),('2002-02-07 00:00:00',0.867,0.8644,0.8711,0.8699),('2002-02-08 00:00:00',0.8696,0.8696,0.8749,0.8727),('2002-02-11 00:00:00',0.8706,0.8702,0.8797,0.8763),('2002-02-12 00:00:00',0.8767,0.8736,0.8795,0.8765),('2002-02-13 00:00:00',0.8763,0.8706,0.8767,0.8713),('2002-02-14 00:00:00',0.8711,0.8681,0.8744,0.8739),('2002-02-15 00:00:00',0.8736,0.8694,0.8739,0.8728),('2002-02-18 00:00:00',0.8729,0.87,0.8737,0.8705),('2002-02-19 00:00:00',0.8703,0.8665,0.8778,0.8763),('2002-02-20 00:00:00',0.8763,0.8689,0.8779,0.8696),('2002-02-21 00:00:00',0.8698,0.868,0.8716,0.8702),('2002-02-22 00:00:00',0.8698,0.8679,0.8772,0.8752),('2002-02-25 00:00:00',0.8749,0.8687,0.8755,0.8692),('2002-02-26 00:00:00',0.8695,0.8614,0.8716,0.8637),('2002-02-27 00:00:00',0.8633,0.8626,0.8664,0.8652),('2002-02-28 00:00:00',0.8658,0.8629,0.8694,0.869),('2002-03-01 00:00:00',0.8685,0.8631,0.8691,0.8646),('2002-03-04 00:00:00',0.8651,0.8632,0.8711,0.8689),('2002-03-05 00:00:00',0.8695,0.865,0.8724,0.8713),('2002-03-06 00:00:00',0.8713,0.8694,0.8772,0.8761),('2002-03-07 00:00:00',0.8765,0.8741,0.8836,0.8813),('2002-03-08 00:00:00',0.881,0.872,0.8814,0.8739),('2002-03-11 00:00:00',0.8734,0.873,0.877,0.8752),('2002-03-12 00:00:00',0.8755,0.8704,0.876,0.8755),('2002-03-13 00:00:00',0.8749,0.8725,0.878,0.8755),('2002-03-14 00:00:00',0.8753,0.8752,0.8841,0.8822),('2002-03-15 00:00:00',0.8819,0.8808,0.8868,0.8821),('2002-03-18 00:00:00',0.8812,0.878,0.8828,0.8824),('2002-03-19 00:00:00',0.8819,0.8796,0.884,0.8816),('2002-03-20 00:00:00',0.8809,0.8786,0.8857,0.8851),('2002-03-21 00:00:00',0.8855,0.8806,0.8857,0.8822),('2002-03-22 00:00:00',0.8822,0.8749,0.8824,0.8768),('2002-03-25 00:00:00',0.8765,0.8753,0.8777,0.8773),('2002-03-26 00:00:00',0.8765,0.8732,0.8792,0.8765),('2002-03-27 00:00:00',0.8761,0.8718,0.8767,0.8722),('2002-03-28 00:00:00',0.8722,0.87,0.8739,0.8709),('2002-03-29 00:00:00',0.8712,0.8706,0.8726,0.8715),('2002-04-01 00:00:00',0.8712,0.871,0.8818,0.8804),('2002-04-02 00:00:00',0.8801,0.8772,0.8813,0.8791),('2002-04-03 00:00:00',0.8794,0.8774,0.8827,0.8807),('2002-04-04 00:00:00',0.8808,0.8765,0.8853,0.8775),('2002-04-05 00:00:00',0.8776,0.8772,0.8811,0.8794),('2002-04-08 00:00:00',0.8788,0.8736,0.879,0.8746),('2002-04-09 00:00:00',0.8744,0.8735,0.8811,0.8808),('2002-04-10 00:00:00',0.8802,0.8788,0.8821,0.8799),('2002-04-11 00:00:00',0.8804,0.8788,0.8842,0.8821),('2002-04-12 00:00:00',0.8819,0.8774,0.8823,0.8799),('2002-04-15 00:00:00',0.8791,0.8788,0.8819,0.8793),('2002-04-16 00:00:00',0.8793,0.879,0.8834,0.8825),('2002-04-17 00:00:00',0.882,0.8815,0.8905,0.89),('2002-04-18 00:00:00',0.8899,0.8856,0.8917,0.8907),('2002-04-19 00:00:00',0.8905,0.8877,0.892,0.8914),('2002-04-22 00:00:00',0.8893,0.8867,0.8905,0.889),('2002-04-23 00:00:00',0.8891,0.8861,0.8898,0.8884),('2002-04-24 00:00:00',0.8883,0.8872,0.8927,0.8921),('2002-04-25 00:00:00',0.8921,0.8914,0.8989,0.8975),('2002-04-26 00:00:00',0.8974,0.8959,0.9014,0.9012),('2002-04-29 00:00:00',0.9009,0.9006,0.9041,0.9038),('2002-04-30 00:00:00',0.9025,0.899,0.9038,0.9002),('2002-05-01 00:00:00',0.9,0.8994,0.9081,0.9059),('2002-05-02 00:00:00',0.9064,0.9011,0.9074,0.9031),('2002-05-03 00:00:00',0.9029,0.9024,0.917,0.9166),('2002-05-06 00:00:00',0.916,0.9134,0.9182,0.9178),('2002-05-07 00:00:00',0.9176,0.9114,0.9186,0.9147),('2002-05-08 00:00:00',0.9132,0.9035,0.9142,0.9041),('2002-05-09 00:00:00',0.9046,0.9038,0.9109,0.9093),('2002-05-10 00:00:00',0.9088,0.9084,0.9145,0.9135),('2002-05-13 00:00:00',0.9124,0.9095,0.9163,0.912),('2002-05-14 00:00:00',0.9115,0.901,0.9117,0.9025),('2002-05-15 00:00:00',0.9024,0.8994,0.9123,0.9119),('2002-05-16 00:00:00',0.9115,0.9085,0.9137,0.9111),('2002-05-17 00:00:00',0.9117,0.9112,0.9216,0.9207),('2002-05-20 00:00:00',0.9203,0.9179,0.9226,0.9209),('2002-05-21 00:00:00',0.9207,0.9161,0.9217,0.9197),('2002-05-22 00:00:00',0.9183,0.9182,0.9273,0.9255),('2002-05-23 00:00:00',0.9253,0.918,0.9265,0.9209),('2002-05-24 00:00:00',0.921,0.9164,0.9227,0.921),('2002-05-27 00:00:00',0.9205,0.9182,0.9219,0.9203),('2002-05-28 00:00:00',0.9205,0.9197,0.9302,0.9282),('2002-05-29 00:00:00',0.9284,0.927,0.9365,0.935),('2002-05-30 00:00:00',0.9352,0.9349,0.9409,0.9371),('2002-05-31 00:00:00',0.9364,0.9283,0.9398,0.932),('2002-06-03 00:00:00',0.9324,0.9303,0.9419,0.941),('2002-06-04 00:00:00',0.9405,0.939,0.9449,0.9393),('2002-06-05 00:00:00',0.9391,0.9352,0.9414,0.9386),('2002-06-06 00:00:00',0.9392,0.9337,0.9476,0.9472),('2002-06-07 00:00:00',0.9468,0.9428,0.9484,0.9438),('2002-06-10 00:00:00',0.943,0.9389,0.9476,0.9441),('2002-06-11 00:00:00',0.9434,0.9404,0.9488,0.9483),('2002-06-12 00:00:00',0.9482,0.9428,0.9502,0.943),('2002-06-13 00:00:00',0.9432,0.9394,0.947,0.9432),('2002-06-14 00:00:00',0.943,0.9414,0.9519,0.9455),('2002-06-17 00:00:00',0.9447,0.9411,0.9466,0.9441),('2002-06-18 00:00:00',0.9443,0.9433,0.9523,0.9516),('2002-06-19 00:00:00',0.9518,0.9515,0.9576,0.9572),('2002-06-20 00:00:00',0.9569,0.9555,0.9663,0.9642),('2002-06-21 00:00:00',0.9639,0.963,0.9714,0.9705),('2002-06-24 00:00:00',0.9696,0.9682,0.9812,0.9698),('2002-06-25 00:00:00',0.9701,0.9661,0.9796,0.979),('2002-06-26 00:00:00',0.9805,0.9789,0.9942,0.9816),('2002-06-27 00:00:00',0.9832,0.9808,0.9896,0.9879),('2002-06-28 00:00:00',0.9884,0.9837,0.9987,0.9915),('2002-07-01 00:00:00',0.9911,0.9862,0.9969,0.9915),('2002-07-02 00:00:00',0.9913,0.9799,0.9916,0.986),('2002-07-03 00:00:00',0.9844,0.9768,0.9861,0.98),('2002-07-04 00:00:00',0.9801,0.9746,0.9815,0.9785),('2002-07-05 00:00:00',0.9774,0.9714,0.9783,0.9729),('2002-07-08 00:00:00',0.9742,0.974,0.9911,0.99),('2002-07-09 00:00:00',0.9901,0.9872,0.9949,0.9931),('2002-07-10 00:00:00',0.9919,0.9857,0.9965,0.989),('2002-07-11 00:00:00',0.9892,0.9834,0.9936,0.9879),('2002-07-12 00:00:00',0.9869,0.985,0.992,0.9903),('2002-07-15 00:00:00',0.9917,0.9912,1.0085,1.0025),('2002-07-16 00:00:00',1.0034,1.0033,1.0144,1.0111),('2002-07-17 00:00:00',1.0116,1.0032,1.0156,1.0071),('2002-07-18 00:00:00',1.0076,1.0041,1.0116,1.0113),('2002-07-19 00:00:00',1.0112,1.0101,1.0199,1.0133),('2002-07-22 00:00:00',1.0093,1.0055,1.0131,1.0076),('2002-07-23 00:00:00',1.0061,0.9844,1.0075,0.9887),('2002-07-24 00:00:00',0.9911,0.9873,0.9978,0.9948),('2002-07-25 00:00:00',0.9944,0.9937,1.0058,1.0036),('2002-07-26 00:00:00',1.0028,0.9859,1.0064,0.9879),('2002-07-29 00:00:00',0.9874,0.977,0.9886,0.9811),('2002-07-30 00:00:00',0.9811,0.9778,0.9888,0.983),('2002-07-31 00:00:00',0.9833,0.9758,0.9851,0.9774),('2002-08-01 00:00:00',0.977,0.9725,0.9853,0.9842),('2002-08-02 00:00:00',0.9837,0.9833,0.9914,0.9876),('2002-08-05 00:00:00',0.9862,0.9798,0.9872,0.9799),('2002-08-06 00:00:00',0.9802,0.9622,0.9805,0.9657),('2002-08-07 00:00:00',0.965,0.964,0.976,0.9744),('2002-08-08 00:00:00',0.9733,0.964,0.9769,0.9667),('2002-08-09 00:00:00',0.9658,0.9653,0.9736,0.9703),('2002-08-12 00:00:00',0.9698,0.9689,0.9797,0.9786),('2002-08-13 00:00:00',0.978,0.9752,0.9844,0.984),('2002-08-14 00:00:00',0.9844,0.9761,0.9889,0.9766),('2002-08-15 00:00:00',0.9772,0.9746,0.9845,0.9814),('2002-08-16 00:00:00',0.9812,0.9782,0.9862,0.9832),('2002-08-19 00:00:00',0.9843,0.9749,0.9868,0.976),('2002-08-20 00:00:00',0.9771,0.9729,0.9805,0.9784),('2002-08-21 00:00:00',0.9787,0.9752,0.9844,0.9806),('2002-08-22 00:00:00',0.98,0.9674,0.9804,0.9688),('2002-08-23 00:00:00',0.9698,0.9662,0.9729,0.9719),('2002-08-26 00:00:00',0.9722,0.9683,0.9736,0.9711),('2002-08-27 00:00:00',0.971,0.9703,0.9836,0.9827),('2002-08-28 00:00:00',0.9832,0.9779,0.9833,0.9784),('2002-08-29 00:00:00',0.9783,0.9776,0.9883,0.9839),('2002-08-30 00:00:00',0.983,0.9795,0.9861,0.9824),('2002-09-02 00:00:00',0.9819,0.9796,0.9851,0.9841),('2002-09-03 00:00:00',0.9843,0.983,0.9971,0.9969),('2002-09-04 00:00:00',0.9956,0.9904,0.9969,0.992),('2002-09-05 00:00:00',0.9925,0.9887,0.9986,0.9921),('2002-09-06 00:00:00',0.9903,0.9804,0.995,0.9808),('2002-09-09 00:00:00',0.9811,0.978,0.9826,0.9793),('2002-09-10 00:00:00',0.9798,0.9722,0.9834,0.9746),('2002-09-11 00:00:00',0.9752,0.9701,0.9766,0.9757),('2002-09-12 00:00:00',0.9755,0.9739,0.982,0.9816),('2002-09-13 00:00:00',0.9814,0.9702,0.9836,0.9722),('2002-09-16 00:00:00',0.9716,0.9663,0.9725,0.9687),('2002-09-17 00:00:00',0.9674,0.9606,0.9747,0.974),('2002-09-18 00:00:00',0.9739,0.9685,0.9792,0.9778),('2002-09-19 00:00:00',0.977,0.9762,0.9873,0.9867),('2002-09-20 00:00:00',0.9869,0.9781,0.9873,0.9815),('2002-09-23 00:00:00',0.9805,0.975,0.9855,0.9779),('2002-09-24 00:00:00',0.9769,0.9757,0.9833,0.9818),('2002-09-25 00:00:00',0.9823,0.9755,0.9849,0.9761),('2002-09-26 00:00:00',0.9763,0.9728,0.9805,0.977),('2002-09-27 00:00:00',0.9772,0.9746,0.9806,0.9801),('2002-09-30 00:00:00',0.9806,0.9805,0.9896,0.9867),('2002-10-01 00:00:00',0.9864,0.9819,0.9891,0.9823),('2002-10-02 00:00:00',0.9823,0.9807,0.9868,0.9864),('2002-10-03 00:00:00',0.986,0.9855,0.9908,0.9871),('2002-10-04 00:00:00',0.9876,0.978,0.9879,0.9797),('2002-10-07 00:00:00',0.9791,0.9777,0.9834,0.9827),('2002-10-08 00:00:00',0.9825,0.9763,0.984,0.9787),('2002-10-09 00:00:00',0.9788,0.9777,0.991,0.9898),('2002-10-10 00:00:00',0.99,0.9846,0.9924,0.9858),('2002-10-11 00:00:00',0.9857,0.9833,0.9876,0.987),('2002-10-14 00:00:00',0.9876,0.9853,0.9888,0.9872),('2002-10-15 00:00:00',0.9866,0.979,0.9883,0.9814),('2002-10-16 00:00:00',0.9817,0.98,0.9833,0.9807),('2002-10-17 00:00:00',0.9804,0.9696,0.9806,0.9708),('2002-10-18 00:00:00',0.9704,0.9697,0.974,0.9714),('2002-10-21 00:00:00',0.9718,0.9686,0.976,0.9732),('2002-10-22 00:00:00',0.9733,0.9719,0.9799,0.9772),('2002-10-23 00:00:00',0.9769,0.9746,0.9794,0.9753),('2002-10-24 00:00:00',0.975,0.9723,0.9781,0.9776),('2002-10-25 00:00:00',0.9767,0.9756,0.9791,0.9765),('2002-10-28 00:00:00',0.9762,0.9726,0.9844,0.9844),('2002-10-29 00:00:00',0.9842,0.9806,0.9863,0.9823),('2002-10-30 00:00:00',0.9826,0.9814,0.9849,0.9837),('2002-10-31 00:00:00',0.9841,0.9835,0.9906,0.99),('2002-11-01 00:00:00',0.9905,0.9887,1,0.9964),('2002-11-04 00:00:00',0.9968,0.9931,0.9983,0.9976),('2002-11-05 00:00:00',0.9973,0.997,1.0039,0.9995),('2002-11-06 00:00:00',0.9987,0.9939,1.0045,1.0035),('2002-11-07 00:00:00',1.0053,0.9989,1.0095,1.0089),('2002-11-08 00:00:00',1.0079,1.0072,1.0144,1.0132),('2002-11-11 00:00:00',1.0126,1.0092,1.0168,1.0105),('2002-11-12 00:00:00',1.0094,1.0067,1.0132,1.0122),('2002-11-13 00:00:00',1.0122,1.0044,1.0124,1.0079),('2002-11-14 00:00:00',1.008,1.0029,1.0098,1.0036),('2002-11-15 00:00:00',1.0038,1.0011,1.0093,1.0086),('2002-11-18 00:00:00',1.0099,1.006,1.0117,1.0089),('2002-11-19 00:00:00',1.0091,1.0007,1.0139,1.0036),('2002-11-20 00:00:00',1.0031,0.9989,1.0042,1.0008),('2002-11-21 00:00:00',1.0009,0.9978,1.0039,1.0018),('2002-11-22 00:00:00',1.0022,0.9959,1.0031,0.997),('2002-11-25 00:00:00',0.9963,0.9891,0.9966,0.992),('2002-11-26 00:00:00',0.9913,0.9894,0.9935,0.9933),('2002-11-27 00:00:00',0.9935,0.9876,0.9938,0.99),('2002-11-28 00:00:00',0.9901,0.9891,0.9957,0.9936),('2002-11-29 00:00:00',0.9935,0.9918,0.9952,0.994),('2002-12-02 00:00:00',0.9941,0.9859,0.998,0.9968),('2002-12-03 00:00:00',0.9962,0.9949,0.9999,0.9971),('2002-12-04 00:00:00',0.9966,0.9962,1.0028,1.0007),('2002-12-05 00:00:00',1.0012,0.997,1.0023,1),('2002-12-06 00:00:00',1.0002,0.9999,1.0122,1.0089),('2002-12-09 00:00:00',1.0098,1.0067,1.0115,1.0109),('2002-12-10 00:00:00',1.0108,1.007,1.0137,1.0077),('2002-12-11 00:00:00',1.0075,1.0059,1.0098,1.0085),('2002-12-12 00:00:00',1.0079,1.0073,1.0193,1.0182),('2002-12-13 00:00:00',1.0181,1.0171,1.0256,1.0226),('2002-12-16 00:00:00',1.0232,1.0192,1.0246,1.0224),('2002-12-17 00:00:00',1.0217,1.0208,1.0332,1.0267),('2002-12-18 00:00:00',1.0265,1.0225,1.0284,1.0275),('2002-12-19 00:00:00',1.0282,1.0206,1.0286,1.0272),('2002-12-20 00:00:00',1.026,1.024,1.0273,1.0264),('2002-12-23 00:00:00',1.0265,1.0216,1.0314,1.0263),('2002-12-24 00:00:00',1.026,1.0253,1.0323,1.0299),('2002-12-26 00:00:00',1.032,1.0316,1.0375,1.0371),('2002-12-27 00:00:00',1.0369,1.0358,1.044,1.0433),('2002-12-30 00:00:00',1.0419,1.0409,1.049,1.0481),('2002-12-31 00:00:00',1.0471,1.0455,1.0501,1.0496),('2003-01-02 00:00:00',1.0475,1.0334,1.0493,1.0353),('2003-01-03 00:00:00',1.0358,1.034,1.0433,1.0418),('2003-01-06 00:00:00',1.0419,1.0415,1.0491,1.0451),('2003-01-07 00:00:00',1.0445,1.0396,1.0451,1.0407),('2003-01-08 00:00:00',1.0416,1.0361,1.0531,1.0496),('2003-01-09 00:00:00',1.0493,1.046,1.0537,1.0484),('2003-01-10 00:00:00',1.0485,1.0472,1.0583,1.0572),('2003-01-13 00:00:00',1.0576,1.0525,1.0582,1.0538),('2003-01-14 00:00:00',1.0539,1.0534,1.0594,1.0549),('2003-01-15 00:00:00',1.0553,1.0504,1.0588,1.0562),('2003-01-16 00:00:00',1.0556,1.0544,1.0625,1.0615),('2003-01-17 00:00:00',1.0614,1.0604,1.0676,1.0662),('2003-01-20 00:00:00',1.0655,1.0632,1.0686,1.0683),('2003-01-21 00:00:00',1.0682,1.0632,1.073,1.0717),('2003-01-22 00:00:00',1.0724,1.0684,1.0736,1.0732),('2003-01-23 00:00:00',1.0718,1.0704,1.0774,1.0744),('2003-01-24 00:00:00',1.0745,1.074,1.0846,1.0841),('2003-01-27 00:00:00',1.0835,1.078,1.0905,1.0848),('2003-01-28 00:00:00',1.084,1.078,1.0845,1.0822),('2003-01-29 00:00:00',1.0818,1.0808,1.0897,1.0835),('2003-01-30 00:00:00',1.0818,1.0732,1.0834,1.0822),('2003-01-31 00:00:00',1.0815,1.0723,1.0831,1.0761),('2003-02-03 00:00:00',1.0784,1.0691,1.0798,1.0785),('2003-02-04 00:00:00',1.0786,1.0767,1.0905,1.0879),('2003-02-05 00:00:00',1.0888,1.0737,1.0934,1.0784),('2003-02-06 00:00:00',1.0788,1.0764,1.0862,1.0829),('2003-02-07 00:00:00',1.083,1.0732,1.0834,1.0825),('2003-02-10 00:00:00',1.081,1.0706,1.0825,1.0714),('2003-02-11 00:00:00',1.0712,1.0665,1.0758,1.0733),('2003-02-12 00:00:00',1.0741,1.0702,1.0767,1.0711),('2003-02-13 00:00:00',1.0705,1.0703,1.0855,1.0827),('2003-02-14 00:00:00',1.0835,1.0762,1.0848,1.0792),('2003-02-17 00:00:00',1.0766,1.0676,1.0773,1.072),('2003-02-18 00:00:00',1.0726,1.0677,1.0754,1.0687),('2003-02-19 00:00:00',1.068,1.0665,1.0762,1.0745),('2003-02-20 00:00:00',1.0741,1.0741,1.0831,1.0818),('2003-02-21 00:00:00',1.0823,1.0749,1.0843,1.0761),('2003-02-24 00:00:00',1.0721,1.0707,1.0803,1.0794),('2003-02-25 00:00:00',1.0792,1.0741,1.0818,1.0756),('2003-02-26 00:00:00',1.0742,1.0729,1.0808,1.0784),('2003-02-27 00:00:00',1.0785,1.0734,1.0834,1.0739),('2003-02-28 00:00:00',1.0743,1.0734,1.0805,1.0795),('2003-03-03 00:00:00',1.0779,1.0767,1.0897,1.0888),('2003-03-04 00:00:00',1.0892,1.0874,1.0963,1.0919),('2003-03-05 00:00:00',1.0979,1.0945,1.0997,1.0967),('2003-03-06 00:00:00',1.0962,1.0929,1.1006,1.0968),('2003-03-07 00:00:00',1.0972,1.0964,1.1064,1.101),('2003-03-10 00:00:00',1.1007,1.1003,1.1064,1.1053),('2003-03-11 00:00:00',1.1049,1.1004,1.1081,1.1046),('2003-03-12 00:00:00',1.1033,1.0981,1.1055,1.099),('2003-03-13 00:00:00',1.0987,1.0767,1.0991,1.0776),('2003-03-14 00:00:00',1.0786,1.0688,1.0819,1.0742),('2003-03-17 00:00:00',1.0788,1.0589,1.0841,1.0627),('2003-03-18 00:00:00',1.0625,1.0541,1.065,1.0636),('2003-03-19 00:00:00',1.0641,1.0552,1.0651,1.0562),('2003-03-20 00:00:00',1.0582,1.053,1.0669,1.0612),('2003-03-21 00:00:00',1.0602,1.0501,1.0616,1.0535),('2003-03-24 00:00:00',1.0584,1.0565,1.0671,1.0641),('2003-03-25 00:00:00',1.0651,1.0632,1.0718,1.0656),('2003-03-26 00:00:00',1.066,1.062,1.0701,1.0696),('2003-03-27 00:00:00',1.0694,1.0674,1.074,1.0686),('2003-03-28 00:00:00',1.0687,1.0668,1.0798,1.0775),('2003-03-31 00:00:00',1.0796,1.0779,1.0929,1.0925),('2003-04-01 00:00:00',1.0911,1.0864,1.092,1.0909),('2003-04-02 00:00:00',1.0926,1.0748,1.0957,1.0769),('2003-04-03 00:00:00',1.0764,1.0685,1.0789,1.0759),('2003-04-04 00:00:00',1.0756,1.0683,1.0765,1.0725),('2003-04-07 00:00:00',1.0667,1.0559,1.07,1.0691),('2003-04-08 00:00:00',1.0681,1.0641,1.072,1.0708),('2003-04-09 00:00:00',1.0711,1.0674,1.078,1.0772),('2003-04-10 00:00:00',1.0768,1.0759,1.0827,1.078),('2003-04-11 00:00:00',1.0782,1.0692,1.0786,1.0753),('2003-04-14 00:00:00',1.0735,1.0716,1.0807,1.0769),('2003-04-15 00:00:00',1.0774,1.0734,1.0818,1.0814),('2003-04-16 00:00:00',1.0802,1.0783,1.0917,1.091),('2003-04-17 00:00:00',1.0913,1.0864,1.0974,1.0877),('2003-04-18 00:00:00',1.0876,1.0872,1.0894,1.0879),('2003-04-21 00:00:00',1.0888,1.0822,1.0905,1.086),('2003-04-22 00:00:00',1.0856,1.0847,1.1001,1.0968),('2003-04-23 00:00:00',1.0959,1.092,1.098,1.0962),('2003-04-24 00:00:00',1.0951,1.0943,1.1044,1.103),('2003-04-25 00:00:00',1.1033,1.0961,1.1048,1.1022),('2003-04-28 00:00:00',1.1029,1.0975,1.1075,1.0985),('2003-04-29 00:00:00',1.098,1.0932,1.1082,1.1074),('2003-04-30 00:00:00',1.1065,1.1062,1.1185,1.1181),('2003-05-01 00:00:00',1.1183,1.1152,1.1283,1.1229),('2003-05-02 00:00:00',1.1237,1.1187,1.1269,1.123),('2003-05-05 00:00:00',1.1224,1.1203,1.1301,1.1286),('2003-05-06 00:00:00',1.129,1.1275,1.1452,1.1433),('2003-05-07 00:00:00',1.1427,1.1328,1.1435,1.1359),('2003-05-08 00:00:00',1.1344,1.1308,1.1504,1.1492),('2003-05-09 00:00:00',1.1483,1.1437,1.1534,1.1489),('2003-05-12 00:00:00',1.1563,1.1524,1.1619,1.1564),('2003-05-13 00:00:00',1.1559,1.1461,1.1564,1.1522),('2003-05-14 00:00:00',1.1524,1.1467,1.1535,1.1479),('2003-05-15 00:00:00',1.1471,1.137,1.1487,1.1377),('2003-05-16 00:00:00',1.1389,1.137,1.1577,1.1574),('2003-05-19 00:00:00',1.1656,1.1621,1.1737,1.1653),('2003-05-20 00:00:00',1.1643,1.1604,1.1714,1.1704),('2003-05-21 00:00:00',1.1731,1.1626,1.1741,1.1631),('2003-05-22 00:00:00',1.164,1.1619,1.1726,1.1691),('2003-05-23 00:00:00',1.1698,1.1666,1.1834,1.1826),('2003-05-26 00:00:00',1.1817,1.1798,1.1874,1.1871),('2003-05-27 00:00:00',1.1857,1.181,1.1932,1.1812),('2003-05-28 00:00:00',1.1813,1.1707,1.1844,1.1762),('2003-05-29 00:00:00',1.1751,1.1691,1.1911,1.1897),('2003-05-30 00:00:00',1.1908,1.1742,1.1912,1.1768),('2003-06-02 00:00:00',1.1712,1.1651,1.1765,1.1761),('2003-06-03 00:00:00',1.1765,1.1686,1.1777,1.1726),('2003-06-04 00:00:00',1.1732,1.1633,1.1745,1.1641),('2003-06-05 00:00:00',1.1638,1.1631,1.1886,1.1845),('2003-06-06 00:00:00',1.1841,1.1683,1.1877,1.1698),('2003-06-09 00:00:00',1.1697,1.1655,1.1786,1.1712),('2003-06-10 00:00:00',1.1715,1.1667,1.1739,1.167),('2003-06-11 00:00:00',1.1675,1.1658,1.178,1.1748),('2003-06-12 00:00:00',1.1758,1.1705,1.1804,1.1767),('2003-06-13 00:00:00',1.1767,1.1736,1.1875,1.1865),('2003-06-16 00:00:00',1.1872,1.1818,1.1928,1.1826),('2003-06-17 00:00:00',1.1817,1.1767,1.1865,1.1784),('2003-06-18 00:00:00',1.1781,1.1664,1.18,1.169),('2003-06-19 00:00:00',1.168,1.1582,1.1738,1.1718),('2003-06-20 00:00:00',1.1716,1.155,1.1731,1.1588),('2003-06-23 00:00:00',1.1575,1.1507,1.1603,1.1557),('2003-06-24 00:00:00',1.1549,1.1475,1.158,1.1511),('2003-06-25 00:00:00',1.1503,1.1491,1.1621,1.1534),('2003-06-26 00:00:00',1.1536,1.1415,1.1543,1.1417),('2003-06-27 00:00:00',1.1418,1.1398,1.1466,1.142),('2003-06-30 00:00:00',1.1426,1.14,1.1532,1.1509),('2003-07-01 00:00:00',1.1522,1.1507,1.1607,1.1563),('2003-07-02 00:00:00',1.1563,1.1505,1.1567,1.1536),('2003-07-03 00:00:00',1.1527,1.1433,1.1538,1.1499),('2003-07-04 00:00:00',1.149,1.1447,1.1495,1.1488),('2003-07-07 00:00:00',1.1471,1.1309,1.1479,1.131),('2003-07-08 00:00:00',1.1312,1.1257,1.135,1.1319),('2003-07-09 00:00:00',1.1312,1.1305,1.1364,1.1347),('2003-07-10 00:00:00',1.1345,1.1309,1.1391,1.1379),('2003-07-11 00:00:00',1.1358,1.1275,1.1377,1.131),('2003-07-14 00:00:00',1.1282,1.1241,1.1306,1.128),('2003-07-15 00:00:00',1.1277,1.1154,1.1335,1.1173),('2003-07-16 00:00:00',1.1179,1.1111,1.1231,1.1217),('2003-07-17 00:00:00',1.1219,1.1155,1.1249,1.1213),('2003-07-18 00:00:00',1.1237,1.1172,1.1303,1.129),('2003-07-21 00:00:00',1.1247,1.1241,1.1355,1.1339),('2003-07-22 00:00:00',1.1341,1.1307,1.1371,1.1327),('2003-07-23 00:00:00',1.1325,1.1315,1.1489,1.1482),('2003-07-24 00:00:00',1.1476,1.1422,1.1508,1.1475),('2003-07-25 00:00:00',1.1469,1.1444,1.1547,1.1512),('2003-07-28 00:00:00',1.1499,1.1452,1.1516,1.149),('2003-07-29 00:00:00',1.1485,1.1431,1.1537,1.1437),('2003-07-30 00:00:00',1.1437,1.1334,1.145,1.1359),('2003-07-31 00:00:00',1.1348,1.1224,1.136,1.1231),('2003-08-01 00:00:00',1.1233,1.1135,1.1271,1.126),('2003-08-04 00:00:00',1.1274,1.1259,1.1373,1.1357),('2003-08-05 00:00:00',1.1349,1.1306,1.1396,1.1394),('2003-08-06 00:00:00',1.139,1.1325,1.1424,1.1337),('2003-08-07 00:00:00',1.1334,1.1319,1.1414,1.1375),('2003-08-08 00:00:00',1.1374,1.1287,1.138,1.1298),('2003-08-11 00:00:00',1.1301,1.1264,1.1378,1.1362),('2003-08-12 00:00:00',1.1356,1.1271,1.137,1.1274),('2003-08-13 00:00:00',1.1272,1.122,1.1329,1.1319),('2003-08-14 00:00:00',1.131,1.1224,1.1336,1.1271),('2003-08-15 00:00:00',1.1266,1.124,1.1286,1.1252),('2003-08-18 00:00:00',1.1266,1.1124,1.1266,1.1147),('2003-08-19 00:00:00',1.1146,1.1054,1.1149,1.1143),('2003-08-20 00:00:00',1.1143,1.108,1.1145,1.1117),('2003-08-21 00:00:00',1.1117,1.0885,1.1119,1.0926),('2003-08-22 00:00:00',1.0923,1.0834,1.0945,1.0881),('2003-08-25 00:00:00',1.0852,1.0845,1.0917,1.0862),('2003-08-26 00:00:00',1.0832,1.0791,1.0906,1.085),('2003-08-27 00:00:00',1.0867,1.0831,1.0928,1.0881),('2003-08-28 00:00:00',1.0863,1.0811,1.0911,1.0882),('2003-08-29 00:00:00',1.0884,1.087,1.0996,1.0984),('2003-09-01 00:00:00',1.0989,1.0953,1.1013,1.0967),('2003-09-02 00:00:00',1.0959,1.0801,1.0961,1.081),('2003-09-03 00:00:00',1.0806,1.0762,1.0869,1.0843),('2003-09-04 00:00:00',1.0818,1.0807,1.0947,1.0941),('2003-09-05 00:00:00',1.0926,1.0915,1.111,1.1103),('2003-09-08 00:00:00',1.1091,1.1046,1.1127,1.1064),('2003-09-09 00:00:00',1.1068,1.1054,1.1237,1.1225),('2003-09-10 00:00:00',1.1223,1.1162,1.1235,1.1208),('2003-09-11 00:00:00',1.119,1.1152,1.1269,1.1199),('2003-09-12 00:00:00',1.1201,1.1134,1.1321,1.1287),('2003-09-15 00:00:00',1.1254,1.1244,1.1307,1.1284),('2003-09-16 00:00:00',1.1284,1.1155,1.1315,1.1173),('2003-09-17 00:00:00',1.117,1.1139,1.1298,1.1285),('2003-09-18 00:00:00',1.1276,1.1226,1.1341,1.1247),('2003-09-19 00:00:00',1.1245,1.1237,1.138,1.1363),('2003-09-22 00:00:00',1.1466,1.1412,1.1502,1.1461),('2003-09-23 00:00:00',1.146,1.1431,1.1524,1.1447),('2003-09-24 00:00:00',1.1435,1.1426,1.1501,1.1494),('2003-09-25 00:00:00',1.1482,1.1457,1.1533,1.1485),('2003-09-26 00:00:00',1.1472,1.1438,1.1497,1.1472),('2003-09-29 00:00:00',1.1454,1.1394,1.1637,1.1598),('2003-09-30 00:00:00',1.1599,1.1572,1.1734,1.1657),('2003-10-01 00:00:00',1.1646,1.1642,1.1734,1.1716),('2003-10-02 00:00:00',1.1725,1.1661,1.1766,1.1691),('2003-10-03 00:00:00',1.1684,1.155,1.173,1.156),('2003-10-06 00:00:00',1.1575,1.1532,1.1718,1.1705),('2003-10-07 00:00:00',1.1703,1.1697,1.181,1.1775),('2003-10-08 00:00:00',1.1768,1.1764,1.1836,1.1813),('2003-10-09 00:00:00',1.1817,1.1684,1.1858,1.1746),('2003-10-10 00:00:00',1.1726,1.1701,1.1847,1.1803),('2003-10-13 00:00:00',1.1804,1.1651,1.1812,1.1709),('2003-10-14 00:00:00',1.1702,1.158,1.1763,1.1728),('2003-10-15 00:00:00',1.172,1.1588,1.1744,1.1626),('2003-10-16 00:00:00',1.1621,1.1569,1.1693,1.1583),('2003-10-17 00:00:00',1.1594,1.1545,1.1682,1.1664),('2003-10-20 00:00:00',1.17,1.1601,1.1712,1.1631),('2003-10-21 00:00:00',1.1631,1.1616,1.1696,1.1664),('2003-10-22 00:00:00',1.1663,1.1648,1.1824,1.1803),('2003-10-23 00:00:00',1.181,1.1754,1.1844,1.1787),('2003-10-24 00:00:00',1.1816,1.1761,1.1855,1.1799),('2003-10-27 00:00:00',1.1775,1.1719,1.1781,1.1748),('2003-10-28 00:00:00',1.1739,1.1656,1.174,1.167),('2003-10-29 00:00:00',1.1669,1.1658,1.1717,1.1663),('2003-10-30 00:00:00',1.166,1.161,1.1754,1.1616),('2003-10-31 00:00:00',1.1625,1.1564,1.1653,1.1565),('2003-11-03 00:00:00',1.1579,1.1425,1.1616,1.1462),('2003-11-04 00:00:00',1.1463,1.1427,1.1509,1.1494),('2003-11-05 00:00:00',1.1479,1.1412,1.1496,1.1432),('2003-11-06 00:00:00',1.1428,1.1387,1.1461,1.1409),('2003-11-07 00:00:00',1.1405,1.1375,1.1542,1.1536),('2003-11-10 00:00:00',1.1505,1.1466,1.1533,1.147),('2003-11-11 00:00:00',1.145,1.1444,1.1528,1.1517),('2003-11-12 00:00:00',1.151,1.1504,1.1657,1.1627),('2003-11-13 00:00:00',1.163,1.1629,1.1744,1.1734),('2003-11-14 00:00:00',1.1732,1.1727,1.1801,1.1769),('2003-11-17 00:00:00',1.1818,1.1726,1.1845,1.1752),('2003-11-18 00:00:00',1.1734,1.1733,1.1971,1.1968),('2003-11-19 00:00:00',1.196,1.1872,1.1975,1.1874),('2003-11-20 00:00:00',1.1884,1.1878,1.1963,1.1908),('2003-11-21 00:00:00',1.1907,1.1856,1.1936,1.1913),('2003-11-24 00:00:00',1.1907,1.1759,1.1914,1.1768),('2003-11-25 00:00:00',1.1774,1.1752,1.1816,1.1794),('2003-11-26 00:00:00',1.1786,1.177,1.1946,1.1935),('2003-11-27 00:00:00',1.1936,1.1884,1.1937,1.1912),('2003-11-28 00:00:00',1.1912,1.1898,1.2013,1.1978),('2003-12-01 00:00:00',1.1998,1.1936,1.2039,1.1981),('2003-12-02 00:00:00',1.1967,1.1942,1.2109,1.2079),('2003-12-03 00:00:00',1.2088,1.2065,1.2126,1.2109),('2003-12-04 00:00:00',1.2107,1.2028,1.2154,1.209),('2003-12-05 00:00:00',1.2072,1.2061,1.2175,1.2163),('2003-12-08 00:00:00',1.2165,1.2151,1.2237,1.2222),('2003-12-09 00:00:00',1.222,1.2185,1.2272,1.2254),('2003-12-10 00:00:00',1.225,1.2152,1.2263,1.2211),('2003-12-11 00:00:00',1.2204,1.2112,1.2233,1.2219),('2003-12-12 00:00:00',1.2216,1.2207,1.2304,1.2291),('2003-12-15 00:00:00',1.2162,1.2131,1.232,1.2312),('2003-12-16 00:00:00',1.2311,1.23,1.2358,1.2334),('2003-12-17 00:00:00',1.2324,1.2295,1.2419,1.24),('2003-12-18 00:00:00',1.2399,1.2358,1.2436,1.2424),('2003-12-19 00:00:00',1.2423,1.2344,1.243,1.2376),('2003-12-22 00:00:00',1.2357,1.2348,1.2444,1.2391),('2003-12-23 00:00:00',1.2394,1.2384,1.2424,1.2399),('2003-12-24 00:00:00',1.241,1.2394,1.2467,1.2462),('2003-12-26 00:00:00',1.2449,1.2424,1.2466,1.2429),('2003-12-29 00:00:00',1.2428,1.2425,1.2507,1.2489),('2003-12-30 00:00:00',1.2482,1.2478,1.2559,1.2545),('2003-12-31 00:00:00',1.2548,1.2542,1.2644,1.2594),('2004-01-02 00:00:00',1.2567,1.2522,1.2627,1.2585),('2004-01-05 00:00:00',1.2617,1.2607,1.2692,1.2675),('2004-01-06 00:00:00',1.2682,1.2665,1.2808,1.2727),('2004-01-07 00:00:00',1.2716,1.2619,1.274,1.2621),('2004-01-08 00:00:00',1.2644,1.2558,1.2778,1.2772),('2004-01-09 00:00:00',1.2775,1.2702,1.2864,1.2846),('2004-01-12 00:00:00',1.2846,1.2734,1.2895,1.2742),('2004-01-13 00:00:00',1.2735,1.2711,1.2795,1.2767),('2004-01-14 00:00:00',1.2781,1.2629,1.2786,1.2646),('2004-01-15 00:00:00',1.2656,1.256,1.267,1.2583),('2004-01-16 00:00:00',1.2588,1.2351,1.2606,1.2371),('2004-01-19 00:00:00',1.238,1.2334,1.2421,1.2353),('2004-01-20 00:00:00',1.2352,1.2345,1.2598,1.2593),('2004-01-21 00:00:00',1.2589,1.2549,1.2671,1.2637),('2004-01-22 00:00:00',1.2651,1.2635,1.2749,1.2711),('2004-01-23 00:00:00',1.272,1.2565,1.2773,1.2589),('2004-01-26 00:00:00',1.2582,1.2456,1.261,1.2463),('2004-01-27 00:00:00',1.2478,1.2438,1.2661,1.2643),('2004-01-28 00:00:00',1.2638,1.2412,1.2642,1.2449),('2004-01-29 00:00:00',1.2432,1.2361,1.2525,1.2405),('2004-01-30 00:00:00',1.2407,1.2349,1.249,1.2472),('2004-02-02 00:00:00',1.2473,1.2389,1.2484,1.2433),('2004-02-03 00:00:00',1.2445,1.2415,1.2596,1.2546),('2004-02-04 00:00:00',1.2549,1.2493,1.2559,1.2534),('2004-02-05 00:00:00',1.2538,1.2519,1.2635,1.2551),('2004-02-06 00:00:00',1.2559,1.2512,1.2722,1.2695),('2004-02-09 00:00:00',1.263,1.2605,1.2759,1.2696),('2004-02-10 00:00:00',1.2689,1.2667,1.2786,1.2683),('2004-02-11 00:00:00',1.2675,1.2648,1.2844,1.2833),('2004-02-12 00:00:00',1.2832,1.2787,1.2843,1.2813),('2004-02-13 00:00:00',1.2803,1.2715,1.289,1.2734),('2004-02-16 00:00:00',1.2723,1.2717,1.2786,1.2773),('2004-02-17 00:00:00',1.2763,1.2757,1.2875,1.2847),('2004-02-18 00:00:00',1.2843,1.266,1.2926,1.2692),('2004-02-19 00:00:00',1.2704,1.2648,1.2743,1.2709),('2004-02-20 00:00:00',1.276,1.2493,1.2765,1.2518),('2004-02-23 00:00:00',1.2507,1.2449,1.2593,1.2574),('2004-02-24 00:00:00',1.257,1.2522,1.271,1.2682),('2004-02-25 00:00:00',1.2676,1.2475,1.2704,1.2491),('2004-02-26 00:00:00',1.2495,1.2382,1.2514,1.2435),('2004-02-27 00:00:00',1.2442,1.2371,1.2505,1.249),('2004-03-01 00:00:00',1.2522,1.2424,1.2539,1.2459),('2004-03-02 00:00:00',1.2455,1.2194,1.2459,1.2221),('2004-03-03 00:00:00',1.2202,1.2056,1.2215,1.2202),('2004-03-04 00:00:00',1.2184,1.2134,1.2238,1.2197),('2004-03-05 00:00:00',1.2185,1.2175,1.2429,1.2369),('2004-03-08 00:00:00',1.2376,1.2337,1.2415,1.2401),('2004-03-09 00:00:00',1.2413,1.2273,1.2456,1.2319),('2004-03-10 00:00:00',1.2314,1.2197,1.2336,1.2213),('2004-03-11 00:00:00',1.2223,1.2162,1.2385,1.2362),('2004-03-12 00:00:00',1.2349,1.2173,1.2356,1.2225),('2004-03-15 00:00:00',1.2212,1.2203,1.2315,1.2263),('2004-03-16 00:00:00',1.2262,1.2231,1.237,1.2268),('2004-03-17 00:00:00',1.2268,1.2176,1.2287,1.2235),('2004-03-18 00:00:00',1.223,1.2221,1.243,1.2386),('2004-03-19 00:00:00',1.2385,1.2256,1.2405,1.2276),('2004-03-22 00:00:00',1.2269,1.2221,1.2399,1.2342),('2004-03-23 00:00:00',1.2343,1.2265,1.2367,1.2342),('2004-03-24 00:00:00',1.2344,1.2109,1.2365,1.2135),('2004-03-25 00:00:00',1.2137,1.2096,1.2197,1.2126),('2004-03-26 00:00:00',1.2131,1.2073,1.2207,1.2125),('2004-03-29 00:00:00',1.2121,1.2047,1.2166,1.2154),('2004-03-30 00:00:00',1.2156,1.215,1.2225,1.2167),('2004-03-31 00:00:00',1.2181,1.2168,1.2319,1.2311),('2004-04-01 00:00:00',1.2307,1.2253,1.2386,1.2359),('2004-04-02 00:00:00',1.2366,1.2101,1.2371,1.2124),('2004-04-05 00:00:00',1.211,1.1984,1.2127,1.1998),('2004-04-06 00:00:00',1.2004,1.1982,1.2141,1.2113),('2004-04-07 00:00:00',1.213,1.2049,1.2194,1.2171),('2004-04-08 00:00:00',1.216,1.2061,1.2216,1.2086),('2004-04-09 00:00:00',1.2075,1.2063,1.2105,1.2095),('2004-04-12 00:00:00',1.2081,1.2053,1.2096,1.2075),('2004-04-13 00:00:00',1.2066,1.1904,1.2079,1.1945),('2004-04-14 00:00:00',1.1938,1.1867,1.197,1.196),('2004-04-15 00:00:00',1.1939,1.1892,1.1989,1.1981),('2004-04-16 00:00:00',1.1978,1.1924,1.2043,1.1991),('2004-04-19 00:00:00',1.2017,1.1999,1.2076,1.2014),('2004-04-20 00:00:00',1.2,1.1842,1.2009,1.1867),('2004-04-21 00:00:00',1.1842,1.1814,1.1913,1.1839),('2004-04-22 00:00:00',1.1829,1.1779,1.1913,1.1907),('2004-04-23 00:00:00',1.192,1.1796,1.1941,1.1835),('2004-04-26 00:00:00',1.1799,1.1759,1.1882,1.1856),('2004-04-27 00:00:00',1.1854,1.1831,1.1944,1.193),('2004-04-28 00:00:00',1.1927,1.182,1.1951,1.1839),('2004-04-29 00:00:00',1.1837,1.1803,1.1981,1.1965),('2004-04-30 00:00:00',1.1962,1.1918,1.2009,1.1982),('2004-05-03 00:00:00',1.199,1.1919,1.1998,1.1935),('2004-05-04 00:00:00',1.1932,1.1925,1.2115,1.2098),('2004-05-05 00:00:00',1.2105,1.2095,1.2177,1.2168),('2004-05-06 00:00:00',1.2156,1.2062,1.2171,1.2068),('2004-05-07 00:00:00',1.207,1.1875,1.2135,1.1892),('2004-05-10 00:00:00',1.1878,1.181,1.1891,1.1833),('2004-05-11 00:00:00',1.1834,1.1789,1.1888,1.1867),('2004-05-12 00:00:00',1.1871,1.1833,1.1938,1.1899),('2004-05-13 00:00:00',1.1902,1.1772,1.1926,1.1819),('2004-05-14 00:00:00',1.1804,1.1779,1.1897,1.188),('2004-05-17 00:00:00',1.1891,1.1876,1.2059,1.2015),('2004-05-18 00:00:00',1.2017,1.1929,1.2037,1.1949),('2004-05-19 00:00:00',1.1951,1.1935,1.204,1.2012),('2004-05-20 00:00:00',1.1997,1.1894,1.2016,1.1959),('2004-05-21 00:00:00',1.1954,1.1952,1.2068,1.2002),('2004-05-24 00:00:00',1.1997,1.1932,1.202,1.2002),('2004-05-25 00:00:00',1.1991,1.1983,1.2123,1.2099),('2004-05-26 00:00:00',1.2095,1.2077,1.2141,1.2108),('2004-05-27 00:00:00',1.21,1.2086,1.2285,1.2266),('2004-05-28 00:00:00',1.2269,1.2199,1.2293,1.2212),('2004-05-31 00:00:00',1.2238,1.2177,1.224,1.2183),('2004-06-01 00:00:00',1.2199,1.2155,1.2264,1.2242),('2004-06-02 00:00:00',1.224,1.2204,1.2303,1.2213),('2004-06-03 00:00:00',1.2218,1.2168,1.2248,1.2214),('2004-06-04 00:00:00',1.222,1.2139,1.2296,1.2288),('2004-06-07 00:00:00',1.2313,1.2291,1.2335,1.2313),('2004-06-08 00:00:00',1.2315,1.2244,1.2349,1.2259),('2004-06-09 00:00:00',1.2256,1.2026,1.2272,1.2039),('2004-06-10 00:00:00',1.2031,1.2023,1.2114,1.2104),('2004-06-11 00:00:00',1.2096,1.1964,1.2112,1.2016),('2004-06-14 00:00:00',1.1969,1.1953,1.2085,1.2053),('2004-06-15 00:00:00',1.2061,1.2028,1.2166,1.2158),('2004-06-16 00:00:00',1.2158,1.1979,1.2166,1.2009),('2004-06-17 00:00:00',1.2003,1.1991,1.2075,1.2052),('2004-06-18 00:00:00',1.204,1.1973,1.2143,1.2138),('2004-06-21 00:00:00',1.2137,1.2075,1.2142,1.2112),('2004-06-22 00:00:00',1.2117,1.2065,1.2128,1.2112),('2004-06-23 00:00:00',1.2115,1.2063,1.219,1.209),('2004-06-24 00:00:00',1.2089,1.2039,1.2185,1.2171),('2004-06-25 00:00:00',1.2181,1.2106,1.2187,1.2154),('2004-06-28 00:00:00',1.2178,1.2121,1.2226,1.2182),('2004-06-29 00:00:00',1.2186,1.2066,1.2189,1.2079),('2004-06-30 00:00:00',1.2083,1.2064,1.2201,1.2187),('2004-07-01 00:00:00',1.2181,1.2134,1.2206,1.2153),('2004-07-02 00:00:00',1.2154,1.2144,1.2324,1.2318),('2004-07-05 00:00:00',1.233,1.227,1.2333,1.2283),('2004-07-06 00:00:00',1.2293,1.2262,1.2326,1.2282),('2004-07-07 00:00:00',1.2283,1.2273,1.2385,1.2364),('2004-07-08 00:00:00',1.2364,1.2339,1.2402,1.2384),('2004-07-09 00:00:00',1.2385,1.2368,1.2419,1.2408),('2004-07-12 00:00:00',1.2411,1.2381,1.2433,1.241),('2004-07-13 00:00:00',1.24,1.2301,1.2409,1.2335),('2004-07-14 00:00:00',1.2329,1.2317,1.2417,1.2382),('2004-07-15 00:00:00',1.2382,1.2327,1.2387,1.2354),('2004-07-16 00:00:00',1.2354,1.2328,1.2456,1.2446),('2004-07-19 00:00:00',1.245,1.2398,1.2458,1.2437),('2004-07-20 00:00:00',1.2439,1.2303,1.2451,1.2329),('2004-07-21 00:00:00',1.2329,1.2211,1.2347,1.2259),('2004-07-22 00:00:00',1.2255,1.2232,1.229,1.2256),('2004-07-23 00:00:00',1.225,1.2088,1.2263,1.21),('2004-07-26 00:00:00',1.2099,1.2088,1.2168,1.2143),('2004-07-27 00:00:00',1.2134,1.2035,1.2185,1.2055),('2004-07-28 00:00:00',1.2056,1.1999,1.2076,1.2046),('2004-07-29 00:00:00',1.2047,1.1992,1.2093,1.2042),('2004-07-30 00:00:00',1.2034,1.2001,1.2115,1.2022),('2004-08-02 00:00:00',1.205,1.2019,1.209,1.2023),('2004-08-03 00:00:00',1.2017,1.1993,1.2073,1.205),('2004-08-04 00:00:00',1.2052,1.1969,1.2065,1.2046),('2004-08-05 00:00:00',1.2055,1.202,1.207,1.2054),('2004-08-06 00:00:00',1.2048,1.2042,1.2286,1.2285),('2004-08-09 00:00:00',1.228,1.2244,1.2286,1.2265),('2004-08-10 00:00:00',1.2267,1.2222,1.2315,1.2229),('2004-08-11 00:00:00',1.2228,1.2195,1.2246,1.2217),('2004-08-12 00:00:00',1.2222,1.2215,1.2296,1.2252),('2004-08-13 00:00:00',1.2238,1.2176,1.2371,1.2368),('2004-08-16 00:00:00',1.2373,1.2315,1.2378,1.2357),('2004-08-17 00:00:00',1.2354,1.2308,1.2386,1.2352),('2004-08-18 00:00:00',1.2344,1.2285,1.2362,1.2336),('2004-08-19 00:00:00',1.2334,1.2332,1.2375,1.2364),('2004-08-20 00:00:00',1.237,1.2277,1.2377,1.231),('2004-08-23 00:00:00',1.2299,1.2131,1.2315,1.2138),('2004-08-24 00:00:00',1.2137,1.2061,1.2164,1.208),('2004-08-25 00:00:00',1.2075,1.2052,1.2112,1.208),('2004-08-26 00:00:00',1.2084,1.2042,1.2117,1.2102),('2004-08-27 00:00:00',1.21,1.2005,1.2132,1.201),('2004-08-30 00:00:00',1.2013,1.1986,1.2066,1.2052),('2004-08-31 00:00:00',1.2049,1.2042,1.2191,1.2181),('2004-09-01 00:00:00',1.2176,1.2145,1.2217,1.2193),('2004-09-02 00:00:00',1.2187,1.2141,1.2196,1.2172),('2004-09-03 00:00:00',1.2175,1.2041,1.2191,1.2061),('2004-09-06 00:00:00',1.2055,1.2047,1.2078,1.2061),('2004-09-07 00:00:00',1.2059,1.2054,1.2108,1.2108),('2004-09-08 00:00:00',1.2103,1.2025,1.2187,1.218),('2004-09-09 00:00:00',1.2174,1.2157,1.2234,1.2233),('2004-09-10 00:00:00',1.2233,1.2198,1.2306,1.2264),('2004-09-13 00:00:00',1.2271,1.2221,1.2284,1.2256),('2004-09-14 00:00:00',1.2257,1.2225,1.2291,1.2247),('2004-09-15 00:00:00',1.2249,1.2134,1.2258,1.2148),('2004-09-16 00:00:00',1.2148,1.212,1.2193,1.2181),('2004-09-17 00:00:00',1.219,1.2157,1.222,1.2179),('2004-09-20 00:00:00',1.2169,1.2123,1.2175,1.2172),('2004-09-21 00:00:00',1.2165,1.2164,1.2345,1.2327),('2004-09-22 00:00:00',1.2326,1.2226,1.2328,1.2263),('2004-09-23 00:00:00',1.2263,1.2252,1.2329,1.2267),('2004-09-24 00:00:00',1.2264,1.2237,1.2358,1.2262),('2004-09-27 00:00:00',1.2284,1.2247,1.2311,1.2305),('2004-09-28 00:00:00',1.2304,1.2279,1.2345,1.2323),('2004-09-29 00:00:00',1.2321,1.2286,1.2337,1.233),('2004-09-30 00:00:00',1.2336,1.2313,1.244,1.2429),('2004-10-01 00:00:00',1.2426,1.2382,1.2434,1.241),('2004-10-04 00:00:00',1.2394,1.2257,1.2395,1.229),('2004-10-05 00:00:00',1.2282,1.2263,1.2326,1.2309),('2004-10-06 00:00:00',1.2312,1.2247,1.2319,1.2282),('2004-10-07 00:00:00',1.2278,1.2272,1.231,1.2284),('2004-10-08 00:00:00',1.2285,1.2283,1.2429,1.2405),('2004-10-11 00:00:00',1.2404,1.237,1.2418,1.2379),('2004-10-12 00:00:00',1.2378,1.2287,1.2387,1.2324),('2004-10-13 00:00:00',1.2318,1.2226,1.2354,1.2343),('2004-10-14 00:00:00',1.2335,1.232,1.2416,1.2379),('2004-10-15 00:00:00',1.2387,1.2378,1.2502,1.2472),('2004-10-18 00:00:00',1.2478,1.2459,1.253,1.2492),('2004-10-19 00:00:00',1.2482,1.2452,1.2523,1.2514),('2004-10-20 00:00:00',1.2512,1.2496,1.2625,1.2583),('2004-10-21 00:00:00',1.2574,1.2572,1.265,1.2611),('2004-10-22 00:00:00',1.2608,1.2598,1.2678,1.267),('2004-10-25 00:00:00',1.2712,1.2708,1.2827,1.2805),('2004-10-26 00:00:00',1.2805,1.2726,1.2838,1.2751),('2004-10-27 00:00:00',1.2756,1.2694,1.2809,1.2697),('2004-10-28 00:00:00',1.2702,1.2631,1.2763,1.2744),('2004-10-29 00:00:00',1.2743,1.2704,1.2793,1.2793),('2004-11-01 00:00:00',1.2825,1.2717,1.283,1.2752),('2004-11-02 00:00:00',1.2742,1.2665,1.2753,1.2743),('2004-11-03 00:00:00',1.271,1.2656,1.2827,1.282),('2004-11-04 00:00:00',1.2824,1.2789,1.2895,1.2872),('2004-11-05 00:00:00',1.2871,1.2764,1.2966,1.2964),('2004-11-08 00:00:00',1.2967,1.2905,1.2984,1.2912),('2004-11-09 00:00:00',1.2909,1.2882,1.2937,1.2896),('2004-11-10 00:00:00',1.2892,1.285,1.3002,1.2892),('2004-11-11 00:00:00',1.288,1.2858,1.2916,1.2906),('2004-11-12 00:00:00',1.2911,1.2875,1.2984,1.2973),('2004-11-15 00:00:00',1.2977,1.2915,1.2995,1.2951),('2004-11-16 00:00:00',1.2938,1.2918,1.2992,1.2957),('2004-11-17 00:00:00',1.2961,1.2953,1.3044,1.3029),('2004-11-18 00:00:00',1.3028,1.294,1.3071,1.2948),('2004-11-19 00:00:00',1.2953,1.2938,1.3065,1.3025),('2004-11-22 00:00:00',1.3026,1.3012,1.305,1.304),('2004-11-23 00:00:00',1.3034,1.2976,1.3101,1.3082),('2004-11-24 00:00:00',1.3087,1.308,1.3186,1.3183),('2004-11-25 00:00:00',1.3175,1.3161,1.3281,1.3268),('2004-11-26 00:00:00',1.3261,1.3183,1.3326,1.3292),('2004-11-29 00:00:00',1.3271,1.3227,1.3302,1.3269),('2004-11-30 00:00:00',1.3268,1.323,1.3329,1.3277),('2004-12-01 00:00:00',1.3295,1.3276,1.3356,1.3341),('2004-12-02 00:00:00',1.3338,1.3236,1.3382,1.3264),('2004-12-03 00:00:00',1.3258,1.3254,1.3457,1.3456),('2004-12-06 00:00:00',1.3441,1.3389,1.3453,1.3405),('2004-12-07 00:00:00',1.3389,1.3389,1.3467,1.3417),('2004-12-08 00:00:00',1.3421,1.3194,1.343,1.3337),('2004-12-09 00:00:00',1.3353,1.3251,1.3358,1.3304),('2004-12-10 00:00:00',1.331,1.3139,1.3316,1.3223),('2004-12-13 00:00:00',1.3195,1.3195,1.3325,1.3309),('2004-12-14 00:00:00',1.3314,1.3259,1.3332,1.3291),('2004-12-15 00:00:00',1.3288,1.326,1.3438,1.3393),('2004-12-16 00:00:00',1.3403,1.3204,1.3427,1.3237),('2004-12-17 00:00:00',1.3241,1.3226,1.3313,1.3286),('2004-12-20 00:00:00',1.3312,1.3296,1.3406,1.3391),('2004-12-21 00:00:00',1.3395,1.3351,1.3406,1.3361),('2004-12-22 00:00:00',1.336,1.3341,1.3401,1.3386),('2004-12-23 00:00:00',1.3386,1.338,1.3514,1.3502),('2004-12-24 00:00:00',1.3506,1.3484,1.3545,1.3529),('2004-12-27 00:00:00',1.3523,1.3513,1.3637,1.3622),('2004-12-28 00:00:00',1.3621,1.3589,1.3641,1.3609),('2004-12-29 00:00:00',1.3594,1.3556,1.3644,1.3606),('2004-12-30 00:00:00',1.3604,1.3575,1.3663,1.3632),('2004-12-31 00:00:00',1.3625,1.3513,1.3659,1.3565),('2005-01-03 00:00:00',1.3565,1.3385,1.3578,1.3461),('2005-01-04 00:00:00',1.3467,1.3249,1.3492,1.3276),('2005-01-05 00:00:00',1.3271,1.3213,1.33,1.3268),('2005-01-06 00:00:00',1.3274,1.3155,1.3279,1.3173); #...
 
 
 
CREATE PROCEDURE sp()
 
SELECT *
 
FROM
 
  ( SELECT datetime AS `datetime`#,
 
           #ta_previous(round(ta_rsi(CLOSE,14), 2),40) AS F1,
 
           #ta_previous(CLOSE,40),
 
           #ta_max(high,40),
 
           #ta_min(low,40)
 
   FROM
 
     ( SELECT * FROM EURUSD_86400
 
      WHERE datetime >= '0001-01-01'
 
        AND datetime <= '9999-12-31'
 
      ORDER BY datetime DESC LIMIT 5000) AS R
 
   ORDER BY datetime ASC ) AS LIMIT_ROWS
 
#WHERE F1 > 75
 
ORDER BY datetime DESC LIMIT 20;
 
 
 
call sp();
 
set optimizer_switch='derived_merge=off';
 
call sp();

and got the crash (filed as MDEV-20325), but I guess it might be the other bug, not the same as reported.

Comment by João Costa [ 2019-08-12 ]

Thank you for looking into this, I have attached the files you requested.

As far as I can tell, "SHOW CREATE FUNCTION" does not seem to return data for UDFs, so I am also including the output of "select * from mysql.func" in case that is useful.

Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 11
 
Server version: 10.4.7-MariaDB-1:10.4.7+maria~bionic mariadb.org binary distribution
 
 
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [db]> SHOW CREATE FUNCTION ta_previous;
 
ERROR 1305 (42000): FUNCTION ta_previous does not exist
 
MariaDB [db]> SHOW CREATE FUNCTION ta_max;
 
ERROR 1305 (42000): FUNCTION ta_max does not exist
 
MariaDB [db]> SHOW CREATE FUNCTION ta_min;
 
ERROR 1305 (42000): FUNCTION ta_min does not exist
 
MariaDB [db]>  select * from mysql.func;
 
+-------------+-----+--------------------+----------+
 
| name        | ret | dl                 | type     |
 
+-------------+-----+--------------------+----------+
 
| ta_ema      |   1 | lib_mysqludf_ta.so | function |
 
| ta_max      |   1 | lib_mysqludf_ta.so | function |
 
| ta_min      |   1 | lib_mysqludf_ta.so | function |
 
| ta_previous |   1 | lib_mysqludf_ta.so | function |
 
| ta_rsi      |   1 | lib_mysqludf_ta.so | function |
 
| ta_sma      |   1 | lib_mysqludf_ta.so | function |
 
| ta_stddevp  |   1 | lib_mysqludf_ta.so | function |
 
| ta_sum      |   1 | lib_mysqludf_ta.so | function |
 
| ta_tr       |   1 | lib_mysqludf_ta.so | function |
 
+-------------+-----+--------------------+----------+
 
9 rows in set (0.001 sec)

One difference between this crash report and the report in MDEV-20325 is that MDEV-20325 claims to apply to 10.1 too, while MDEV-20314 (this report) does not.

Comment by João Costa [ 2019-08-12 ]

I have also tried to reproduce the steps in MDEV-20325 and found no issues. Perhaps that's because I'm running a release build of mariadb.

Generated at Thu Feb 08 08:58:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.