History | Log In     View a printable version of the current page.  
   HOME       BROWSE PROJECT       FIND ISSUES   
    QUICK SEARCH:  
Issue Details (XML | Word | Printable)

Key: SQL-29
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Bob Swift
Reporter: Andy Brook
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Confluence SQL Plugin

Upgrade to 2.6.1 from 2.5.6, table and columns are now case-sensitive...

Created: 21/Nov/07 11:24 AM   Updated: 21/Nov/07 12:38 PM
Component/s: SQL macro
Affects Version/s: 3.3.0
Fix Version/s: None

Time Tracking:
Not Specified

Environment:
System Information
System Date Wednesday, 21 Nov 2007
System Time 09:20:45
System Favourite Colour Ecru
Java Version 1.5.0_11
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.5.0_11-b03
Java Runtime Java(TM) 2 Runtime Environment, Standard Edition
Java VM Java HotSpot(TM) Server VM
User Name axbadmin
User Timezone America/Los_Angeles
Operating System Windows 2003 5.2
OS Architecture x86
Filesystem Encoding Cp1252

Java VM Memory Statistics
Total Memory 1171 MB
Free Memory 561 MB
Used Memory 610 MB
Memory Graph
[Used Memory (52 %)] [Free Memory (48 %)]
48 % Free

Runtime Information
Database Dialect net.sf.hibernate.dialect.SQLServerDialect
Database Connection URL java:/ConfluenceDS
Database Driver Name N/A
Database Driver Version N/A
Application Server JBossWeb/2.0.0.GA
Servlet Version 2.5
Server Base Url http://confluence.dolby.net/kb
Confluence Home D:\srv\confluence\us
Uptime 2 , 3 , 16
Confluence Version 2.6.1
Build Number 916

Labels:


 Description  « Hide
I just upgraded from 2.5.6 and found all SQL queries that were previously running fine were now broken. I traced this to all SQL table and column references requiring to be lower case, to match the database (I was checking with SQL Server client app).

Its weird that half of confluence tables are upper case and some are lower case. Is there something going on? Why case sensitive? is SQL case sensitive, I thought not?

SQL Server Info:

Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600


 All   Comments   Work Log   Change History   FishEye   Crucible   Related Builds      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Bob Swift - 21/Nov/07 12:27 PM
Did you change DBs? Case sensitivity seems to be database specific - probably something left out of the SQL standard (like many other things )

[ Permlink | « Hide ]
Andy Brook - 21/Nov/07 12:38 PM
Hi Bob. No I didn't change the DB, AFAICR its been the same since it was installed. SQLServer. My example pulled out a count of 'confluence-users', this was working religiously until I upgraded, then it didnt, and was case sensitive. All db drivers (jtds) remain the same. hence bug, it stumped me :/

Ill chase my network people and see if they snuck in any amazingly coincidental bug-fixing



Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.12.2-#300) - Bug/feature request - Atlassian news - Contact Administrators