Forgot Password,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
Home/ Questions/Q 103281
Next
In Process

databaseanswers.net Latest Questions

  • 1
Clara
Beginner
Asked: 2020-08-03T16:08:51-04:00

Query SQLite using uuid returns nothing

I’m querying a SQLite db file using the id column, which is UNIQUEIDENTIFIER type.

The two commands are :

SELECT * FROM scanned_images WHERE id = cast('5D878B98-71B2-4DEE-BA43-61D11C8EA497' as uniqueidentifier)

or

SELECT * FROM scanned_images WHERE id = '5D878B98-71B2-4DEE-BA43-61D11C8EA497'

However, the above commands both returned nothing.

I also tried:

SELECT * FROM scanned_images WHERE rowid = 1

this command returns the correct data.

enter image description here

enter image description here

enter image description here

sqliteuuid

Related Questions

Leave an answer

You must login to add an answer.

Need An Account,

1 Answer

Voted Oldest Recent Random
  1. forpas

    There is no uniqueidentifier data type in SQLite.
    According to the rules of type affinity described here in 3.1. Determination Of Column Affinity, the column’s affinity is numeric.
    All that this expression does:

    cast('5D878B98-71B2-4DEE-BA43-61D11C8EA497' as uniqueidentifier)

    is return 5.

    You should have defined the column’s data type as TEXT, because you have to treat it like TEXT and write the condition:

    WHERE id = '5D878B98-71B2-4DEE-BA43-61D11C8EA497'

    or:

    WHERE id = '(5D878B98-71B2-4DEE-BA43-61D11C8EA497)'

    if as shown in the image it contains surrounding parentheses.

    • 1