15684: When reloading decimal value with 0 with MSSQL : 0 disappear

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

15684	Bug reports	Survey taking	public	2019-12-20 16:50	2020-01-15 11:59

Reporter	DenisChenu	Assigned To	DenisChenu
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	3.21.3
Fixed in Version	3.21.3

Summary	15684: When reloading decimal value with 0 with MSSQL : 0 disappear
Description	When relmoading (from DB) with 0 as integer value : it brke when doing survey : 0 : `.0000000000` 0.1 : `.1000000000` Maybe due to specific mssql config. Reload by DB can be done with token + token answer persistance
Steps To Reproduce	Find a mssql server with IIS Import include survey Luabch the 1st token
Additional Information	Global fic for decimal in qanda seems the best solution There are issue to in browse response and export : but less important.
Tags	No tags attached.
Attached Files	Capture d’écran du 2019-12-20 16-45-15.png (28,859 bytes) Capture d’écran du 2019-12-20 16-45-15.png (28,859 bytes) survey_archive_0onMssql.lsa (4,637 bytes) survey_archive_0onMssqlExportedMSSQL.lsa (4,468 bytes) Capture d’écran du 2019-12-20 16-49-58.png (5,958 bytes) Capture d’écran du 2019-12-20 16-49-58.png (5,958 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	3.21.1
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	sqlsrv SQLserver 12
Server OS (if known)	windowserver 2016
Webserver software & version (if known)	IIS
PHP Version	php7.2

User List	There are no users monitoring this issue.

DenisChenu 2019-12-20 16:51 developer ~55107	survey_archive_0onMssql.lsa is the exporeted data via mariadb survey_archive_0onMssqlExportedMSSQL.lsa is from MSSQL server : show clealy data is saved as .XXX if start by 0

DenisChenu 2019-12-20 17:43 developer ~55108	https://github.com/LimeSurvey/LimeSurvey/pull/1354

DenisChenu 2020-01-08 14:45 developer ~55154	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29312

DenisChenu 2020-01-09 11:54 developer ~55168	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29318

lime_release_bot 2020-01-15 11:59 administrator ~55272	Fixed in Release 3.21.5+200115

LimeSurvey: master 2eb78e6c 2020-01-08 15:45 DenisChenu Committer: ollehar Details Diff	[WIP] Dev: Issue with MSSQL and 0 or 0.1 or 0.001 (#1354) Fixed issue 15684: MSSQL issue reloading decimal value Fixed issue 15685: Issue when exporting decimal value in MSSQL	Affected Issues 15684, 15685
	mod - application/controllers/admin/dataentry.php	Diff File
	mod - application/helpers/admin/export/SurveyObj.php	Diff File
	mod - application/helpers/common_helper.php	Diff File
	mod - application/helpers/expressions/em_core_helper.php	Diff File
	mod - application/helpers/qanda_helper.php	Diff File
	mod - application/models/SurveyDynamic.php	Diff File
LimeSurvey: master a4e89005 2020-01-09 12:53 DenisChenu Committer: ollehar Details Diff	Fixed issue 15684: When reloading decimal value with 0 with MSSQL : 0 disappear (#1360) Fixed issue 15685: Issue when exporting decimal value in MSSQL	Affected Issues 15684, 15685
	mod - application/controllers/admin/dataentry.php	Diff File
	mod - application/helpers/admin/export/SurveyObj.php	Diff File
	mod - application/helpers/common_helper.php	Diff File
	mod - application/helpers/qanda_helper.php	Diff File

Date Modified	Username	Field	Change
2019-12-20 16:50	DenisChenu	New Issue
2019-12-20 16:50	DenisChenu	Status	new => assigned
2019-12-20 16:50	DenisChenu	Assigned To	=> DenisChenu
2019-12-20 16:50	DenisChenu	File Added: Capture d’écran du 2019-12-20 16-45-15.png
2019-12-20 16:50	DenisChenu	File Added: survey_archive_0onMssql.lsa
2019-12-20 16:50	DenisChenu	File Added: survey_archive_0onMssqlExportedMSSQL.lsa
2019-12-20 16:50	DenisChenu	File Added: Capture d’écran du 2019-12-20 16-49-58.png
2019-12-20 16:51	DenisChenu	Note Added: 55107
2019-12-20 17:13	DenisChenu	Relationship added	related to 15685
2019-12-20 17:43	DenisChenu	Note Added: 55108
2020-01-08 14:45	ollehar	Changeset attached	=> LimeSurvey master 2eb78e6c
2020-01-08 14:45	DenisChenu	Note Added: 55154
2020-01-08 14:45	DenisChenu	Resolution	open => fixed
2020-01-09 11:54	ollehar	Changeset attached	=> LimeSurvey master a4e89005
2020-01-09 11:54	DenisChenu	Note Added: 55168
2020-01-10 16:19	DenisChenu	Status	assigned => resolved
2020-01-10 16:19	DenisChenu	Fixed in Version	=> 3.21.3
2020-01-15 11:59	lime_release_bot	Note Added: 55272
2020-01-15 11:59	lime_release_bot	Status	resolved => closed