Casting issue for output configuration
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 48/100
Research direction
Start by reproducing the SQL Server destination case described in the output configuration, using a uniqueidentifier first column and the logged INSERT statement. Trace where the output builds the INSERT and adds SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident, then verify that the identifier is preserved without an incompatible cast and add coverage for this case if the repository has matching tests.
Written by the indexing model from the issue text.
Description
I'm having an issue pushing data into SQL Server using this plugin. It seems the only issue I'm having is the first column, which is configured as a unique identifier in both my source and destination databases, is being cast to an int or bigint when trying to ingest. I've checked my data being pulled from my source plugin and it is correct, it seems as though this plugin has some casting issue when using output configuration.
{"time":"2023-10-24T21:28:29","level":"warn","message":"Got deterministic error. Fallback to one-by-one import error_class_ActiveRecord::StatementInvalid error="TinyTds::Error: Conversion failed when converting from a character string to uniqueidentifier.:INSERT INTO [table1] ([id],[status],[ident]) VALUES ('1',N'Status1',1); SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident"","work_id:0}
If anyone has seen or knows a workaround for this that would be greatly appreciated.
- Dominant language
- Ruby
- Stars
- 112
- Forks
- 58
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from fluent/fluent-plugin-sql
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 35/100
fluent/fluent-plugin-sql#151 · 1 comment ·
-
enhancement
Difficulty 5/5 Over a week Newbie friendliness 25/100
fluent/fluent-plugin-sql#149 ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 42/100
fluent/fluent-plugin-sql#138 · 1 comment ·
-
fluent/fluent-plugin-sql#134 · 6 comments · 1 assignee ·
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 42/100
fluent/fluent-plugin-sql#133 · 2 comments ·
All issues in fluent/fluent-plugin-sql
Similar issues
-
SyncEm always forwards a dummy block, so wrapped methods lose their no-block/Enumerator behavior Open
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug P2
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
dependabot
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
githubnext/gh-aw-cao#13349 ·
-
user-reported
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
Kong/developer.konghq.com#7316 ·