Repository navigation
Commit 2c89bdf
[fix](jdbc) Push SQL Server/Oracle boolean predicates as 1/0 instead of TRUE/FALSE
SQL Server `bit` (and Oracle, which has no native boolean type) maps to
Doris BOOLEAN. A predicate such as `bit_value = '1'` is folded to a
boolean literal during analysis, and JdbcScanNode.conjunctExprToString()
pushes it down via Expr.toExternalSql(), which renders BoolLiteral as
the dialect-agnostic TRUE/FALSE keyword. SQL Server has no boolean
literal and reports it as an identifier:
SQLServerException: Invalid column name 'TRUE'.
Render boolean literals as 1/0 for databases without a native boolean
type (SQLSERVER, ORACLE, OCEANBASE_ORACLE), mirroring the existing
dialect-specific date-literal handling in the same method. MySQL,
PostgreSQL and Trino keep TRUE/FALSE (PostgreSQL requires the keyword
for its strict boolean type).
This matches the behavior already present on master, where the JDBC
pushdown was refactored to the connector SPI and
JdbcQueryBuilder.formatBooleanLiteral() renders booleans per dialect.
Related apache#64464
Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>1 parent 2c6ceab commit 2c89bdf
3 files changed
Lines changed: 150 additions & 0 deletions
File tree
- fe/fe-core/src
- main/java/org/apache/doris/datasource/jdbc/source
- test/java/org/apache/doris/datasource/jdbc/source
- regression-test/suites/external_table_p0/jdbc
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
391 | 391 | | |
392 | 392 | | |
393 | 393 | | |
| 394 | + | |
| 395 | + | |
| 396 | + | |
| 397 | + | |
| 398 | + | |
| 399 | + | |
| 400 | + | |
| 401 | + | |
| 402 | + | |
| 403 | + | |
| 404 | + | |
| 405 | + | |
| 406 | + | |
| 407 | + | |
| 408 | + | |
| 409 | + | |
| 410 | + | |
| 411 | + | |
| 412 | + | |
| 413 | + | |
| 414 | + | |
| 415 | + | |
| 416 | + | |
| 417 | + | |
| 418 | + | |
| 419 | + | |
| 420 | + | |
| 421 | + | |
394 | 422 | | |
395 | 423 | | |
396 | 424 | | |
| |||
458 | 486 | | |
459 | 487 | | |
460 | 488 | | |
| 489 | + | |
| 490 | + | |
| 491 | + | |
| 492 | + | |
| 493 | + | |
| 494 | + | |
| 495 | + | |
| 496 | + | |
| 497 | + | |
| 498 | + | |
| 499 | + | |
| 500 | + | |
| 501 | + | |
| 502 | + | |
| 503 | + | |
| 504 | + | |
461 | 505 | | |
462 | 506 | | |
463 | 507 | | |
| |||
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
626 | 626 | | |
627 | 627 | | |
628 | 628 | | |
| 629 | + | |
| 630 | + | |
| 631 | + | |
| 632 | + | |
| 633 | + | |
| 634 | + | |
| 635 | + | |
| 636 | + | |
| 637 | + | |
| 638 | + | |
| 639 | + | |
| 640 | + | |
| 641 | + | |
| 642 | + | |
| 643 | + | |
| 644 | + | |
| 645 | + | |
| 646 | + | |
| 647 | + | |
| 648 | + | |
| 649 | + | |
| 650 | + | |
| 651 | + | |
| 652 | + | |
| 653 | + | |
| 654 | + | |
| 655 | + | |
| 656 | + | |
| 657 | + | |
| 658 | + | |
| 659 | + | |
| 660 | + | |
| 661 | + | |
| 662 | + | |
| 663 | + | |
| 664 | + | |
| 665 | + | |
| 666 | + | |
| 667 | + | |
| 668 | + | |
| 669 | + | |
| 670 | + | |
| 671 | + | |
| 672 | + | |
| 673 | + | |
| 674 | + | |
| 675 | + | |
| 676 | + | |
| 677 | + | |
| 678 | + | |
| 679 | + | |
| 680 | + | |
| 681 | + | |
| 682 | + | |
| 683 | + | |
| 684 | + | |
| 685 | + | |
| 686 | + | |
| 687 | + | |
| 688 | + | |
| 689 | + | |
| 690 | + | |
| 691 | + | |
| 692 | + | |
| 693 | + | |
| 694 | + | |
| 695 | + | |
| 696 | + | |
| 697 | + | |
| 698 | + | |
| 699 | + | |
| 700 | + | |
| 701 | + | |
| 702 | + | |
| 703 | + | |
| 704 | + | |
| 705 | + | |
| 706 | + | |
| 707 | + | |
| 708 | + | |
| 709 | + | |
| 710 | + | |
| 711 | + | |
| 712 | + | |
| 713 | + | |
629 | 714 | | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
139 | 139 | | |
140 | 140 | | |
141 | 141 | | |
| 142 | + | |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
| 148 | + | |
| 149 | + | |
| 150 | + | |
| 151 | + | |
| 152 | + | |
| 153 | + | |
| 154 | + | |
| 155 | + | |
| 156 | + | |
| 157 | + | |
| 158 | + | |
| 159 | + | |
| 160 | + | |
| 161 | + | |
| 162 | + | |
142 | 163 | | |
143 | 164 | | |
144 | 165 | | |
| |||
0 commit comments