SQL query returns different column names local v cloud

[benwis]

Describe the bug
I want to run this query to get a count of the number of posts in the blog

        let rowset = con.execute("SELECT COUNT(*) FROM posts;", &[]).map_err(|e| {
                    println!("SQL ERROR: {e}");
                    BenwisAppError::NotFound
        })?;
        let count = rowset.rows().nth(0).map(|row| {
            row.get::<i64>("COUNT(*)").unwrap().to_owned()
       }).unwrap_or(0);

This runs fine locally, but on the server it panicked. Some debugging ensued, and I discovered that the column name returned from the local version is COUNT(*) and the cloud version is COUNT (*). That extra space is what threw me for a loop.

Frequency of the bug
Please check one:

• Consistent repro
• Intermittent repro
• No repro

Set-up information
Please share the version of Spin used when the bug occurred. You can find the version of Spin by running spin -V.
Spin 2.4.2

[itowlson]

Thanks for flagging this @benwis! Per the linked issue, this is now fixed in Turso/libsql, but will take a little while to roll out to their production environment. In the meantime the proposed workaround is to do a SELECT COUNT(*) AS <something> to force the column name to be predictable. (I think you already have your own workaround, but I wanted to capture this in case other folks ran into it.)

[benwis]

Good to know! I ended up matching on both COUNT options, but that's a good solution too.

…

On Fri, Apr 19, 2024, at 12:57 PM, itowlson wrote: Thanks for flagging this @benwis <https://github.com/benwis>! Per the linked issue, this is now fixed in Turso/libsql, but will take a little while to roll out to their production environment. In the meantime the proposed workaround is to do a `SELECT COUNT(*) AS <something>` to force the column name to be predictable. (I think you already have your own workaround, but I wanted to capture this in case other folks ran into it.) — Reply to this email directly, view it on GitHub <#52 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABVBTCPOYFC2JKKEQRIGV23Y6FZLTAVCNFSM6AAAAABGOEQMPGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRXGIYDIMRWGU>. You are receiving this because you were mentioned.Message ID: ***@***.***>