The server response ons SELECT query is not properly formatted

[tvb2]

Using sqlitecloud lib for Kotlin, I am making a SELECT request:
SELECT * FROM items WHERE dateTimeModified = (SELECT MAX(dateTimeModified) FROM items) LIMIT 1
which returns data in the following format. It's missing commas between column values, and the column names and types are mixed in with the data. This makes it very difficult to reliably extract the data. It seems like the SQLiteCloud library is not correctly formatting the Rowset data when it's returning it from the server:
SQLiteCloudRowset(columns=[id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, finalAmount 7 regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, regular 11 userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, userCreated 12 userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2, userModified 3 INT 7 varchar 7 varchar 7 varchar 6 double 7 varchar 6 double 6 Double 7 Boolean 7 varchar 7 varchar 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 4 main 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 5 items 2 id 11 dateCreated 16 dateTimeModified 8 category 6 amount 8 currency 8 exchRate 11 finalAmount 7 regular 11 userCreated 12 userModified:0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 :0 10 2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2], rows=[[Integer(value=0), String(value=2025-02-20 32 2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2), String(value=2025-02-20T21:25:44.034511-05:00 4 Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2), String(value=Fuel,99.0 3 CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2), Double(value=99.0), String(value=CAD,1.0 ,99.0 4 true 4 tvb2 4 tvb2), Double(value=1.0), Double(value=99.0), String(value=true 4 tvb2 4 tvb2), String(value=tvb2 4 tvb2), String(value=tvb2)]])

[marcobambini]

Hi @tvb2, can you please share an example of the code you used to get this result?

[tvb2]

Hi @marcobambini ,
this is a snippet of code I was using:
fun selectLatest(context: Context) {
val configuration = SQLiteCloudConfig.fromString(mainUiState.value.connectionString)
val sqLiteCloud = SQLiteCloud(appContext = context, config = configuration)
val items = mutableListOf()
CoroutineScope(Dispatchers.IO).launch {
sqLiteCloud.connect()
val r =
sqLiteCloud.execute("SELECT * FROM items WHERE dateTimeModified = (SELECT MAX(dateTimeModified) FROM items) LIMIT 1")
Log.d("Select latest1", r.value.toString())
when (r) {
is SQLiteCloudResult.Rowset -> {
val rowset = r.value
val columns = rowset.columns // Assuming this is a List
val itemData = mutableMapOf<String, Any?>()
for (row in rowset.rows) { // Assuming this is a List<List>
for ((index, value) in row.withIndex()) {
val columnName = columns[index]
itemData[columnName] = value.toKotlinValue()
}
}

[damlayildiz]

Hi @tvb2, we are currently working on this issue and will provide an update as soon as possible.

[damlayildiz]

Hi @tvb2, the issue has now been fixed. Please update your SQLiteCloud module with the current version, and let us know if you encounter any further issues.

[tvb2]

Hi, @damlayildiz ! Thanks for the quick fix! I'll give it a try and if there will be any issues, will let you know!