Tested with Jan 2014 RC2. All mentioned problems still occur with this release.
Also, with the no_mitosis_pipe my program has problems with DELETE’s and possibly other queries
not taking place effectively somehow. For me the investigation of the Jan2014 build stops here
until some of the problems mentioned here are fixed
Regards, Bas
Van: Bas Kaptijn
Verzonden: dinsdag 21 januari 2014 12:55
Aan: 'users-list@monetdb.org'
Onderwerp: RE: problem with Jan2014 build
Some last info: the problem disappears when using the no_mitosis_pipe optimizer pipeline.
sql>set optimizer='no_mitosis_pipe';
operation successful (0.139ms)
sql>SELECT * FROM source1 WHERE SUBSTRING(SOURCE,1,2)='04' LIMIT 1 OFFSET 400000;
+-----------------------------------------------------------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| file | line | source
|
+=============================================================================+========+====================================================================================================================================================+
| /home/bkaptijn/DDDB/.tmpinputdir/9772_9999_20130501_20130531_Schade_516.ASC | 430664 | 04999999999999999999999999999999999999999
:
+-----------------------------------------------------------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------+
1 tuple (1.1s)
sql>set optimizer='default_pipe';
operation successful (0.305ms)
sql>SELECT * FROM source1 WHERE SUBSTRING(SOURCE,1,2)='04' LIMIT 1 OFFSET 400000;
+------+------+--------+
| file | line | source |
+======+======+========+
+------+------+--------+
0 tuples (798.870ms)
Regards, Bas