Skip to content

Bug: crash when accelerating MySQL decimal using sqlite #2436

Closed

Description

@sgrebnov

Describe the bug
There is the following error when accelerating TPCH customer dataset using MySQL Data Connector and sqlite accelerator

2024-08-29T22:47:51.844035Z WARN runtime: Unable to attach data connector mysql: Unable to create dataset acceleration: Acceleration creation failed: Unable to create table: External error: Unable to create table in Sqlite: ConnectionClosed
thread '' panicked at /Users/sg/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sea-query-0.31.0/src/backend/sqlite/table.rs:157:29:

Decimal precision is 15.

SHOW COLUMNS FROM customer


c_custkey	int	NO	PRI		
c_name	varchar(25)	NO			
c_address	varchar(40)	NO			
c_nationkey	int	NO			
c_phone	char(15)	NO			
c_acctbal	decimal(15,2)	NO			
c_mktsegment	char(10)	NO			
c_comment	varchar(117)	NO			

Activity

  1. self-assigned this
    on Aug 29, 2024
  2. added this to the v0.17.3-beta milestone on Aug 29, 2024
  3. sgrebnov commented on Aug 30, 2024

    @sgrebnov
    ContributorAuthor
  4. added theissue type on Mar 24, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

kind/bugSomething isn't working

Type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions