View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06136Bug reportsConditionspublic2012-06-07 11:02
Reporteradoubleu Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06136: Relevance evaluation with Postgres
Description

Condition is executed correctly with mysql but not with postgres.
I checked version 1.92+ and found same problem also in 2.00RC1.

Error description:

  • create a condition for a question based on token, should start with a regex, e.g. ^test.
    -> resulting relevance evaluation in mysql is ((regexMatch("/^test/", TOKEN:TOKEN))), which is correct
    -> resulting relevante evaluation in limesurvey is ((TOKEN:TOKENRX"^test")), which is not correct
Steps To Reproduce

Reproduce:

Use postgres version 8.4 or 9.1, checked both

  • create a new questionnaire
  • create a new section
  • create a new question of any type
  • create a condition: tab token fields - select e.g. token. Comparision regex. Regex : ^test .
Additional Information

-

TagsNo tags attached.
Attached Files
screens.zip (273,855 bytes)
create-postgres.sql (17,935 bytes)
Bug heat4
Complete LimeSurvey version number (& build)1.92
I will donate to the project if issue is resolvedYes
Browserany
Database type & versionpostgres 8 or 9
Server OS (if known)windows or linux - both checked
Webserver software & version (if known)apache 2.2
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-05-27 11:19

administrator   ~18915

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8550

c_schmitz

c_schmitz

2012-05-27 11:20

administrator   ~18916

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8552

adoubleu

adoubleu

2012-05-27 16:44

reporter   ~18923

Hi c_schmitz, thanks a lot for the fast update. I finally also get 1.92 release to work with the file I just uploaded. It replaces the file in admin/install.
Regards

c_schmitz

c_schmitz

2012-06-07 11:02

administrator   ~19109

New 1.91+ build released.

Related Changesets

LimeSurvey: master aca8af3a

2012-05-27 02:19:15

c_schmitz

Details Diff
Fixed issue 06136: Relevance evaluation with Postgres fails when using regular expressions Affected Issues
06136
mod - classes/expressions/LimeExpressionManager.php Diff File

LimeSurvey: Yii 99e02fee

2012-05-27 02:20:29

c_schmitz

Details Diff
Fixed issue 06136: Relevance evaluation with Postgres fails when using regular expressions Affected Issues
06136
mod - application/helpers/update/upgrade-pgsql_helper.php Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2012-05-27 09:34 adoubleu New Issue
2012-05-27 09:35 adoubleu File Added: screens.zip
2012-05-27 09:35 adoubleu Issue Monitored: adoubleu
2012-05-27 09:35 adoubleu Issue End Monitor: adoubleu
2012-05-27 11:18 c_schmitz Assigned To => c_schmitz
2012-05-27 11:18 c_schmitz Status new => assigned
2012-05-27 11:19 c_schmitz Changeset attached => LimeSurvey master aca8af3a
2012-05-27 11:19 c_schmitz Note Added: 18915
2012-05-27 11:19 c_schmitz Resolution open => fixed
2012-05-27 11:20 c_schmitz Changeset attached => LimeSurvey Yii 99e02fee
2012-05-27 11:20 c_schmitz Note Added: 18916
2012-05-27 11:21 c_schmitz Status assigned => resolved
2012-05-27 11:21 c_schmitz Fixed in Version => 1.92+
2012-05-27 16:44 adoubleu Note Added: 18923
2012-05-27 16:45 adoubleu File Added: create-postgres.sql
2012-06-07 11:02 c_schmitz Note Added: 19109
2012-06-07 11:02 c_schmitz Status resolved => closed