Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Select statement throwing too large for column error #7588

Closed
timsehn opened this issue Mar 8, 2024 · 3 comments
Closed

Select statement throwing too large for column error #7588

timsehn opened this issue Mar 8, 2024 · 3 comments
Assignees
Labels
bug Something isn't working correctness We don't return the same result as MySQL good repro Easily reproducible bugs integrations Issues with tools connecting to/querying Dolt

Comments

@timsehn
Copy link
Contributor

timsehn commented Mar 8, 2024

media_wiki/main> SELECT /* Wikimedia\\Rdbms\\DatabaseMySQL::serverIsReadOnly */ @@GLOBAL.read_only AS Value
              -> ;
media_wiki/main> SELECT /* MediaWiki\\Interwiki\\ClassicInterwikiLookup::load */ iw_prefix,iw_url,iw_api,iw_wikiid,iw_local,iw_trans FROM `interwiki` WHERE iw_prefix = "children's_book_of_the_year_award" LIMIT 1; 
Error 1105 (HY000): string 'children's_book_of_the_year_award' is too large for column 'varbinary(32)'
media_wiki/main> show create table interwiki
              -> ;
+-----------+-------------------------------------------------------+
| Table     | Create Table                                          |
+-----------+-------------------------------------------------------+
| interwiki | CREATE TABLE `interwiki` (                            |
|           |   `iw_prefix` varbinary(32) NOT NULL,                 |
|           |   `iw_url` blob NOT NULL,                             |
|           |   `iw_api` blob NOT NULL,                             |
|           |   `iw_wikiid` varbinary(64) NOT NULL,                 |
|           |   `iw_local` tinyint(1) NOT NULL,                     |
|           |   `iw_trans` tinyint NOT NULL DEFAULT '0',            |
|           |   PRIMARY KEY (`iw_prefix`)                           |
|           | ) ENGINE=InnoDB DEFAULT CHARSET=binary COLLATE=binary |
+-----------+-------------------------------------------------------+
1 row in set (0.00 sec)
@timsehn timsehn added bug Something isn't working integrations Issues with tools connecting to/querying Dolt good repro Easily reproducible bugs correctness We don't return the same result as MySQL labels Mar 8, 2024
@timsehn
Copy link
Contributor Author

timsehn commented Mar 8, 2024

This is needed to import English Wikipedia.

@timsehn
Copy link
Contributor Author

timsehn commented Mar 9, 2024

Same error on different query:

media_wiki/main> SELECT /* MediaWiki\\Interwiki\\ClassicInterwikiLookup::load */ iw_prefix,iw_url,iw_api,iw_wikiid,iw_local,iw_trans FROM `interwiki` WHERE iw_prefix = 'köppen_climate_classification#group_d' LIMIT 1;
Error 1105 (HY000): string 'köppen_climate_classification#group_d' is too large for column 'varbinary(32)'

This is using the build @jycor sent me with the fix.

@jycor
Copy link
Contributor

jycor commented Mar 11, 2024

Fix is here and is merged to gms main.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working correctness We don't return the same result as MySQL good repro Easily reproducible bugs integrations Issues with tools connecting to/querying Dolt
Projects
None yet
Development

No branches or pull requests

2 participants