Skip to content

Numbers in prepared statements are not always normalized #171

Description

@IlGhirardz

Example:

example_text:
declare @p1 int
set @p1=0
exec sp_prepexec @p1 output,NULL,N'UPDATE s3_exp_tb_GP_Job_queue_AE SET fg_stato = 4, dt_fine = getdate(), fg_errore = ''Ordine reiportato successivamente'' WHERE n_anno = 2026 AND c_numeratore = ''OVG'' AND n_ordine = 276540 AND fg_stato IN (0,9) '
select @p1 ; EXEC sp_unprepare @p1;

normalized_text:
{PREPARED} UPDATE S3_EXP_TB_GP_JOB_QUEUE_AE SET FG_STATO = 4, DT_FINE = GETDATE(), FG_ERRORE = {STR} WHERE N_ANNO = 2026 AND C_NUMERATORE = {STR} AND N_ORDINE = 276540 AND FG_STATO IN (0,9)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions