Wrong numeric data type mapping

[gsbingo17]

Verify the numeric data type mapping using the following schema and sample code.

package main

import (
	"fmt"

	"github.com/shopspring/decimal"

	spannergorm "github.com/googleapis/go-gorm-spanner"
	"gorm.io/gorm"

	"gorm.io/gorm/logger"
)

type Product struct {
	ID    string              `gorm:"column:id"`
	Name  string              `gorm:"column:name"`
	Price decimal.NullDecimal `gorm:"column:price;type:NUMERIC"`
}

func main() {

	// Replace with your actual Cloud Spanner project, instance, and database
	dsn := "projects/project-id/instances/test-202304/databases/testdb"

	db, err := gorm.Open(spannergorm.New(spannergorm.Config{
		DriverName: "spanner",
		DSN:        dsn,
	}), &gorm.Config{
		Logger: logger.Default.LogMode(logger.Info),
	})

	if err != nil {
		panic("failed to connect database")
	}

	// Insert a new product
	newProduct := Product{
		ID:    "2",
		Name:  "apple",
		Price: decimal.NullDecimal{Decimal: decimal.NewFromFloat(19.99), Valid: true},
	}

	if err := db.Create(&newProduct).Error; err != nil {
		panic(err)
	}

	fmt.Println("Inserted new product:", newProduct)

	// Query products where name is 'tom' with a limit
	var products []Product
	if err := db.Table("product").
		Clauses(spannergorm.ForceIndex("name_idx")).
		Where("name = ?", "apple").
		Limit(10).
		Find(&products).Error; err != nil {
		panic(err)
	}

	fmt.Println("Products with name 'apple' (limited to 10):", products)

}

create table products (
  id string(max),
  name string(max),
  price numeric
) primary key(id)

When the sample is executed, the following error is encountered.

spanner: code = "InvalidArgument", desc = "Value has type STRING which cannot be inserted into column price, which has type NUMERIC [at 1:62]\\nINSERT INTO `products` (`id`,`name`,`price`) VALUES (@p1,@p2,@p3)\\n