#9 SQLDeArger Parsing

[Steve Souza]

The jamon proxy driver doesn't parse the following sql
correctly:
select * from table where col<100
should parse to
select * from table where col<?
but parses to
select * from table where col

Note if spaces are put betwee col<100 then it will
parse correctly: select * from table where col < 100

[Steve Souza]

Logged In: YES
user_id=828052

Also numbers that should be replaced with a '?' are not in
some cases (hex, and exponential notation). Examples follow:

1) hex
insert dbcc_fault_params (dbid, opid, faultid, type_code,
binaryvalue)
values(?,?,?,?,0x003C5D60000000000000000072FB1674448D315C00070000000307270801000B020001010000000000C90000)

2) exponential notation
UPDATE m_task_mods_m SET action_cd = ?, close_out =
?, mod_no = ?, mod_cre_dt = ?, mod_eff_dt = ?, task_end_dt =
?, mod_tot_awd
= ?.?, mod_tot_awd_diff = ?.99999999999E9, mod_est_val =
?.?, oaco_f_name =
?, oaco_l_name = ?, oaco_voice = ?, oaco_voi_ext = ?,
oaco_fax = ?,
oaco_email = ?, cotr_f_name = ?, cotr_l_name = ?, cotr_voice
= ?,
cotr_voi_ext = ?, cotr_fax = ?, cotr_email = ?, poc_f_name =
?, poc_l_name
= ?, poc_voice = ?, poc_voi_ext = ?, poc_fax = ?, poc_email
= ? WHERE key1
= ? AND key2 = ?

3) maybe decimals???
4.567 does this turn to '?' as it should?

[Steve Souza]

Logged In: YES
user_id=828052

4) other examples of numbers that are in exponential
notation that should turn to '?'
1.73e+5
-2.93E+9
145.06e-5
.003E+4
+1234.56789e105