isNumeric errors-out on dates from DB query

BoxLang
1

Failing test:

import testbox.system.BaseSpec

component extends=BaseSpec {

    function run() {
        describe("Repro cases for DB-oriented bugs", () => {
            it("mishandles dates from the DB", () => {
                var result = queryExecute("SELECT curdate() as my_date")

                expect(result).toHaveLength(1)
                expect(listFindNoCase(result.columnList, "my_date")).toBeTrue()
                expect(result.my_date[1]).notToBeNull()
                expect(result.my_date[1].getClass().getName()).toBe("java.sql.Date")
                expect(() => {
                    isNumeric(result.my_date[1])
                }).notToThrow()
            })
		})
    }
}

NB it’s MariaDB, using the BoxLang MySQL driver (which otherwise seems to work fine. Ish).

Can’t give you any further info on the exception, as none is returned (message and detail are blank). I’m raising this as a separate issue.

TBH, do you want this sort of thing here for visibility / discussion, or just they go straight into Jira?

1 Like
2

Thanks for the report!

For a bug this obvious, straight into Jira is cool with me. I’m confused right now if this is a JDBC typing issue, an isNumeric() issue, or something else. Either way, I copied some minimal details here: [BL-165] - Welcome

1 Like