Bug Report: create table statement breaks if database.table is specified and column of type text with optional lenght #17904
Assignees
Comments
LuigiMiazzo17
added
Needs Triage
shlomi-noach
added
Component: Query Serving
Type: Question
and removed
Needs Triage
|
what does |
|
As in this other issue I opened, |
|
Confirmed. On an examples/101 cluster: mysql> drop table if exists tbl; CREATE TABLE commerce.tbl (col TEXT);
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> drop table if exists tbl; CREATE TABLE commerce.tbl (col TEXT(1024));
Query OK, 0 rows affected (0.01 sec)
ERROR 1049 (42000): target: commerce.0.primary: vttablet: rpc error: code = InvalidArgument desc = Unknown database 'commerce' (errno 1049) (sqlstate 42000) (CallerID: userData1): Sql: "CREATE TABLE commerce.tbl (col TEXT(1024))", BindVars: {}
mysql> drop table if exists tbl; CREATE TABLE tbl (col TEXT(1024));
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> show create table tbl\G
*************************** 1. row ***************************
Table: tbl
Create Table: CREATE TABLE `tbl` (
`col` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.01 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Overview of the Issue
An
Unknown database 'db_name'error is returned when a table is created with theCREATE TABLEstatement specifying bothdb_name.table_name(assuming the keyspacedb_nameexists) for the table name and at least one column is of typeTEXT(m), wheremis the optional maximum lenght used to determine which kind of text type the column is as described in the mysql docs. If either the lenght or the database name is removed, then it works as expected.Reproduction Steps
After creating a keyspace, run the following query:
CREATE TABLE keyspace_name.table (col TEXT(1024));.Observe the error.
Binary Version
Operating System and Environment details
Log Fragments
The text was updated successfully, but these errors were encountered: