Skip to content

Commit 3b17563

Browse files
asifabasharasifabashar
committed
unit test
Signed-off-by: Asif Bashar <asif.bashar@gmail.com>
1 parent 882b488 commit 3b17563

1 file changed

Lines changed: 11 additions & 11 deletions

File tree

‎ppl/src/test/java/org/opensearch/sql/ppl/calcite/CalcitePPLToNumberFunctionTest.java‎

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -28,7 +28,7 @@ public void testNumberBinary() {
2828
verifyResult(root, expectedResult);
2929

3030
String expectedSparkSql =
31-
"SELECT `TONUMBER`('010101', 2) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
31+
"SELECT TONUMBER('010101', 2) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
3232
verifyPPLToSparkSQL(root, expectedSparkSql);
3333
}
3434

@@ -45,7 +45,7 @@ public void testNumberBinaryUnsupportedResultNull() {
4545
verifyResult(root, expectedResult);
4646

4747
String expectedSparkSql =
48-
"SELECT `TONUMBER`('010.101', 2) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
48+
"SELECT TONUMBER('010.101', 2) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
4949
verifyPPLToSparkSQL(root, expectedSparkSql);
5050
}
5151

@@ -62,7 +62,7 @@ public void testNumberHex() {
6262
verifyResult(root, expectedResult);
6363

6464
String expectedSparkSql =
65-
"SELECT `TONUMBER`('FA34', 16) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
65+
"SELECT TONUMBER('FA34', 16) `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
6666
verifyPPLToSparkSQL(root, expectedSparkSql);
6767
}
6868

@@ -80,7 +80,7 @@ public void testNumberHexUnsupportedValuesResultNull() {
8080
verifyResult(root, expectedResult);
8181

8282
String expectedSparkSql =
83-
"SELECT `TONUMBER`('FA.34', 16) `double_value`\nFROM `scott`.`EMP`\nLIMIT 1";
83+
"SELECT TONUMBER('FA.34', 16) `double_value`\nFROM `scott`.`EMP`\nLIMIT 1";
8484
verifyPPLToSparkSQL(root, expectedSparkSql);
8585
}
8686

@@ -99,7 +99,7 @@ public void testNumberHexMinLimit() {
9999
verifyResult(root, expectedResult);
100100

101101
String expectedSparkSql =
102-
"SELECT `TONUMBER`('-7FFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
102+
"SELECT TONUMBER('-7FFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
103103

104104
verifyPPLToSparkSQL(root, expectedSparkSql);
105105
}
@@ -119,7 +119,7 @@ public void testNumberHexMaxLimit() {
119119
verifyResult(root, expectedResult);
120120

121121
String expectedSparkSql =
122-
"SELECT `TONUMBER`('7FFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
122+
"SELECT TONUMBER('7FFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
123123

124124
verifyPPLToSparkSQL(root, expectedSparkSql);
125125
}
@@ -139,7 +139,7 @@ public void testNumberHexOverNegativeMaxLimit() {
139139
verifyResult(root, expectedResult);
140140

141141
String expectedSparkSql =
142-
"SELECT `TONUMBER`('-FFFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
142+
"SELECT TONUMBER('-FFFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
143143

144144
verifyPPLToSparkSQL(root, expectedSparkSql);
145145
}
@@ -158,7 +158,7 @@ public void testNumberHexOverPositiveMaxLimit() {
158158
verifyResult(root, expectedResult);
159159

160160
String expectedSparkSql =
161-
"SELECT `TONUMBER`('FFFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
161+
"SELECT TONUMBER('FFFFFFFFFFFFFFFF', 16) `long_value`\nFROM `scott`.`EMP`\nLIMIT 1";
162162

163163
verifyPPLToSparkSQL(root, expectedSparkSql);
164164
}
@@ -175,7 +175,7 @@ public void testNumber() {
175175
String expectedResult = "int_value=4598.0\n";
176176
verifyResult(root, expectedResult);
177177

178-
String expectedSparkSql = "SELECT `TONUMBER`('4598') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
178+
String expectedSparkSql = "SELECT TONUMBER('4598') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
179179
verifyPPLToSparkSQL(root, expectedSparkSql);
180180
}
181181

@@ -192,7 +192,7 @@ public void testNumberDecimal() {
192192
verifyResult(root, expectedResult);
193193

194194
String expectedSparkSql =
195-
"SELECT `TONUMBER`('4598.54922') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
195+
"SELECT TONUMBER('4598.54922') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
196196
verifyPPLToSparkSQL(root, expectedSparkSql);
197197
}
198198

@@ -209,7 +209,7 @@ public void testNumberUnsupportedResultNull() {
209209
verifyResult(root, expectedResult);
210210

211211
String expectedSparkSql =
212-
"SELECT `TONUMBER`('4A598.54922') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
212+
"SELECT TONUMBER('4A598.54922') `int_value`\nFROM `scott`.`EMP`\nLIMIT 1";
213213
verifyPPLToSparkSQL(root, expectedSparkSql);
214214
}
215215
}

0 commit comments

Comments
 (0)