QueryByExample Bug

[Maxmix]

I am pasting 8138 into a varchar cell and PLSQL Developer rewrites the query by adding:

(upper(mctrnum) like '?138%')

I wonder what is this '?' character for?

 

[Marco Kalter]

I can't reproduce this. It would seem that the "8" is pasted as something else in your case. If you type 8138 in notepad, copy it, and paste it in the QBE field, does it still fail?

 

[Maxmix]

This is not the copy-paste problem. I could type 8138 into the cell and result is the same.

More testing was done and it seems I cannot enter any digit as the first letter, otherwise it turns into the question mark.

Try yourself please (table can be empty):
1) create table SSSS ( m_notes VARCHAR2(1000));
2) select * from ssss
3) run QBE with the value= 6
4) observe the condition added:
where upper(m_notes) like '?%'

 

[Marco Kalter]

This example works fine for me. Can you go to Help > Support Info and send me the text from the "Info" page? Maybe it's a character set related issue.

 

[Maxmix]

Here it is. BTW, the behaviour is the same in PLSQL Dev v.12

PL/SQL Developer
  Version 11.0.6.1776
  11.112638 - 5 user license
  Service Contract: 01.04.2018
  Windows 7 (64-bit) Build 7601 (Service Pack 1)

  Physical memory : 4,194,304 kB  (4,194,304 available)
  Paging file     : 4,194,304 kB  (4,194,304 available)
  Virtual memory  : 2,097,024 kB  (1,617,312 available)

Parameters
  C:\ORACLE\PLSQLDev11\PLSQLDev.exe
  D:\REaliz\__текущая всячина\_Ctrs\CTRS-new\Проекты\проект  СОСТОЯНИЯ-ЭТАПЫ\CONVERT_IT\ConvertHist_pkg.pck

Preferences
  Session mode: Multi
  OCI Library: c:\oracle\product.2.0\client_1\bin\oci.dll
  Use OCI7: False
  Allow Multiple Connections: False

Preference Files
  C:\ORACLE\PLSQLDev11\Preferences\Default\Default.ini
  C:\Users\ZykovMM\AppData\Roaming\PLSQL Developer\Preferences\ZykovMM\default.ini

License File
  C:\ORACLE\PLSQLDev11\aalf.dat

Debug file
  C:\ORACLE\PLSQLDev11\PlSqlDev.elf

Plug-Ins
  *Browser Extender version 2.0 by Joachim Rupik (C:\ORACLE\PLSQLDev11\PlugIns\be.dll)
  *Comment lines v1.4 (C:\ORACLE\PLSQLDev11\PlugIns\commentline.dll)
  *Editor Enhancement v1.5 (C:\ORACLE\PLSQLDev11\PlugIns\editorenhancement.dll)
  *Favorites v2.1 (C:\ORACLE\PLSQLDev11\PlugIns\Favorites.dll)
   Quick/ER - Gotterup.Net (C:\ORACLE\PLSQLDev11\PlugIns\QuickERPlugin.dll)
  *Sailora (C:\ORACLE\PLSQLDev11\PlugIns\sailora.dll)
   ScrapBook (C:\ORACLE\PLSQLDev11\PlugIns\ScrapBook.dll)
  *TortoiseSVN add-in (C:\ORACLE\PLSQLDev11\PlugIns\SVN_Plugin.dll)
   Templates (C:\ORACLE\PLSQLDev11\PlugIns\template.dll)
  *ToggleReadOnly (C:\ORACLE\PLSQLDev11\PlugIns\ToggleReadOnly.dll)
   Version Control Interface 1.2 (C:\ORACLE\PLSQLDev11\PlugIns\VCS.dll)
   (* is Active)

Aliases
  CDBFALSE_TNS
  devCenter
  devFilial
  egp
  hq_ro
  ...

Homes
  OraClient11g_home1  (c:\oracle\product.2.0\client_1)
  OraClient12Home1_32bit  (C:\ORACLE\product\ODT_12.1)

DLLs
  c:\oracle\product.2.0\client_1\bin\oci.dll

TNS File
  C:\ORACLE\product.2.0\client_1\network\admin\tnsnames.ora

Using
  Home: OraClient11g_home1
  DLL: c:\oracle\product.2.0\client_1\bin\oci.dll
  OCI: version 11.1
  Oracle Database 10g Enterprise Edition Release 10.2.0.5.0

Character Sets
  Character size: 1 byte(s)
  CharSetID: 0
  NCharSetID: 1
  Unicode Support: False
  NLS_LANG: AMERICAN_AMERICA.CL8MSWIN1251
  NLS_NCHAR_CHARACTERSET: AL16UTF16
  NLS_CHARACTERSET: CL8MSWIN1251

Monitor
  Id = 0
  Primary = True
  Handle = 65537
  Left = 0
  Top = 0
  Width = 1920
  Height = 1080

  MainFormOnTaskbar = False

 

[Marco Kalter]

Thanks. We'll try to reproduce.