Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
freebsd
GitHub Repository: freebsd/freebsd-ports
Path: blob/main/astro/kstars/files/patch-kstars_catalogsdb_sqlstatements.cpp
46591 views
1
--- kstars/catalogsdb/sqlstatements.cpp.orig
2
+++ kstars/catalogsdb/sqlstatements.cpp
3
@@ -317,8 +317,8 @@
4
const QString _dso_by_name =
5
- "SELECT %1, name like \"%\" || :name || \"%\" AS in_name, long_name like "
6
- "\"%\" || :name || \"%\" AS in_lname FROM master WHERE in_name "
7
+ "SELECT %1, name like '%' || :name || '%' AS in_name, long_name like "
8
+ "'%' || :name || '%' AS in_lname FROM master WHERE in_name "
9
"OR in_lname "
10
"ORDER BY name, long_name, "
11
"%2 LIMIT :limit";
12
13