[JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4668.
-----------------------------------
Resolution: Done
Updated the logic to better handle nulls for update and insert. In the update case we can
allow nulls except for string values as there seems to be no way to differentiate between
an empty string - but there is a difference between null and empty when reading from a
sheet so we'll produce an exception for now.
Google translator skips NULL value in INSERT
--------------------------------------------
Key: TEIID-4668
URL: https://issues.jboss.org/browse/TEIID-4668
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.8.6_3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 9.0.6, 9.1.2, 9.2
Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml
I have google spreadsheet table smalla with defined header columns intkey, intnum and
other (see attached screenshot).
Following query doesn't insert NULL value to column intnum:
INSERT INTO smalla(intnum, intkey) values (null, 562)
Instead, it inserts 562 to intnum and NULL to intkey.
(Server log shows no exception)
INSERT works correctly if none of the inserted values is NULL.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
3192
days inactive
3192
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)