search

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.64k stars 1.56k forks source link

bind dictionary params will crash #978

Open MingleChang opened 4 years ago

MingleChang commented 4 years ago

If I select use try! connect?.prepare("SELECT * FROM words WHERE category=:category AND language=:language ORDER BY RANDOM()", ["category":category, "language":language]) it will crash, like this 76F3D71E-D6A8-4F6F-9C7E-BD9CD5AF8CA7

But use try! connect?.prepare("SELECT * FROM words WHERE category=? AND language=? ORDER BY RANDOM()", [category, language]) it‘s OK

nathanfallet commented 3 years ago

@MingleChang Try to use $category instead of :category and tell me if it works.