Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing zeros within GUID #31

Open
doak opened this issue Jul 8, 2020 · 2 comments
Open

Missing zeros within GUID #31

doak opened this issue Jul 8, 2020 · 2 comments
Labels
bug Something isn't working good first issue Good for newcomers help wanted Extra attention is needed

Comments

@doak
Copy link

doak commented Jul 8, 2020

I use a MS SQL database containing a GUID as primary key.
Although the key is 96663d36-3a70-4969-c565-08d5e7197013, it is displayed by Schema Explorer as 96663d36-3a70-4969-c565-8d5e7197013, thus missing the leading zero of the last block:
missing-digit

I am using the current master (.i.e. 6cad5c3).

Let me know if you need additional information.

@doak
Copy link
Author

doak commented Jul 9, 2020

I just realised that every 0 digit is not diplayed.
It also happens with 33723e01-8c81-474b-7ec5-08d5e106d547 which will be displayed as 33723e1-8c81-474b-7ec5-8d5e16d547.

@doak doak changed the title Missing leading zeros for GUID Missing zeros within GUID Jul 9, 2020
@timabell
Copy link
Owner

timabell commented Jan 28, 2024

Interesting, just had a look, I see the leading zero for a section missing, but seems to be working within the section (I have run updates, so might have been partly fixed in dependencies.

Pushed a failing test for guid c7ebc802-7c75-4d0c-84af-093d1d004031 which illustrates the issue

    sse_test.go:833: Incorrect string 'c7ebc82-7c75-4dc-84af-93d1d04031' {colName:field_uniqueidentifier row:0 expectedType:un
iqueidentifier expectedString:c7ebc802-7c75-4d0c-84af-093d1d004031}, actual data type 'uniqueidentifier'  

https://github.com/timabell/schema-explorer/compare/guid-leading-zeros

Happy to look at any suggested fixes.

image

http://localhost:8821/tables/dbo.DataTypeTest?_rowLimit=100#data

@timabell timabell added bug Something isn't working help wanted Extra attention is needed good first issue Good for newcomers labels Jan 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants