LIKE operator issue in Ignite
We are trying to execute the following select queries with LIKE operator:
SELECT * FROM u24_166004_ltb
where customer_id like ('%059')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
There are records in the table where customer_id endsWith ('059') but still the query returns empty set.
SELECT * FROM u24_166004_ltb
where customer_id like ('%9')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
This query returns correct results.
The LIKE operator is not working as expected everytime. Why is it so? Is LIKE operator fully supported in Ignite? Is there any equivalent for LIKE operator in Ignite?
Please go through the enclosed attachment for more details. The attachment clearly shows records that end with ('059').
Regards,
Shravya Nethula.
sql-like ignite
edited Nov 22 '18 at 12:55
executable
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
add a comment |
We are trying to execute the following select queries with LIKE operator:
SELECT * FROM u24_166004_ltb
where customer_id like ('%059')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
There are records in the table where customer_id endsWith ('059') but still the query returns empty set.
SELECT * FROM u24_166004_ltb
where customer_id like ('%9')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
This query returns correct results.
The LIKE operator is not working as expected everytime. Why is it so? Is LIKE operator fully supported in Ignite? Is there any equivalent for LIKE operator in Ignite?
Please go through the enclosed attachment for more details. The attachment clearly shows records that end with ('059').
Regards,
Shravya Nethula.
sql-like ignite
edited Nov 22 '18 at 12:55
executable
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
1
Why are you putting parentheses around the argument toLIKE?LIKEis not a function in SQL. Try this:SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'
– Tim Biegeleisen
Nov 22 '18 at 9:42
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48
add a comment |
We are trying to execute the following select queries with LIKE operator:
SELECT * FROM u24_166004_ltb
where customer_id like ('%059')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
There are records in the table where customer_id endsWith ('059') but still the query returns empty set.
SELECT * FROM u24_166004_ltb
where customer_id like ('%9')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
This query returns correct results.
The LIKE operator is not working as expected everytime. Why is it so? Is LIKE operator fully supported in Ignite? Is there any equivalent for LIKE operator in Ignite?
Please go through the enclosed attachment for more details. The attachment clearly shows records that end with ('059').
Regards,
Shravya Nethula.
sql-like ignite
edited Nov 22 '18 at 12:55
executable
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
We are trying to execute the following select queries with LIKE operator:
SELECT * FROM u24_166004_ltb
where customer_id like ('%059')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
There are records in the table where customer_id endsWith ('059') but still the query returns empty set.
SELECT * FROM u24_166004_ltb
where customer_id like ('%9')
ORDER BY id asc OFFSET 0 ROWS FETCH NEXT 1012 ROWS ONLY
This query returns correct results.
The LIKE operator is not working as expected everytime. Why is it so? Is LIKE operator fully supported in Ignite? Is there any equivalent for LIKE operator in Ignite?
Please go through the enclosed attachment for more details. The attachment clearly shows records that end with ('059').
Regards,
Shravya Nethula.
sql-like ignite
sql-like ignite
edited Nov 22 '18 at 12:55
executable
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
edited Nov 22 '18 at 12:55
executable
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
edited Nov 22 '18 at 12:55
executable
1,8702822
edited Nov 22 '18 at 12:55
executable
1,8702822
edited Nov 22 '18 at 12:55
executable
1,8702822
1,8702822
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
asked Nov 22 '18 at 9:30
Shravya NethulaShravya Nethula
11
11
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
1
Why are you putting parentheses around the argument toLIKE?LIKEis not a function in SQL. Try this:SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'
– Tim Biegeleisen
Nov 22 '18 at 9:42
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48
add a comment |
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
1
Why are you putting parentheses around the argument toLIKE?LIKEis not a function in SQL. Try this:SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'
– Tim Biegeleisen
Nov 22 '18 at 9:42
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
1
1
Why are you putting parentheses around the argument to
LIKE? LIKE is not a function in SQL. Try this: SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'– Tim Biegeleisen
Nov 22 '18 at 9:42
Why are you putting parentheses around the argument to
LIKE? LIKE is not a function in SQL. Try this: SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'– Tim Biegeleisen
Nov 22 '18 at 9:42
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427705%2flike-operator-issue-in-ignite%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427705%2flike-operator-issue-in-ignite%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You might want to include some sample data in your question.
– Tim Biegeleisen
Nov 22 '18 at 9:38
1
Why are you putting parentheses around the argument to
LIKE?LIKEis not a function in SQL. Try this:SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059'– Tim Biegeleisen
Nov 22 '18 at 9:42
The following is the sample data from the table: Query: SELECT id, customer_id, quantity FROM u24_166004_ltb limit 10 ID, CUSTOMER_ID, QUANTITY 1041, 1000005059, 16 1073, 1000048059, 24 1089, 1000012059, 210 1105, 1000005059, 1 1121, 1000048059, 3 1137, 1000048059, 8 1153, 1000048059, 400 1169, 1000005059, 608 1201, 1000012059, 2 1233, 1000005059, 3
– Shravya Nethula
Nov 23 '18 at 5:25
SELECT * FROM u24_166004_ltb WHERE customer_id LIKE '%059' I have tried this query and it is still returning empty result set.
– Shravya Nethula
Nov 23 '18 at 5:29
I have tried it on 2.7 and I can get both queries to return all results.
– alamar
Dec 14 '18 at 16:48