data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

`@` in password not support

Open qsliu2017 opened this issue 1 year ago • 6 comments

Describe the bug

Say a user with password passwd@123. Since @ in DSN can not be distinguished, it should be quoted as passwd%40123. However datadiff does not support quoted DSN currently.

After searching, I found that dsnparse 0.2.0 has support that kind of quoted DSNs.

please consider to upgrade the dependency version to “>0.2.0”. https://github.com/datafold/data-diff/blob/be5256c738732ee20285dd6874bfa9c98c592e3f/pyproject.toml#L28

qsliu2017 avatar Aug 10 '23 06:08 qsliu2017

@qsliu2017 ty for reporting this!

There was an issue in 0.2.0 here https://github.com/datafold/data-diff/issues/616

We'll have to investigate/mitigate that if we bump the version up

dlawin avatar Aug 16 '23 19:08 dlawin

@qsliu2017 What databases are you diffing? We recently fixed this for postgres: #812

sungchun12 avatar Jan 02 '24 22:01 sungchun12

@qsliu2017 What databases are you diffing? We recently fixed this for postgres: #812

oracle :(

qsliu2017 avatar Jan 11 '24 06:01 qsliu2017

Okay, I think this should be relatively easy to fix.

sungchun12 avatar Jan 11 '24 17:01 sungchun12

Same issue here

DiogoParrinhaAM avatar Apr 08 '24 17:04 DiogoParrinhaAM

Workaround: use a job file

DiogoParrinhaAM avatar Apr 08 '24 17:04 DiogoParrinhaAM

Hi @qsliu2017 and @DiogoParrinhaAM,

I'm sorry for the delay in following up on this. Thank you for raising this issue and for looking into potential solutions!

We made a hard decision to sunset the data-diff package and won't provide further development or support.

If that's of interest, over the past few months, we have rewritten the diffing engine in Datafold Cloud and solved many issues that existed in this package's diffing algorithm. Feel free to take it for a trial and contact us at [email protected] if you have any questions.

-Gleb

glebmezh avatar May 17 '24 13:05 glebmezh